[sc-users] queryEmptyCells()

Dear Community of OO Spreadsheet: I could not figure out how to correctly call the queryEmptyCells() API function. Does queryEmptyCells() implicitly depend on the state of the current cursor in a spreadsheet? I could not find the answer in the OO Developers Guide, version 2.0. I appreciate

RE: [users] Compatibility with Windows XP operating system

Your files will work just fine on either XP or Vista. OpenOffice works fine on Vista. -Original Message- From: Lynn and Dave [mailto:[EMAIL PROTECTED] Sent: Monday, June 04, 2007 5:16 AM To: users@openoffice.org Subject: [users] Compatibility with Windows XP operating system I am

Re: [users] Compatibility with Windows XP operating system

Lynn and Dave wrote: Will I be able to convert my present files from my old operating system to the new one? Just make sure that you do the same customizations to OOo when you install it on your new operating system. I had no issues switching between WinXP and Win2K, and then Linux. xan

Re: [users] [CALC] - centering text across multiple columns

JosephK wrote: Any reason we can't just merge cells? It just seems more elegant to me not to have to merge the cells. Merged cells sometimes create problems when you have to insert or delete columns later - you first have to unmerge and then merge agin when you are done deleting.

Re: [users] Decimal seperator

On Friday June 01 2007 3:21 am, Christian Foerg wrote: Hi guys, I've got a very annoying configuration problem. My default language is German (Germany) so I'd like to have German default settings. Except one: The decimal seperator. Is it possible to change the default decimal seperator

Re: [users] Installation Error

Monique Hooey escribió: I have XP and I get error 1935 message and the installation aborts. How do I resolve this? This error is usually caused by an antivirus program conflicting with the installation. The best way to avoid it: 1) Disconnect your computer from the internet 2) Disable your

Re: [users] Re: QuatroPro Worksheets

On Sunday June 03 2007 10:06 pm, NoOp wrote: On 06/03/2007 03:35 PM, Al Brown wrote: I am using Open Office 2.1 and would like to load some old QuatroPro .WB1 spreadsheets. How do I do it? Didn't older versions of Open Office handle .WB1 sheets? Not that I am aware of. OOo 2.2 can open

[users] increasing the number of decimal places in cells in spreadsheet

Hi, Im using a Mac PC5 OSX 10.4 and 00.2 . I'm trying to make a fraction to decimal conversion table and I need to go to four decimal places at the present time the spreadsheet limits to 2 decimal places. A) How does one change from 2 decimal places to 4 decimal places. B) Is there a

Re: [users] increasing the number of decimal places in cells in spreadsheet

At 08:09 04/06/2007 -0400, Vincent A Juliano wrote: Hi, Im using a Mac PC5 OSX 10.4 and 00.2 . I'm trying to make a fraction to decimal conversion table and I need to go to four decimal places at the present time the spreadsheet limits to 2 decimal places. A) How does one change from 2

Re: [users] increasing the number of decimal places in cells in spreadsheet

Mucho thank you's At 08:09 04/06/2007 -0400, Vincent A Juliano wrote: Hi, Im using a Mac PC5 OSX 10.4 and 00.2 . I'm trying to make a fraction to decimal conversion table and I need to go to four decimal places at the present time the spreadsheet limits to 2 decimal places. A) How

Re: [users] [moderated]

Richard Detwiler [EMAIL PROTECTED] wrote: MS Word and Excel cannot open files saved in OpenOffice format. However, you can choose, from within OpenOffice. to save documents in MS format -- for example, you can save a text document in MS Word format, and an Excel document in MS Excel format.

[users] Creating a decimal/ fraction conversion table

I'm having no luck using a spread sheet. In the tutorials where is there information to set up a table that will show the fraction and the corresponding decimal? I'd like to use six small columns for clarity. Thank you Vince

[users] bilingual OOo

Is there a switch that can be set on start up to specify which locale to use? I'd like to set up a pair of icons, one starting up one language / locale the other starting another language / locale. How can that be done (on Kubuntu or OS X) ? -Lars Lars Noodén ([EMAIL PROTECTED])

[users] [Fwd: Bug?]

I finally cracked it. This is dumber than rocks! TOOLS - OPTIONS - OpenOffice.org ACCESSIBILITY TAB - uncheck Use automatic font color for screen display. I have no idea how this setting got checked in the first place. Joe Conner, Poulsbo, WA USA Original Message Subject:

Re: [users] Creating a decimal/ fraction conversion table

Hi Vince, This should get you started. Below are the first fifteen rows of columns A to E with formulae displayed. Enter the first two rows below, then use fill down to get as many fractional numbers as you would like in your chart. The result is below the formula list. Select all, copy and

