[libreoffice-users] Re: Bug saving as .xls format - loses a name reference

2011-07-17 Thread Gérard Fargeot
steelej wrote: > > LibreOffice 3.4.1 > OOO340m1 (Build:103) > > I have a spreadsheet that I have been using for years. > > This contains column where the formula in each cell is similar to > *"=gall_to_litre*F4/B*4" > > *gall_to_litre* is defined as a global name and contains a number. >

Re: [libreoffice-users] Re: Max Row and Column Support

2011-07-17 Thread Andy Brown
Steve Edmonds wrote: > Hi. > > On 2011-07-18 09:26, Tom Davies wrote: >> Hi :) >> I think it's far ahead of Excel already isn't it? If you need a spreadsheet >> to >> be this large then it might be better as a relational database to reduce >> file-size and increase staility and also prevent ce

Re: [libreoffice-users] Re: Max Row and Column Support

2011-07-17 Thread Steve Edmonds
Hi. On 2011-07-18 09:26, Tom Davies wrote: > Hi :) > I think it's far ahead of Excel already isn't it? If you need a spreadsheet > to > be this large then it might be better as a relational database to reduce > file-size and increase staility and also prevent certain types of errors from > cr

Re: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project

2011-07-17 Thread Roland Hughes
Ask any company that got in bed with Bill Gates and came away with Corporate Aids? Remember Lattice? The maker of the C compiler Microsoft private labeled and had a non-compete with stating they would never develop their own C compiler? Remember Mosaic (sp?). The Web browser developed by a comp

[libreoffice-users] Re: Bug saving as .xls format - loses a name reference

2011-07-17 Thread NoOp
On 07/17/2011 05:50 AM, steelej wrote: > LibreOffice 3.4.1 > OOO340m1 (Build:103) > > I have a spreadsheet that I have been using for years. > > This contains column where the formula in each cell is similar to > *"=gall_to_litre*F4/B*4" > > *gall_to_litre* is defined as a global name and co

Re: [libreoffice-users] Conditional hide rows in Calc?

2011-07-17 Thread Wayne Stidolph
Thanks, Simon, Brian - I'm an infrequent spreadsheet-user and just didn't think about filters. These approaches work fine! -- Wayne On Sun, Jul 17, 2011 at 6:04 PM, Brian Barker wrote: > At 17:35 17/07/2011 -0700, Wayne Stidolph wrote: > >> I have a variable numbers of data elements for each da

Re: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project

2011-07-17 Thread John B
I do not think there would be a problem with OOo & LO working together in co-operation, its the getting into bed with IBM that could. As they say "if you fail to learn from history ." Ask Bill Gates, ask Lotus users after IBM took over - it does look good at first, but in the long run.

Re: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project

2011-07-17 Thread Roland Hughes
The first release was quite stable, though reduced in feature. Stable enough I could write a best selling book using it. You are all free to have your own definition of "best selling" as everybody else in the book industry does. http://www.infiniteexposure.net The current version of Symphony is

Re: [libreoffice-users] Conditional hide rows in Calc?

2011-07-17 Thread Brian Barker
At 17:35 17/07/2011 -0700, Wayne Stidolph wrote: I have a variable numbers of data elements for each day, and I'd like to hide all but the last of each day (or export only the last-of-day values); is there an easy way? Example data: row | date | reading number | value | ... 1 | 7/1/2011 | 1 |

Re: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project

2011-07-17 Thread Roland Hughes
Try KOffice.or as it is now called Calligra. It will be bundled with most major distros next release. http://en.wikipedia.org/wiki/Calligra_Suite On Sun, 2011-07-17 at 20:18 -0400, Paul W wrote: > Why don't all the OOo devs just come to TDF? I mean isn't this further > splitting up the commun

Re: [libreoffice-users] Conditional hide rows in Calc?

2011-07-17 Thread Simon Cropper (The foss Workflow Guides)
On 18/07/11 10:35, Wayne Stidolph wrote: I have a variable numbers of data elements for each day, and I'd like to hide all but the last of each day (or export only the last-of-day values); is there an easy way? Example data: row | date | reading number | value | ... 1 | 7/1/2011 | 1 | 3 2 | 7/2/

[libreoffice-users] Conditional hide rows in Calc?

2011-07-17 Thread Wayne Stidolph
I have a variable numbers of data elements for each day, and I'd like to hide all but the last of each day (or export only the last-of-day values); is there an easy way? Example data: row | date | reading number | value | ... 1 | 7/1/2011 | 1 | 3 2 | 7/2/2011 | 1 | 6 3 | 7/2/2011 | 2 | 7 4 | 7/2/2

