Pages

Search

Excel Help Forum - Excel Programming / VBA / Macros: Copy/insert additional data entry rows

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Copy/insert additional data entry rows
My firewall at work will not let me attach my sample to this message. I have sheet within a large workbook used for auditing where the user can enter multiple "additional workers." The worker field is a range of 5 rows with formatting. I would like to create a button that will add spaces for...

Excel Help Forum - Excel General: Problem in Bulk import of Excel data into SQL

Feed2Mail notification - new post on Excel Help Forum - Excel General
Problem in Bulk import of Excel data into SQL
Hi I am trying to import data from Excel 2010 to Mssql 2008, can anyone help me I am trying this query, it throws 'incorrect syntax near IN' insert into psn_shift select * from [tabledata] IN 'c:\import-into-sql.xlsm' 'Excel 12.0 Macro;HDR=YES;' Even i tried the option suggested by RS, ...

Open Office - [discuss] Bilingual documents

Open Office - [discuss] Bilingual documents


[discuss] Bilingual documents

Posted: 09 Feb 2006 08:47 AM PST


Beat Ackermann wrote: 

OpenOffice still does not have a grammar checker.

But under 2.0 and up you can use multiple languages easily and have
them spell-checked without changing the default language. Indeed,
simply changing the default language now does nothing in respect to
changing text language. The languages you use in your document and
which you wish to be spell checked can be entirely different from the
default language.

The direct formatting specification for language is found under Format
-> Character -> Font. Language can also be set for any paragraph style
or character style by right-clicking on the style in the Stylelist,
selecting "Modify ...". selecting the Font tab, and changing the
language. So you can apply different languages to any part of your
docuent either through style or by direct formatting.

Spell checking works fine on mxied language documents, calling in the
proper dictionaries transparently and often suggests a possible
language in which a particular "error" might be assigned to (that is, a
language in which the error would be correct).

Jallan

[discuss] Correction to vnunet.com article

Posted: 08 Feb 2006 01:16 PM PST

Hi Louis,

Louis Suarez-Potts <com> schrieb:
 

I can tell you, that the German PR-Team has emailed yesterday evening to
heise (and some others news-pages, where this news appeared) and asked
for a correction.

I'll tell you about the results.


Sigrid

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Quickbooks

Posted: 08 Feb 2006 12:37 PM PST

Gnucash, Kmymoney, and Moneydance are different bookeeping softwares. But
I dont think there is any integration with OOo.

Having a further research I find TinyERP which does have integration but
is not a real bookeeping software. Is more like a Business Management
System.

To do Bookeeping in Calc there are macros such as Calc2qif
(http://ooomacros.org/user.php#102787)

On Wed, 08 Feb 2006 14:48:42 -0600, Paul <com> wrote:
 



--
Alexandro Colorado
CoLeader of OpenOffice.org ES
http://es.openoffice.org

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Translation - library or part of a complete OpenOffice.org?

Posted: 08 Feb 2006 11:12 AM PST

Then I think the best place to ask this question is from the people
working at the project at

http://l10n.openoffice.org/ for dictionaries (part of language packs)
http://lingucomponent.openoffice.org/

On Wed, 08 Feb 2006 13:39:36 -0600, Konrad
<onet.pl> wrote:
 



--
Alexandro Colorado
CoLeader of OpenOffice.org ES
http://es.openoffice.org

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] .wdb files

Posted: 08 Feb 2006 08:46 AM PST

------=_Part_19118_7172916.1139503143022
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On 2/9/06, Chad Smith <com> wrote:
 
e. 

Or, you can pay $70 for StarOffice (which is based on OpenOffice.org) - and
it can open a lot more files than OOo. I'm not sure if .wdb is one of them=
,
but there is a very good chance that it is. (StarOffice doesn't work on
Mac, so I can't say for sure.)

--
- Chad Smith
http://www.gimpshop.net/
Because everyone loves free software!

------=_Part_19118_7172916.1139503143022--

[discuss] Project Add On

Posted: 07 Feb 2006 04:42 PM PST

On Tue, 7 Feb 2006, Alexandro Colorado wrote:
 
=20 
d =20 
d =20 
=20 
=20 

The URL is http://oopm.openoffice.org/

The project is still in the analyze/requirements phase.

We could still need more volunteers so every body with skills related to=20
project management tools and development are very appreaciated.=20

The most enjoyable greetings
--=20
Claus Agerskov ###=3D Analyze OpenOffice.org
Co-lead/owner #=3D=3D=3D Requirements Project Management T=
ool
org =3D=3D=3D=3D Design/model Subproject =
=20
http://ooo.chbs.dk/ =3D=3D=3D=3D Implement http://oopm.openoff=
ice.org/

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] OpenOffice.org Calc - Linefeed

Posted: 07 Feb 2006 04:40 PM PST

Wow - good tip - its always good to learn something new...

/paul