Re: [users] Creating a decimal/ fraction conversion table

Anthony, et al. I just reread what I sent out and it in no way indicated what I was looking for. Please color me dumb. I have a table of conversion from fractions to decimals. I'm looking for a way to make a copy of this table and keep it in my computer as well as make copies to keep it in

[users] [moderated] YOU MUST GIVE A SUMMARY HERE

I am fairly new to the computer world and need some help. I just downloaded OpenOffice and installed it and everything went well. But there was NOT a shortcut for my desktop to use when I want to run OpenOffice. Can you help this newbie please?? UNITED We can't lose DIVIDED We can't

Re: [users] Creating a decimal/ fraction conversion table

Hi Vince, In that case, you want to use cell formatting to get what you want. Select a column by clicking on the letter heading at the top of the column, right-click a cell in that column and select 'format cells'. Choose 'fractions' from the list of pre-defined formats. Choose the second

Re: [users] Creating a decimal/ fraction conversion table

If the fractions are all found in Column A, you can format this column for fractions. Right click the A at the top of the column to highlight the entire column and open a context menu. Select Format Cells. You will find 'Fraction' near the bottom of the Category list. Click it, and then

Re: [users] [moderated] YOU MUST GIVE A SUMMARY HERE

On Monday June 04 2007 11:29 am, R.S. Parker wrote: I am fairly new to the computer world and need some help. I just downloaded OpenOffice and installed it and everything went well. But there was NOT a shortcut for my desktop to use when I want to run OpenOffice. Can you help this newbie

[users] Re: [Fwd: Bug?]

On 06/04/2007 08:22 AM, Joe Conner wrote: I finally cracked it. This is dumber than rocks! TOOLS - OPTIONS - OpenOffice.org ACCESSIBILITY TAB - uncheck Use automatic font color for screen display. I have no idea how this setting got checked in the first place. :-) see the recent

Re: [users] Creating a decimal/ fraction conversion table

Thanks Tony, Appreciate your patience. Vince Hi Vince, In that case, you want to use cell formatting to get what you want. Select a column by clicking on the letter heading at the top of the column, right-click a cell in that column and select 'format cells'. Choose 'fractions' from the

Re: [users] BasicProviderImpl::getScript: no script!

On 1 Jun 2007 at 18:25, TerryJ wrote: ... The title is the error message I'm receiving, in a message box with some not-useful clutter. ... However, when starting with the -pt flag (so running without the GUI), I get an error message popping up with that title gem. The print-to-PDF

Re: [users] bilingual OOo

I've a launcher that is a script in fact where the command line are : #!/bin/bash LANG=en_US.UTF-8 soffice -writer (my OOo is in French with the standard icon) Hagar Le 04.06.2007 17:21, Lars D. Noodén a écrit : Is there a switch that can be set on start up to specify which locale to use?

Re: [users] OO causes xorg to hang when menu is clicked

Andy, Thanks for your response. Disabling GUI effects (KDE) did not help. I'm probably going to switch this system from CentOS to Fedora 7. Thanks. Jeff On Fri, 2007-06-01 at 13:06 -0400, Andy Pitonyak wrote: I am getting a system hang with OO on a CentOS 5 system. Very often when I

[users] Calc: How do I add up cumulative time (hour/min) values?

I'm trying to create a timesheet in Calc where I enter my start and end times for each day of work (in 24-hour format to avoid tying myself in knots with the 12-hour time format), and then have Calc show the amount of time worked for each day (ie, calculate the difference between the two times,

Re: [users] Calc: How do I add up cumulative time (hour/min) values?

On Monday June 04 2007 1:49 pm, David M wrote: I'm trying to create a timesheet in Calc where I enter my start and end times for each day of work (in 24-hour format to avoid tying myself in knots with the 12-hour time format), and then have Calc show the amount of time worked for each day

[users] Re: Calc: How do I add up cumulative time (hour/min) values?

On 06/04/2007 11:49 AM, David M wrote: I'm trying to create a timesheet in Calc where I enter my start and end times for each day of work (in 24-hour format to avoid tying myself in knots with the 12-hour time format), and then have Calc show the amount of time worked for each day (ie,

Re: [users] Re: EPS - Export with Draw

Joe Smith wrote: Why does OOo not have a tool like Windows' regedit, or Mozilla's about:config, or GConf's gconf-editor, where the OOo registry could be searched and edited directly? You can a lot of good XML editors to do so. This is even more comfortable as about:config, in most cases it

[users] OpenOffice.org automatic printing