Re: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project

2011-07-17 Thread Tom Davies
Hi :) Some of the OOo devs are paid to work were they are told to work. Some just haven't made the move yet. Some might be halfway through working on things and don't want to switch systems halfway through. Competition encourages people to be better than the other team. It's good to have som

Re: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project

2011-07-17 Thread Paul W
Why don't all the OOo devs just come to TDF? I mean isn't this further splitting up the community? What I want to see is a single powerful office suite to kill Microsoft. I want to see them buried. I want to see a free, open product that is perfect in it's seamlessness, transparency and ease of use

Re: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project

2011-07-17 Thread Tom Davies
Hi :) +1 OpenOffice and LiibreOffice can take different directions and still co-operate. Oracle didn't really seem to appreciate that but Apache do. As 2 projects it gives both a strong competitor to measure progress against. It allows OpenSource enthusiasts to join in with the TDF one and p

Re: [libreoffice-users] Formatting question

2011-07-17 Thread Simon Cropper (The foss Workflow Guides)
On 18/07/11 09:35, Night wrote: No, I don't change anything, I just hit enter 3x like I did with OpenOffice and assumed it would work like OpenOffice. So your using empty paragraphs, which should work. I just tried and have no problem. The way your doing it is one way but not the best. You

Re: [libreoffice-users] Formatting question

2011-07-17 Thread Andy Brown
Night wrote: > >>> No, I don't change anything, I just hit enter 3x like I did with OpenOffice >>> and assumed it would work like OpenOffice. >> >> So your using empty paragraphs, which should work. I just tried and >> have no problem. The way your doing it is one way but not the best. >> You s

Re: [libreoffice-users] Formatting question

2011-07-17 Thread Night
>> No, I don't change anything, I just hit enter 3x like I did with OpenOffice >> and assumed it would work like OpenOffice. > > So your using empty paragraphs, which should work. I just tried and > have no problem. The way your doing it is one way but not the best. > You should be using style

Re: [libreoffice-users] Formatting question

2011-07-17 Thread Andy Brown
Night wrote: > > [libreoffice-users] Formatting question > >> Night wrote: >>> >>> [libreoffice-users] Formatting question >>> Night wrote: > Hello! > > I was wondering if someone could help me with line spacing? Should be > easy and self explanatory, I'm sure, but I'm a com

Re: [libreoffice-users] Formatting question

2011-07-17 Thread Night
[libreoffice-users] Formatting question > Night wrote: >> >> [libreoffice-users] Formatting question >> >>> Night wrote: Hello! I was wondering if someone could help me with line spacing? Should be easy and self explanatory, I'm sure, but I'm a complete newbie; I do have i

Re: [libreoffice-users] Formatting question

2011-07-17 Thread Andy Brown
Night wrote: > > [libreoffice-users] Formatting question > >> Night wrote: >>> Hello! >>> >>> I was wondering if someone could help me with line spacing? Should be easy >>> and self explanatory, I'm sure, but I'm a complete newbie; I do have it set >>> to 1.5, but in some cases need to triple t

Re: [libreoffice-users] Formatting question

2011-07-17 Thread Night
[libreoffice-users] Formatting question > Night wrote: >> Hello! >> >> I was wondering if someone could help me with line spacing? Should be easy >> and self explanatory, I'm sure, but I'm a complete newbie; I do have it set >> to 1.5, but in some cases need to triple that. Problem is, when I

Re: [libreoffice-users] Formatting question

2011-07-17 Thread Andy Brown
Night wrote: > Hello! > > I was wondering if someone could help me with line spacing? Should be easy > and self explanatory, I'm sure, but I'm a complete newbie; I do have it set > to 1.5, but in some cases need to triple that. Problem is, when I save the > document, it doesn't save the 4.5 spa

[libreoffice-users] Formatting question

2011-07-17 Thread Night
Hello! I was wondering if someone could help me with line spacing? Should be easy and self explanatory, I'm sure, but I'm a complete newbie; I do have it set to 1.5, but in some cases need to triple that. Problem is, when I save the document, it doesn't save the 4.5 spacing. Any suggestions ple

Re: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project

2011-07-17 Thread John B
Hi As a disgruntled Lotus Smart Suite user, abandoned by IBM as are the Lotus Amipro users, I am well aware of the link between Symphony & OOo, as one reduced its support for LSS, so did the other one. In fact IBM have now turned its back permanently on LSS and not so surprisingly in Windows

