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. >
It is a known (and annoying) bug : https://bugs.freedesktop.org/show_bug.cgi?id=38113 -- View this message in context: http://nabble.documentfoundation.org/Bug-saving-as-xls-format-loses-a-name-reference-tp3176718p3178288.html Sent from the Users mailing list archive at Nabble.com. -- 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
