Created attachment 72805 [details] screenshots of HUD spreadsheet before and after saving/re-opening Problem description: I have a spreadsheet for making a HUD Settlement Statement which I've used for at least 5yrs. I don't use this spreadsheet often, but I think the problem arose when upgrading from 3.5.3 to 3.6.x #genlop -e libreoffice-bin Mon Aug 1 09:28:21 2011 >>> app-office/libreoffice-bin-3.3.1 Fri Aug 19 18:28:34 2011 >>> app-office/libreoffice-bin-3.3.4 Thu Dec 22 15:06:05 2011 >>> app-office/libreoffice-bin-3.3.4 Wed Jun 20 13:53:27 2012 >>> app-office/libreoffice-bin-3.5.4.2-r1 Mon Aug 27 10:17:20 2012 >>> app-office/libreoffice-bin-3.5.5.3 Mon Aug 27 16:11:16 2012 >>> app-office/libreoffice-bin-3.5.5.3 Wed Dec 5 10:13:37 2012 >>> app-office/libreoffice-bin-3.6.3.2 Fri Dec 14 11:26:27 2012 >>> app-office/libreoffice-bin-3.6.4.3 Thu Dec 20 11:38:37 2012 >>> app-office/libreoffice-bin-3.6.3.2 Thu Jan 10 11:23:32 2013 >>> app-office/libreoffice-bin-3.6.4.3 Steps to reproduce: 1. open spreadsheet, formatting looks fine 2. click save, formatting still looks fine 3. close then re-open, now formatting screwed up. Current behavior: Expected behavior: Operating System: Linux (Other) Version: 3.6.4.3 release
We need the original document or some document where we can observe the problem. Marking as NEEDINFO, please get us a document that clearly displays the behavior after saving. Once you attach document marked as UNCONFIRMED and we will try to triage it. Thanks!
Created attachment 79980 [details] Example ods documents showing problem Here are two spreadsheets in a zipfile. The "original.ods" used to work just fine. Now, as soon as I make any changes to it and then save, upon re-opening it's all screwed up. I've gone ahead and opened "original.ods" then changed the Settlement Agent field to "Jane Doe" and saved as "modified.ods" Opening the "modified.ods" shows it's now screwed up.
Hey Jeremy - I will check this but in the future please read the instructions carefully: "Once you attach document marked as UNCONFIRMED and we will try to triage it. Thanks!" In NEEDINFO status - QA ignores the bug, assuming it still needs input from reporter, I luckily caught this in a flood of email I get so will triage it. Thanks for the additional info
@Jeremy - please upgrade to latest stable (preferably 4.0 series as 3.6 is coming quickly to EOL). I tested on 4.0.3.3 release as well as 4.2 master and I had no problem at all. Marking as WFM - if you test on the latest stable release and get same results please set bug to UNCONFIRMED and let us know what version you tested on. Also, what distribution are you using and how are you installing LibreOffice?
OK, I will try the 4.0 series. I run Gentoo linux and there are two packages for libreoffice, a pre-compiled, stable release libreoffice-bin: app-office/libreoffice-bin Available versions: 3.6.4.3^st 3.6.6.2^st {aqua +cups debug gnome java kde ELIBC="FreeBSD"} Installed versions: 3.6.4.3^st(11:21:41 AM 01/10/2013)(cups java kde -aqua -debug -gnome ELIBC="-FreeBSD") Homepage: http://www.libreoffice.org Description: LibreOffice, a full office productivity suite. Binary package. And there's a version which must be compiled which usually takes a lot of memory/disk space/time so I usually don't bother and just use the pre-compiled release. I'll try out 4.0.3.3 and let you know if that solves the problem. * app-office/libreoffice Available versions: 3.6.4.3 3.6.6.2 **3.6.9999 ~4.0.3.3 **4.0.9999 **4.1.9999 **9999-r2 {aqua binfilter binfilterdebug bluetooth +branding +cups dbus debug eds gnome gstreamer +gtk gtk3 java jemalloc kde mysql odk opengl postgres telepathy test +vba +webdav ELIBC="FreeBSD" LIBREOFFICE_EXTENSIONS="nlpsolver pdfimport presenter-console presenter-minimizer scripting-beanshell scripting-javascript wiki-publisher" PYTHON_SINGLE_TARGET="python2_5 python2_6 python2_7 python3_3" PYTHON_TARGETS="python2_5 python2_6 python2_7 python3_3"} Homepage: http://www.libreoffice.org Description: LibreOffice, a full office productivity suite.
OK, I installed the Gentoo version of libreoffice which needs to be compiled. I installed version 4.0.3.3 [I] app-office/libreoffice Available versions: 3.6.4.3 3.6.6.2 **3.6.9999 (~)4.0.3.3 **4.0.9999 **4.1.9999 **9999-r2 {aqua binfilter binfilterdebug bluetooth +branding +cups dbus debug eds gnome gstreamer +gtk gtk3 java jemalloc kde mysql odk opengl postgres telepathy test +vba +webdav ELIBC="FreeBSD" LIBREOFFICE_EXTENSIONS="nlpsolver pdfimport presenter-console presenter-minimizer scripting-beanshell scripting-javascript wiki-publisher" PYTHON_SINGLE_TARGET="python2_5 python2_6 python2_7 python3_3" PYTHON_TARGETS="python2_5 python2_6 python2_7 python3_3"} Installed versions: 4.0.3.3(06:05:15 PM 05/30/2013)(branding cups dbus gstreamer gtk java kde mysql opengl postgres vba webdav -aqua -bluetooth -debug -eds -gnome -jemalloc -odk -telepathy -test ELIBC="-FreeBSD" LIBREOFFICE_EXTENSIONS="presenter-minimizer -nlpsolver -scripting-beanshell -scripting-javascript -wiki-publisher" PYTHON_SINGLE_TARGET="python2_7 -python3_3" PYTHON_TARGETS="python2_7 -python3_3") Homepage: http://www.libreoffice.org Description: LibreOffice, a full office productivity suite. It took about 6 hours to compile on my old dual core cpu: AMD Athlon(tm) 64 X2 Dual Core Processor 4200+ But UPGRADING from 3.0 series to 4.0 series FIXED the issue for me too! Now I just need to replace the pre-compiled libreoffice-bin-3.0 with libreoffice-4.0.3.3 on my octo core cpu which hopefully won't take 6 hrs. THANKS for looking into this bug -- I really didn't want to have to re-write spreadsheets.
Migrating Whiteboard tags to Keywords: (bibisectrequest) [NinjaEdit]