[libreoffice-users] Bug saving as .xls format - loses a name reference

2011-07-17 Thread steelej
LibreOffice 3.4.1 OOO340m1 (Build:103) I have a spreadsheet that I have been using for years. This contains column where the formula in each cell is similar to *"=gall_to_litre*F4/B*4" *gall_to_litre* is defined as a global name and contains a number. When I enter this formula the spreadsh

Re: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project

2011-07-17 Thread Andy Brown
David B Teague sr wrote: > On 7/17/2011 5:02 PM, Andy Brown wrote: >> David B Teague sr wrote: >>> I agree, but I'd like to hear your reasons why "no"... >>> --David >>> >> Why would LibreOffice what to go backwards? The last time that OOo code >> was introduced into the LO code there were big pa

Re: [libreoffice-users] Re: Max Row and Column Support

2011-07-17 Thread Tom Davies
Hi :) I think it's far ahead of Excel already isn't it? If you need a spreadsheet to be this large then it might be better as a relational database to reduce file-size and increase staility and also prevent certain types of errors from creeping into it. I'm avoiding Base at the moment but ther

Re: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project

2011-07-17 Thread David B Teague sr
On 7/17/2011 5:02 PM, Andy Brown wrote: David B Teague sr wrote: On 7/17/2011 3:23 PM, Andy Brown wrote: Luuk wrote: http://www-03.ibm.com/software/lotus/symphony/buzz.nsf/web_DisPlayPlugin?open&unid=955E9C0EC712EC47852578CD0063A209&category=announcements Is it time for the LO-developers to

Re: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project

2011-07-17 Thread Andy Brown
David B Teague sr wrote: > On 7/17/2011 3:23 PM, Andy Brown wrote: >> Luuk wrote: >>> http://www-03.ibm.com/software/lotus/symphony/buzz.nsf/web_DisPlayPlugin?open&unid=955E9C0EC712EC47852578CD0063A209&category=announcements >>> >>> >>> Is it time for the LO-developers to get back with OpenOffice t

Re: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project

2011-07-17 Thread Tom Davies
Hi :) My emails are just my own opinion. I'm not even a proper member yet! Regards from Tom :) From: Andy Brown To: users@global.libreoffice.org Sent: Sun, 17 July, 2011 20:23:30 Subject: Re: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the A

[libreoffice-users] Re: IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project

2011-07-17 Thread NoOp
On 07/17/2011 11:04 AM, Luuk wrote: > http://www-03.ibm.com/software/lotus/symphony/buzz.nsf/web_DisPlayPlugin?open&unid=955E9C0EC712EC47852578CD0063A209&category=announcements > > Is it time for the LO-developers to get back with OpenOffice too ? > See the "News about the world outside LO :)" t

Re: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project

2011-07-17 Thread Tom Davies
Hi :) It is great news for both LibreOffice and OpenOffice. Consolidating some of the forks makes it easier to collaborate and give both products a significant boost. 'Obviously' the different licenses limit the amout of collaoration but there are still a lot of people that work on both produ

[libreoffice-users] Re: Max Row and Column Support

2011-07-17 Thread NoOp
On 07/16/2011 05:52 PM, Kaushal Shriyan wrote: > Hi, > > Whats the total number of Rows and Columns supported in LibreOffice > Calc application ? is there a FAQ which says ? Each spreadsheet can have many sheets, and each sheet can have many individual cells. In Calc 3.3, each sheet can have a m

Re: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project

2011-07-17 Thread David B Teague sr
On 7/17/2011 3:23 PM, Andy Brown wrote: Luuk wrote: http://www-03.ibm.com/software/lotus/symphony/buzz.nsf/web_DisPlayPlugin?open&unid=955E9C0EC712EC47852578CD0063A209&category=announcements Is it time for the LO-developers to get back with OpenOffice too ? In a word, no. I agree, but I'd

Re: [libreoffice-users] Re: Writer footnote numbering

