I could fix THIS spreadheet using a replace function as there is only one such name used. I have other spreadheets however where there are typically about 12 names defined in this way. The names are accesed in formulae across many tabs and over several thousand cells. If the reference is =<name> then it is replaced by simply = just to add to the "fun" How could anybody repair such a spreadsheet? Most of my spreadsheets are work related = Enterprise! Yhe sample I have here is for home use and is much simpler. I would expect that the effort to recover a large spreadsheet would not be worth while (probablyseveral days) and I would have needed to revert to a backup as the spreadheet would be to all intents and purposes totally destroyed just by saving as Excel format. *If that is not a serious bug I don't know what is.* I have tested that version 3.3 does nto suffer from this problem so I will revert to that version with my confidence in LO somewhat shaken. I am due to give a talk to our local computer club in less than a month about Ope/libre Office and am now in doubt as to what to say. -- View this message in context: http://nabble.documentfoundation.org/Bug-saving-as-xls-format-loses-a-name-reference-tp3176718p3182794.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