It occurs to me that OpenOffice.org would make a dandy filter to do some file conversions. I'm thinking that I can load html and doc files and so on into Writer, then print them to a file and get Postscript or PDF all in one smooth motion. I would like to script this operation and point the

[users] Suppressing part of a paragraph border

Am I right in thinking that there is no way to suppress the bottom edge of a paragraph border that is broken over two pages, and the top edge of the border on the following page? Séamas Ó Brógáin - To

[users] [moderated]

Hi, I'm hoping this is the right way to get in touch. We are new to openoffice having only downloaded it on Friday. Very impressive so far. My only concern is that I cannot get it to do a spell-check. Is there a trick to this that isn't in the 'help' section? If anyone can put me straight I

[users] When comes Open Office for Mac OSX without X11

Hi there, Can somebody say me when Open Office will run on a Mac without X11 ? I heard that thay are workin on it. Thanks and have a nice day -- Mit freundlichen Grüßen, i.A. André Söhnle *** in-put GbR - Das Linux-Systemhaus Andre Soehnle

[users] MAC Compatibility

I am switching to a MAC computer. I was wondering if your programs are compatible to run on the MAC operating system. Thank you for your response. ___ Tim Jackie Harden 1414 Huron Rd., RR #2 Petersburg ON N0B 2H0 519-696-3085

[users] Impress

How do I package several presentations onto one CD? - Got a little couch potato? Check out fun summer activities for kids.

[users] [moderated]

I have a question. any work that I do in openoffice can i transfered to another computer that has Microsoft Office 2003, and vice-versa. My email address is [EMAIL PROTECTED] Regards, Carlos de Rojas - To unsubscribe, e-mail:

Re: [users] Will not open

Try the START menu. Make shortcuts there and move them to the desktop if you wish. Nancy F, SoCal Craig Elaine Mayfield wrote: I have been using Open Office 2.0 so decided to upgrade to 2.2. There is not a new shortcut, nor can I locate a place to create a new one. So I can't open Open

Re: [users] retrieving microsoft 2007 home and student office files

On Monday 04 June 2007, [EMAIL PROTECTED] wrote: hy I bought your open office program 2 through the internet for $11.00. I am unable to retrieve the 2007 microstoft home student files I had previously saved. The microsoft Student home 2007 program ran out of trial time and froze up, I was

[users] Re: Printing in Writer

On 06/04/2007 03:01 AM, Richard Douglas wrote: Writer prints my documents at one quarter size. How can I achieve full-size prints? I've selected all the options in the menus, both in Writer and my printer software, Epson Stylus Photo700. Richard Douglas Ah, that very thing drove me nearly

Re: [users] Question

On Saturday 02 June 2007, + Robert Bellorin wrote: [EMAIL PROTECTED]/ Technical details of permanent failure: PERM_FAILURE: Parse Error: Illegal To: address (invalid domain name): [EMAIL PROTECTED]/ This list is generally an English only mailing list. If you would like to communicate in

[users] retrieving microsoft 2007 home and student office files

hy I bought your open office program 2 through the internet for $11.00. I am unable to retrieve the 2007 microstoft home student files I had previously saved. The microsoft Student home 2007 program ran out of trial time and froze up, I was not about to pay $145.00 for the program as I

[users] 2.0

can you please help me install - followed instructions - icon - but, it appears nothing has been installed - thank you. - Ready for the edge of your seat? Check out tonight's top picks on Yahoo! TV.

[users] Printing in Writer

Writer prints my documents at one quarter size. How can I achieve full-size prints? I've selected all the options in the menus, both in Writer and my printer software, Epson Stylus Photo700. Richard Douglas

[users] Will not open

I have been using Open Office 2.0 so decided to upgrade to 2.2.There is not a new shortcut, nor can I locate a place to create a new one. So I can't open Open Office 2.2. What do I do now? (I'm 73, but know a little bit about computers and programs. . . . ) Elaine

[users] Open office database converted to a exe?

Hi there, Can the database program in Open Office be converted to an exe program so it can be distributed? Thanks Ewan Arnolda IT Administrator EXEDY Australia Pty Ltd 21 Fiveways Boulevard Keysborough 3173 P: 03 8769 2410 F: 03 9701 5955 W:

[users] crash openoffice writer in larger document

Dear sir/madam, I am using OpenOffice.org 2.2 and I have the following problem: While combining a number of documents writer suddenly crashes when I try to insert another figure in the main document. This document contains up to this point 73 figures, is 104 pages long, and takes up 2.3 Mb.

Re: [users] converting wp files with columns

Thank you for your response, Format- Page doesen't correct the problem. It runs all the text from the left and from the right together. I want to reconstruct the text into two independent columns like it was originally before being converted into open office. I've attached a sample for your