2011-07-17 Thread Manfred J. Krause
Hi Mark, On Sun, Jul 17, 2011 at 21:15, Mark Stanton wrote: >> Is there any option to control the automatic numbering in Writer? > > D*mn!  As soon as I posted I found it! :-( > Tools -> Footnotes/Endnotes ... Counting per Document/Chapter/Page > :-( Please take note of Bug 38052 - Creating footn

Re: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project

2011-07-17 Thread Andy Brown
Luuk wrote: > http://www-03.ibm.com/software/lotus/symphony/buzz.nsf/web_DisPlayPlugin?open&unid=955E9C0EC712EC47852578CD0063A209&category=announcements > > Is it time for the LO-developers to get back with OpenOffice too ? > In a word, no. -- Unsubscribe instructions: E-mail to users+h...@g

[libreoffice-users] Re: Writer footnote numbering

2011-07-17 Thread Mark Stanton
> Is there any option to control the automatic numbering in Writer? D*mn! As soon as I posted I found it! :-( Tools -> Footnotes/Endnotes ... Counting per Document/Chapter/Page :-( Mark Stanton One small step (backwards :-( ) for mankind... -- Unsubscribe instructions: E-mail to users+h...@g

[libreoffice-users] Writer footnote numbering

2011-07-17 Thread Mark Stanton
Is there any option to control the automatic numbering in Writer? I want to have numbering reset per page and there appears to be no option, so numbering just increments throughout the document. I haven't been able to find anything helpful in the documentation. Best regards Mark Stanton One sma

Re: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project

2011-07-17 Thread Tom Davies
Hi :) no. regards from Tom :) From: Luuk To: users@global.libreoffice.org Sent: Sun, 17 July, 2011 19:04:40 Subject: [libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project http://www-03.ibm.com/software/lotus/symphony/buzz

[libreoffice-users] IBM Donates Lotus Symphony Source Code to the Apache OpenOffice Project

2011-07-17 Thread Luuk
http://www-03.ibm.com/software/lotus/symphony/buzz.nsf/web_DisPlayPlugin?open&unid=955E9C0EC712EC47852578CD0063A209&category=announcements Is it time for the LO-developers to get back with OpenOffice too ? -- Luuk -- Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org In cas

Re: [libreoffice-users] to insert text while viewing the slide with form controls

2011-07-17 Thread Edemilson Brandão
Thanks Tom, but what I want is to see this presentation (and fill in the form display mode, thanks again, Edemilson Brandão 2011/7/15 Tom Davies : > Hi :) > I think you have to be in "Design View" or something in order to put text > into a > slide!  I could be wrong.  Is three some useful docu

Re: [libreoffice-users] Max Row and Column Support

2011-07-17 Thread Kaushal Shriyan
On Sun, Jul 17, 2011 at 1:45 PM, Jean-Baptiste Faure wrote: > Le 17/07/2011 02:52, Kaushal Shriyan a écrit : >> Hi, >> >> Whats the total number of Rows and Columns supported in LibreOffice >> Calc application ? is there a FAQ which says ? > > > 1024 columns and 1024*1024 rows. Hi, Will there be

Re: [libreoffice-users] Re: NA DVD ISO - soon to be online

2011-07-17 Thread webmaster for Kracked Press Productions
On 07/16/2011 09:18 PM, Marc Paré wrote: Le 2011-07-16 18:36, Twayne a écrit : In news:4e20e648.1000...@krackedpress.com, webmaster for Kracked Press Productions typed: Just got an email from Drew, In a week or so, there should be a link for the initial ISO based upon the CMS server system o

[libreoffice-users] Re: Displaying Negative Numbers as red in Calc

2011-07-17 Thread Tinkerer
Tom How do you do it? > I try to make it a triple negative by using red, brackets and a minus > sign. Tink. -- View this message in context: http://nabble.documentfoundation.org/Displaying-Negative-Numbers-as-red-in-Calc-tp3172596p3176846.html Sent from the Users mailing list archive at Nabble.

[libreoffice-users] Re: Displaying Negative Numbers as red in Calc

2011-07-17 Thread John B
Hi On my XP SP3, LO 3.4. build 1OOO340m1 (Build:103) - the same as yours I saved as .ods, .xls, .xls (95) .xml and .xmlx, and they all came back perfect Must be a Windows 7, and an iMac bug - worth a report. regards John B -

Re: [libreoffice-users] Re: Displaying Negative Numbers as red in Calc

2011-07-17 Thread Tom Davies
Hi :) I try to make it a triple negative by using red, brackets and a minus sign just to equally annoy everyone Regards from Tom :) From: Tinkerer To: users@global.libreoffice.org Sent: Sun, 17 July, 2011 12:56:35 Subject: [libreoffice-users] Re: Displaying Ne

Re: [libreoffice-users] Displaying Negative Numbers as red in Calc

2011-07-17 Thread Johnny Rosenberg
2011/7/15 bikerbrent : > I don't seem to be able to display negative numbers red using a comma > thousands separator and 2 decimal places . If I go to cell formatting, I > have been able to get the negative number red with 2 decimal places, but no > separator. However as soon as I save the document

[libreoffice-users] Re: Displaying Negative Numbers as red in Calc

2011-07-17 Thread Tinkerer
I have just realised. When showing negative numbers in Red, you should not prefix the number with the minus sign. This makes it a double negative, therefore making the number Red should be minus the minus sign. BTW. Is that a pun? Tink. -- View this message in context: http://nabble.documentfou

[libreoffice-users] LO Base - Query Question

2011-07-17 Thread Ian Whitfield
Hi All When making a Query in LO Base how do you select the contents of a Tick-Box? ie I have a Tick-Box to indicate a particular class of people in my DB - so how do I make the Query select only Tick-Boxes that have a tick in them? Thanks Ian Whitfield// -- Unsubscribe instructions: E-ma

Re: [libreoffice-users] bug report

2011-07-17 Thread Tom Davies
Hi :) The wording is to encourage people to use it after the disaster of the 3.4.0 tactical release. The 3.4.1 is stable enough for almost everyone but doesn't have the full years support that the 3.3.3 has. These issues 'should' be added to the web-page to make it clearer i guess. Regards

Re: [libreoffice-users] Re: automatic updates?

2011-07-17 Thread Tom Davies
Hi :) I think the update feature was in the help menu in OpenOffice. OOo developed very slowly tho. Regards from Tom :) From: Paul W To: users@global.libreoffice.org Sent: Sun, 17 July, 2011 3:49:42 Subject: Re: [libreoffice-users] Re: automatic updates? T

