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 users+help@global.libreoffice.org In case of problems unsubscribing, write to postmaster@documentfoundation.org 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