Hi :) The bug is being worked on. It was only identified recently and has already been marked as being as serious as it can get. Obviously we want miracles but work takes time. Until the bug is resolved i recommend avoid using the proprietary format that doesn't work and stick to the format that does. Otherwise use Excel for those other workbooks. It's also wise to back-up data regularly whichever programs you use. I'm glad to hear you were able to recover the sheet that had gone badly wrong.
Regards from Tom :) ________________________________ From: steelej <[email protected]> To: [email protected] Sent: Tue, 19 July, 2011 16:07:07 Subject: [libreoffice-users] Re: Bug saving as .xls format - loses a name reference 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 [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 -- 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
