Hi :) Can you fix the spreadsheet using search&replace to find "#NAME?" and replace with "gall_to_litre"? Hopefully that should fix it for the moment? The bug-report is already tagged as "Major" and "medium" importance. I'm not sure it can be pushed any higher than that? I really don't know about how the devs run their side of things. It is being worked on apparently but only got reported last month and might not be trivial to fix given that it involves a proprietary format. Good luck and regards from Tom :) ________________________________ From: steelej <jcs.libreoffice@soroban.co.uk> To: users@global.libreoffice.org Sent: Mon, 18 July, 2011 20:29:21 Subject: [libreoffice-users] Re: Bug saving as .xls format - loses a name reference It is not an annoying bug, it *seriously corrupted my spreadsheet *as the data while appearing OK was lost during the save and the problem only became apparent when the spreadsheet was reopened. I was fooled by the web page into thinking that the release was stable and fit for use. In my case it ONLY corrupted about 200 cells which were fairly simple to correct. In other spreadsheets I have several thousand such references using perhaps a dozen named references which would be virtually impossible to resurrect. If this is not fixed very soon then all of the good work is in danger of being destroyed as spreadsheets are damaged -- View this message in context: http://nabble.documentfoundation.org/Bug-saving-as-xls-format-loses-a-name-reference-tp3176718p3180307.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