Re: [libreoffice-users] bug report

2011-07-17 Thread Joren
Hi, 3.4.1 is (quote from libreoffice.org:) "/Safely for production need by most users**- LibreOffice 3.4.2, available at the end of July, will target enterprise deployments./" So, for home-usage (not bussiness), it's safe and stable enough to use. Kind regards, Joren Op 17/07/11 11:42, Tom

Re: [libreoffice-users] bug report

2011-07-17 Thread Tom Davies
Hi :) The 3.3.3 is the stable one. The 3.4.1 is for "early adopters" (=development or testing or cooking branch) so it would need to be upgraded fairly soon. It does have the latest new features but the 3.3.3 has support for a full year. Regards from Tom :)

Re: [libreoffice-users] bug report

2011-07-17 Thread Hladůvka Jiří
No crash on WinXP/Home SP2 + LibreOffice 3.3.3 OOO330m19 (Build:301) tag libreoffice-3.3.3.1 when saved as MS Word 95 Regards, Jiri Dne 17.7.2011 10:30, Vincent Riolo napsal(a): Hello! I'd like to report a bug in Libre Office Writer. My version of Libre Office is: LibreOffice 3.3.0 OOO330m19

Re: [libreoffice-users] bug report

2011-07-17 Thread Jean-Baptiste Faure
Hi Vincent, Please update your LibreOffice installation and try again : current stable versions are 3.3.3 and 3.4.1. Best regards JBF Le 17/07/2011 10:30, Vincent Riolo a écrit : > Hello! I'd like to report a bug in Libre Office Writer. > > My version of Libre Office is: > LibreOffice 3.3.0 > O

Re: [libreoffice-users] automatic updates?

2011-07-17 Thread Hladůvka Jiří
Hi, you have written exactly my thought :) I agree without reservation. Regards, Jiri Dne 17.7.2011 0:50, webmaster for Kracked Press Productions napsal(a): Would you really want someone else to decide what is best for your system? How about the question - if the next update has issues and you

[libreoffice-users] bug report

2011-07-17 Thread Vincent Riolo
Hello! I'd like to report a bug in Libre Office Writer. My version of Libre Office is: LibreOffice 3.3.0 OOO330m19 (Build:6) tag libreoffice-3.3.0.4 Open a file x.odt, save it as x.doc, edit it and then attempt to save the (updated) x.doc as x.odt. LibreOffice crashes. This does not happen if y

Re: [libreoffice-users] Max Row and Column Support

2011-07-17 Thread Jean-Baptiste Faure
Le 17/07/2011 02:52, Kaushal Shriyan a écrit : > Hi, > > Whats the total number of Rows and Columns supported in LibreOffice > Calc application ? is there a FAQ which says ? 1024 columns and 1024*1024 rows. JBF -- Seuls des formats ouverts peuvent assurer la pérennité de vos documents. -- U