Re: [libreoffice-users] Re: Bug saving as .xls format - loses a name reference

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 <jcs.libreoffice@soroban.co.uk>
To: users@global.libreoffice.org
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 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
-- 
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