On 2/11/06, Eike Rathke <com> wrote: 
he cr 
sor 
data 
the 
in 
for 
izer. 


---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] very disappointed to see "easter-egg" in a free-software

Posted: 07 Feb 2006 04:16 PM PST

Hi Rigel,
 
You're right and I apologise for my adding to the noise on this thread,
I guess I didn't feel it would stand out that much in the midst of
suggestions to replace booth babes with nerf ball fights ;-)

Sorry about that,

Cyrille

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] very disappointed to see "easter-egg" in a free-software

Posted: 07 Feb 2006 08:05 AM PST

--------------030001000000010106080407
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Ian Lynch wrote: 
Yeah, I know, after playing once it really sucks.
 

I see that happening :-\


James

--------------030001000000010106080407--

[discuss] very disappointed to see "easter-egg" in a free-software

Posted: 06 Feb 2006 10:11 PM PST

------=_Part_466_17277180.1139320306723
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

On 2/6/06, Cor Nouws <nl> wrote:
 

I've never had a problem trusting software with easter eggs. I've never
known of any large piece of software that was totally EE free, so I can't
answer your question based on experience. However, I would say that for me
personally, I would not base my level of trust in a piece of software on it=
s
absense or presence of EE.

--
- Chad Smith
http://www.gimpshop.net/
Because everyone loves free software!

------=_Part_466_17277180.1139320306723--

[discuss] very disappointed to see "easter-egg" in a

Posted: 06 Feb 2006 03:44 AM PST

On Mon, 2006-02-06 at 15:14 +0000, C Cichocki wrote: 

IIRC, these are legacy from StarOffice5.x. I suspect that the reason
they are still included is that no one has bothered to remove them.
--
PLEASE KEEP MESSAGES ON THE LIST.
OpenOffice.org Documentation Co-Lead
http://documentation.openoffice.org/

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] one last point

Posted: 02 Feb 2006 09:56 PM PST

Your right!!! I never knew about the package manager. I just did a quick
search and i could only find examples of packages to change the widgets
using the Native Widget Framework... do you know if there is a central
location for all plugins? kind of how FireFox has an extensions page that
is organized into different types of extensions.

Thanks
Rob

 


---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

[discuss] Derive para style from char style?

Posted: 02 Feb 2006 02:20 PM PST

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi Guiseppe,
 

I found something about CSS but not directly what I meant. We already
have that one paragraph style can be derived from another one, only
differences are stored (what is very comfortable, I use it often). My
wish is simply that paragraph styles can be derived from character
styles if you want it, instead of giving font and font effects
explicitely for paragraph styles (what should be possible anyway). This
could help to have ONE basic font for the whole document as far as this
is possible. If it turns out that this font does not look nice on some
printer or presentation - change just one place, and you have a
completely changed document.

I don't know whether paragraph and character styles are so similar
that this is possible, but it would be a nice feature (after bug-
fixing outline numbering and adding an INSTALL file to OO2 :-)

Greetings

Reinhard

r.wobst at gmx dot de

-----BEGIN PGP SIGNATURE-----

iEYEARECAAYFAkPs+LEACgkQ92KQnaKMSxaSjQCdFat/UeuoaJZ0S4x4YCIpYkwW
WYwAnRa6Vs2chYdU5uw1jN6TcVAE7AoS
=tsgY
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To unsubscribe, e-mail: org
For additional commands, e-mail: org

Excel Help Forum - Excel Programming / VBA / Macros: Help with Error displays

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Help with Error displays
Hello Everyone, I would like to get a small macro where if a cell is blank in a particular column corresponding row to that cell should be deleted or if it is well and good if i get the deleted data in a separate sheet Attachment 189349...

Excel Help Forum - Excel General: Lookup Value problem

Feed2Mail notification - new post on Excel Help Forum - Excel General
Lookup Value problem
I am trying to find out the percentage for male or female based on their age. The problem is I don't know the formula that will let me pick multiple lookup values. I can use lookup just for either male of female but I can't use a combined lookup so it can use multiple look up values. I have...

Excel Help Forum - Excel Programming / VBA / Macros: Auto Hide Columns

Feed2Mail notification - new post on Excel Help Forum - Excel Programming / VBA / Macros
Auto Hide Columns
Hello Everyone This is my first post and I need your help I've not written VB scripts before but can mostly understand them . I have created a form with a number of different drop down lists (which I've attached) What I need to do is if C6 changes to Nursery hide columns G, H , M and N,...

Excel Help Forum - Excel General: Problem when trying to Insert Row or Insert Copied cells

Feed2Mail notification - new post on Excel Help Forum - Excel General
Problem when trying to Insert Row or Insert Copied cells
Hello - I am new to the forum so hello everyone. I am experiencing a problem in a spreadsheet that I have used daily over the last 2 years but suddenly I have a problem inserting a row or inserting copied cells. I get the following messages: Attachment 189323...