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 contains a number. > > When I enter this formula the spreadsheet calculates correctly. When I save > the spreadsheet as Excel 97 ... and then re-open it it loses the name > reference (shows an error) and the formula then generates an error. > > When I save as ods format the formula remains intact. > > I have just converted from Open Office 3.2 to LibreOffice 3.4. It worked > correctly in OO 3.2 and all previous versions back to 2.x. I have one > machine where I still have Excel 2003 and would like to continue using .xls > format.
If you don't mind sending me a sample directly, I'll be happy to test in LO 3.3.3/3.4.1 & OOo 3.2/3.4. -- Unsubscribe instructions: E-mail to [email protected] In case of problems unsubscribing, write to [email protected] Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
