Bug 115423

Summary: FILESAVE the spreadsheet will not save at all
Product: LibreOffice Reporter: tom <tom>
Component: CalcAssignee: Bartosz <gang65>
Status: RESOLVED WORKSFORME    
Severity: normal CC: aron.budea, gang65, tom, xiscofauli
Priority: medium    
Version: 6.0.0.3 release   
Hardware: x86-64 (AMD64)   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: a print screen of an error message

Description tom 2018-02-03 13:07:37 UTC
Created attachment 139552 [details]
a print screen of an error message

This .xlsx file has a long history with Libre Office. 
In Libre Office 4 Calc saving it caused it to lose its conditional formatting. 
In Libre Office 5 Calc that problem went away and the file saved correctly.
In Libre Office 6 I get this message that the the file can not be saved at all.
However I do not possess and cannot create suitable test documents that may be released under your licensing terms. Please contact me to make arrangements. 
I am happy to send the file in question to the developer assigned to investigate the problem, just not to make it available to all browsers of Bugzilla.
Thank you very much!
Comment 1 Bartosz 2018-02-04 00:15:34 UTC
Hello Tom.
I would like to investigate this issue, and create .xlsx document on which I could reproduce this issue.
Comment 2 Bartosz 2018-02-04 00:15:57 UTC
Please send me an document on my mail.
Comment 3 tom 2018-02-04 09:38:55 UTC
(In reply to Bartosz from comment #2)
> Please send me an document on my mail.

I sent two files to your email address. The December2017 file causes the problem and the earlier, one year old, February2017 file does not cause the write error problem.

My Libre Calc 6.0 can save other files but not the 8December2017 file. 
Libre Calc 5.4.2.2 can save both files.
My colleagues process these files using various versions of MS Office on Mac and Windows.

Thank you for your help!
Comment 4 tom 2018-03-01 14:18:54 UTC
I am worried that in April when my system gets upgraded from Ubuntu 17.10 to 18.04 that Libreoffice 6.0 will be the default and then I won't be able to work with this file that is critical for my job. 

I am a relatively new user. I know Ubuntu 17.10 must be upgraded to Ubuntu 18.04 within 3 months but I do not know how to keep running Libreoffice 5.5 under Ubuntu 18.04 if Libreoffice 6.0 is the default. If I deleted LO 6.0 and installed LO 5.5 wouldn't the system's software updater just undo what I did and bring me back up to LO 6.0? (Sorry, maybe that is an Ubuntu question rather than a Libreoffice question.) 

Is there any news about a fix? Thanks very much for your help!
Comment 5 Bartosz 2018-03-02 15:14:07 UTC
To install previous version of LibreOffice, you need to unistall current version of LibreOffice with command:

$ sudo apt remove libreoffice-core

And next download LO 5.4.5 from website:
https://www.libreoffice.org/download/download/

More information is available at:
https://askubuntu.com/questions/248953/can-i-use-an-older-version-of-libreoffice

Please let me know if this helps.
Comment 6 Bartosz 2018-03-02 15:30:41 UTC
Please confirm if the problem still exists with LO 6.0.2.
I was able to successful save your file under latest LO 6.0.1.1 (x64) on Windows 10.
I also checked it under Ubuntu 17.10 with LO 6.1, and files was saved successfully.
Comment 7 tom 2018-03-04 07:28:45 UTC
The file which would not save under LO 6.0.0.3 now saves under LO 6.0.2.1 !
Thank you very much for your help and for both of your last two comments. I am now temporarily running both LO 5.4.5 and LO 6.0.2 successfully.
Comment 8 Timur 2018-03-05 12:05:46 UTC
If a fix is known it's Fixed, if not than WorksForMe.
If not looked what this is a duplicate of.