[users] Scheduled Command Line Print Job

I am trying to schedule a spreadsheet to print at a specified time each day, I have created a scheduled task on a windows 2003 server that I have installed OpenOffice.org version 2.2 on. This is the server that the file and printer is defined on, the printer is setup using tcp/ip printing, and

[users] [moderated]

I have downloaded the software of OpenOffice.org. I believe that doing this, I should be able to view power point presentations, but am still not able to do so, a message comes on asking for the product #, etc. which I do not have..Any suggestions would be helpful. [EMAIL PROTECTED]

[users] IF statement in Open Office

I am using Open Office 2.2 and have the following problem: I have tried to use an 'IF' statement in an Open Office spreadsheet. I did a cut-and-paste on the Help File IF(A10;10;'too small) example and even that does not work. I put the statement in B2 and entered 12 in A1 with no results.

[users] Re: Open office database converted to a exe?

On 06/03/2007 08:47 PM, Ewan Arnolda wrote: Hi there, Can the database program in Open Office be converted to an exe program so it can be distributed? Thanks Ewan Arnolda IT Administrator Unsure exactly what you want to do; do you want to distribute only the Base portion of

[users] Re: [moderated]

Myles Aikenhead wrote: Hi, I'm hoping this is the right way to get in touch. We are new to openoffice having only downloaded it on Friday. Very impressive so far. My only concern is that I cannot get it to do a spell-check. Is there a trick to this that isn't in the 'help' section? If anyone

Re: [users] [moderated]

Original Message From: Myles Aikenhead [EMAIL PROTECTED] Date: Mon 04 Jun 2007 15:48:32 EST Hi, I'm hoping this is the right way to get in touch. We are new to openoffice having only downloaded it on Friday. Very impressive so far. My only concern is that I cannot get it

[users] Re: When comes Open Office for Mac OSX without X11

Andre Soehnle wrote: Hi there, Can somebody say me when Open Office will run on a Mac without X11 ? I heard that thay are workin on it. Thanks and have a nice day Hi Andre You may find some information on : http://porting.openoffice.org/ Russell Please reply _only_ to

Re: [users] 2.0

Original Message From: Laura [EMAIL PROTECTED] Date: Mon 04 Jun 2007 23:37:55 EST can you please help me install - followed instructions - icon - but, it appears nothing has been installed - thank you. Your message is a little short on detail, so I will guess that you are

Re: [users] About OpenOffice in Romania

[EMAIL PROTECTED] wrote: Hi, my name is Marius Felea and I'm the president of a small web design company in Romania. I send you this letter to ask you some questions about your project. Me and my partner have decided to promote some Open Source projects in our country, and Open Office is one

[users] Question - Header Footer - Calc

Dear OOo Users, i have a question about footer in calc. can i change date format for header footer and calc? for default the date format is dd/mm/, i want to change to long date format (05 June 2006) thanks for attention The information transmitted is intended only for the person or

Re: [users] [moderated]

Original Message From: GLASS MIRROR ENTERPRISES [EMAIL PROTECTED] Date: Tue 05 Jun 2007 01:25:29 EST I have a question. any work that I do in openoffice can i transfered to another computer that has Microsoft Office 2003, and vice-versa. My email address is [EMAIL

Re: [users] Will not open

On Monday June 04 2007 6:34 pm, Nancy F wrote: Try the START menu. Make shortcuts there and move them to the desktop if you wish. Nancy F, SoCal Craig Elaine Mayfield wrote: I have been using Open Office 2.0 so decided to upgrade to 2.2. There is not a new shortcut, nor can I locate a

Re: [users] Will not open

Hi Nancy...I just went thru the same thing. But here is a solution that works for me: Dick Parker In Windows, you also have the Quickstarter icon in the System tray near the computer clock. (It is three birds flying on a blue and gray background.) When you right click the Quickstarted

Re: [users] Compatibility with Windows XP operating system

Lynn and Dave wrote: I am presently using open office with windows 98 operating system. I am wanting to get a new computer with Windows XP operating system. Will I be able to convert my present files from my old operating system to the new one? What about if I use Vista? Thanks

Re: [users] IF statement in Open Office

Al, Change IF(A10;10;'too small) to =IF(A10;10;too small) and it should work for you (that is, make sure to use and not ' to open and close the string and of course, don't forget the = kennM On 6/4/07, Al Brown [EMAIL PROTECTED] wrote: I am using Open Office 2.2 and have

Re: [users] IF statement in Open Office

Original Message From: Al Brown [EMAIL PROTECTED] Date: Tue 05 Jun 2007 08:54:32 EST I am using Open Office 2.2 and have the following problem: I have tried to use an 'IF' statement in an Open Office spreadsheet. I did a cut-and-paste on the Help File IF(A10;10;'too small)

Re: [users] [moderated]

On Monday June 04 2007 5:12 pm, MJL wrote: I have downloaded the software of OpenOffice.org. I believe that doing this, I should be able to view power point presentations, but am still not able to do so, a message comes on asking for the product #, etc. which I do not have..Any

Re: [users] IF statement in Open Office

On Monday June 04 2007 8:08 pm, Kenn Murrah wrote: Al, Change IF(A10;10;'too small) to =IF(A10;10;too small) and it should work for you (that is, make sure to use and not ' to open and close the string and of course, don't forget the = kennM On 6/4/07, Al Brown

Re: [users] retrieving microsoft 2007 home and student office files

[EMAIL PROTECTED] wrote: hy I bought your open office program 2 through the internet for $11.00. I am unable to retrieve the 2007 microstoft home student files I had previously saved. The microsoft Student home 2007 program ran out of trial time and froze up, I was not about to pay

Re: [users] Re: Printing in Writer

On Monday June 04 2007 6:36 pm, NoOp wrote: On 06/04/2007 03:01 AM, Richard Douglas wrote: Writer prints my documents at one quarter size. How can I achieve full-size prints? I've selected all the options in the menus, both in Writer and my printer software, Epson Stylus Photo700.

Re: [users] MAC Compatibility

On Monday June 04 2007 9:17 am, Jackie Harden wrote: I am switching to a MAC computer. I was wondering if your programs are compatible to run on the MAC operating system. Thank you for your response. Yes, there is an OpenOffice.org version for the MAC. Please read the installation

Re: [users] Impress

On Monday June 04 2007 9:45 am, Ryan Hood wrote: How do I package several presentations onto one CD? What is it that you want to do? It should not be that much of a problem to burn the presentation files on the CD. All your are doing is creating a data CD. Dan

Re: [users] retrieving microsoft 2007 home and student office files

On Monday June 04 2007 6:35 pm, [EMAIL PROTECTED] wrote: On Monday 04 June 2007, [EMAIL PROTECTED] wrote: hy I bought your open office program 2 through the internet for $11.00. I am unable to retrieve the 2007 microstoft home student files I had previously saved. The microsoft

[users] PDF converters

I'm wondering if anybody knows of PDF converters that work well with OpenOffice. While I am not holding out hopes that it will convert to OO format or that it will even integrate directly into OO, are there any such beasts out there (free or commercial) and are the .doc files that they put out

Re: [users] PDF converters

On Mon, 2007-06-04 at 20:58 -0600, Pueblo Native wrote: I'm wondering if anybody knows of PDF converters that work well with OpenOffice. While I am not holding out hopes that it will convert to OO format or that it will even integrate directly into OO, are there any such beasts out there

[users] Re: PDF converters

On 06/04/2007 07:58 PM, Pueblo Native wrote: I'm wondering if anybody knows of PDF converters that work well with OpenOffice. While I am not holding out hopes that it will convert to OO format or that it will even integrate directly into OO, are there any such beasts out there (free or

Re: [users] MAC Compatibility

Yes, it is. I use a Mac with OS X and the Mac version of OOo. Lloyd On Jun 4, 2007, at 10:17 AM, Jackie Harden wrote: I am switching to a MAC computer. I was wondering if your programs are compatible to run on the MAC operating system. Thank you for your response.

[users] Access to an opened document

Hi everyone, New to this mail list and to OOo community. Here is my problem: I want to open a particular document from the active document from which I launch the macro. I use this code: '*** Sub OpenFile

Re: [users] Re: PDF converters

NoOp wrote: On 06/04/2007 07:58 PM, Pueblo Native wrote: I'm wondering if anybody knows of PDF converters that work well with OpenOffice. While I am not holding out hopes that it will convert to OO format or that it will even integrate directly into OO, are there any such beasts out

[users] Re: retrieving microsoft 2007 home and student office files

James Knott wrote: [EMAIL PROTECTED] wrote: hy I bought your open office program 2 through the internet for $11.00. I am unable to retrieve the 2007 microstoft home student files I had previously saved. The microsoft Student home 2007 program ran out of trial time and froze up, I was not

Re: [users] Re: PDF converters

Hi, have a look at Re: [de-users] PDF zurückumwandeln in Writer-Dokument From: Jens Nürnberger Date: 04 Apr 2007 - http://www.mail-archive.com/[EMAIL PROTECTED]/msg35565.html [A little of text in German language, but it's easy to follow some helpful links ...] Manfred Pueblo Native wrote: