Description: Frozen row is not saved when saving file to XLS or XLSX, only frozen column is saved in these formats. This bug does not affect saving to ODS. Steps to Reproduce: 1. Create a new file in Calc 2. Go e.g. to B2 cell 3. Click "Freeze Rows and Columns" button in the toolbar (or use View/Freeze Cells" menu 4. Save file as XLS or XLSX 5. Exit Calc 6. Open the saved file Actual Results: The row is not frozen (only the column is). Expected Results: Both the row and column should be frozen. Reproducible: Always User Profile Reset: No Additional Info: It looks that if Calc is not exited and only the file is closed and reopened the status of frozen row is remembered. But it is forgotten when Calc exits. User-Agent: Mozilla/5.0 (X11; Fedora; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0
I can't reproduce it in Version: 5.4.0.0.alpha0+ Build ID: 634589b340316ba64b731b4d923c1056be415494 CPU Threads: 4; OS Version: Linux 4.8; UI Render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); Calc: group or Version: 5.2.3.3 Build ID: d54a8868f08a7b39642414cf2c8ef2f228f780cf CPU Threads: 4; OS Version: Linux 4.8; UI Render: default; Locale: ca-ES (ca_ES.UTF-8); Calc: group
Tried with a new profile, but the issue persists. Version: 5.2.3.3 Build ID: 5.2.3.3-11.fc25 CPU Threads: 2; OS Version: Linux 4.8; UI Render: default; Locale: cs-CZ (cs_CZ.UTF-8); Calc: group
No repro. Tried also with GTK3 as I noticed Fedora being used by reporter. Arch Linux 64-bit, KDE Plasma 5 Version: 5.4.0.0.alpha0+ Build ID: 06ea887f8ba34a628d7641eab210501f7bd2493d CPU Threads: 8; OS Version: Linux 4.8; UI Render: default; VCL: kde4; Locale: fi-FI (fi_FI.UTF-8); Calc: group Built on December 16th 2016
Investigated the issue further and it seems that it does not manifest when the file is opened from within LibreOffice application. I mean the issue is apparent when opening the file e.g. from file manager by double-click on its icon, which is the most common way in my usage, but also manifests when the XLS file is used as a parameter of "libreoffice" command in terminal. So it seems to me that it is not an issue of saving the frozen row status but rather an issue of opening the file.
(In reply to pavelz from comment #4) > I mean the issue is apparent when opening the file e.g. from file manager by > double-click on its icon, which is the most common way in my usage, but also > manifests when the XLS file is used as a parameter of "libreoffice" command > in terminal. Well, I don't see the issue when opening like that.
It must be specific to my environment then. I tried to reproduce that in live session of Fedora 25, which should be closest to what I am running just now and the issue is not there. It is really strange, I am running Fedora 25 (upgraded from 24), but there were already some updates to LO, so my version of LO is not the same as in the live session. I also tried to reinstall LO packages but it makes no difference. I filed the bug against Red Hat bugzilla - https://bugzilla.redhat.com/show_bug.cgi?id=1406081
no repro. Version: 6.0.0.0.alpha0+ Build ID: 77f77c57d336ba041faf51e2168372d1e0962a19 CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk2; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-06-29_23:40:47 I think we can close the bug?
pavelz: maybe test with a fresh master http://dev-builds.libreoffice.org/daily/master/Linux-rpm_deb-x86_64@70-TDF/current/ https://wiki.documentfoundation.org/Installing_in_parallel/Linux
Please test with a master build as mentioned in comment 8
Cannot reproduce it more with the current version, so changing status to resolved. Version: 5.2.7.2 Build ID: 5.2.7.2-4.fc25 CPU Threads: 2; OS Version: Linux 4.11; UI Render: default; VCL: gtk3; Locale: cs-CZ (cs_CZ.UTF-8); Calc: group
(In reply to pavelz from comment #10) > Cannot reproduce it more with the current version, so changing status to > resolved. > > Version: 5.2.7.2 > Build ID: 5.2.7.2-4.fc25 > CPU Threads: 2; OS Version: Linux 4.11; UI Render: default; VCL: gtk3; > Locale: cs-CZ (cs_CZ.UTF-8); Calc: group Sorry, I was too quick, the issue is still present in 5.2.7.2-4.fc25, but it only manifests under wayland session. Leaving status as resolved, because it works in fresh master even under wayland: Version: 6.0.0.0.alpha0+ Build ID: 6e7300d1046a195068fa97a0d91a95f19cc5c056 CPU threads: 2; OS: Linux 4.11; UI render: default; VCL: gtk2; TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-07-03_23:43:13 Locale: cs-CZ (cs_CZ.UTF-8); Calc: group
Hmm, I think we should leave open, because you used gtk2 backend with the master build. I'm not sure, if we have a master build with gtk3 included.
(In reply to Buovjaga from comment #12) > Hmm, I think we should leave open, because you used gtk2 backend with the > master build. I'm not sure, if we have a master build with gtk3 included. Probably you are right, when SAL_USE_VCLPLUGIN=gtk is set the issue is not even in 5.2.7.2-4.fc25 under wayland (gtk2 is used). SAL_USE_VCLPLUGIN=gtk3 has no effect on master build, gtk2 is still used. SAL_USE_VCLPLUGIN=gen works for both. So from my lay view it looks like a problem with gtk3 under wayland, not sure what the proper status should be set.
*** Bug 114797 has been marked as a duplicate of this bug. ***
//Steps to Reproduce: //1. Create a new file in Calc //2. Go e.g. to B2 cell //3. Click "Freeze Rows and Columns" button in the toolbar (or use View/Freeze //Cells" menu //4. Save file as XLS or XLSX //5. Exit Calc //6. Open the saved file //Actual Results: //The row is not frozen (only the column is). //Expected Results: //Both the row and column should be frozen. Cannot able to reproduce this issue.. This issue is working fine in Windows 7 (32 bit),LibreOffice 6.0.2 .... Try to close the ticket......
Bug 114797 was about Windows. XLSX was not mentioned. Terry: was your problem seen with ODS? This bug is about XLS or XLSX on Linux with GTK3 and Wayland.
Hello pavelz, Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Cannot reproduce any more. Version: 6.0.6.2 Build ID: 6.0.6.2-3.fc28 CPU threads: 2; OS: Linux 4.18; UI render: default; VCL: gtk3; Locale: cs-CZ (cs_CZ.UTF-8); Calc: group