Hi, yesterday I decided to modify a summary table by changing the values from those i define on names management area. In the process i found that the values i entered like for example:(Saving in excel 97, 2003,... format, i did not try using calc format) Name: Total_Desembolsos_Abril Range of formula expression:$Abril.C29 Continuously change to a different value I enter $Abril.C29 it puts $Abril.C28 Other times It just change $Abril.C29 to $Abril.D29 I need to save every definition one by one. I mean save one then close names management windows to later open it again to modify or correct the next definition. Last night I correct everything now when i open the calc document everything is mess up. This really has to be corrected. This are the correct values displayed on the pdf document i save last night: Ingresos $10,217.80 $11,597.45 $6,660.58 $7,345.18 $8,447.98 $10,348.58 $6,943.79 $9,702.50 $6,556.60 $7,427.86 Desembolsos $7,473.81 $9,737.64 $6,868.64 $7,160.17 $7,308.31 $6,264.97 $12,677.94 $5,261.05 $3,147.91 $6,303.55 This are the wrong values displayed on libreoffice .xls calc document when i opened this morning: Ingresos $10,217.80 $11,597.45 $0.00 $0.00 $8,447.98 $10,348.58 $0.00 $0.00 $0.00 $0.00 Desembolsos $7,473.81 $9,737.64 $6,868.64 $7,160.17 $7,308.31 $6,264.97 $0.00 $0.00 $3,147.91 $0.00 Thanks for your attention to this matters.
Do you have a version of the file before it messed up? You should attach it here and also the messed up file. Set to NEEDINFO. Change back to UNCONFIRMED after you have provided the file(s).
Hi, today, September 23, 2015 I decide to make another test, this time i used last version of OpenOffice to open the same file. The document open without trouble and the contents were as expected, all the calculations were correct. So i decide to open the same file with LibreOffice just to find out that it was messed up. So the problem is not the document itself but somehow on LibreOffice engine. The file contains sensitive (confidential) data that's why I did not included it as an attachment.
Created attachment 118973 [details] Screenshot of a messup file openned by LibreOffice
Created attachment 118974 [details] Screenshot of file openned by OpenOffice
Ok, but we can't verify your report if you don't attach it. You can use this method to anonymize it: https://wiki.documentfoundation.org/QA/Bugzilla/Sanitizing_Files_Before_Submission#Sanitize_file_text