Created attachment 122902 [details] File with cells hidden Cells that were previously hidden became visible. Steps: Download OriginalFile.xlsx Open It > make no changes > select "Save As" > Select any location on computer > keep xlsx file extension > Save Open the saved file once again. Now Instead of having lines from 1 to 12 hidden, only Line 1 remains hidden. Lines 2 - 12 became visible. (This is related to Bug 74932)
Hi @Merlinux, I can't reproduce. Win10x64 Version: 5.1.1.1 (x64) Build ID: c43cb650e9c145b181321ea547d38296db70f36e CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL;
@m.a.riosv Hi. I just upgraded to 5.1.1.1 (x64) and run it under Win10x64 machine but i still get the same bug. Everytime i make a "Save As" to the downloaded file it gets messed up!
Please try resetting the user profile, sometimes solves strange issues. https://wiki.documentfoundation.org/UserProfile Usually it's enough renaming/deleting the file "user/registrymodifications.xcu", it affects all the options in Menu/Tools/Options, and the files "user/basic/dialog.xlc" and "scrip.xlc" are overwritten, additionally custom colors in "user/config/standard.soc" are lost.
I've renamed the user folder, forcing it to create a new one whit all inside it - It did not solve the problem! :( Can anything else be tried?
Hi Merlinux, sorry my mistake doing the test. Reproducible Win10x64 Version: 5.0.5.2 (x64) Build ID: 55b006a02d247b5f7215fc6ea0fde844b30035b3 Version: 5.1.1.1 (x64) Build ID: c43cb650e9c145b181321ea547d38296db70f36e CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL;
I think I found possible fix in xetable.cxx
Created attachment 125705 [details] OriginalFIle after save with patched version of LibreOffice I managed to fix that issue with hidden rows. COuld you please check if attached xlsx file is correct now?
The file looks fine, but as expected after save with Win10x64 Version: 5.1.4.2 (x64) Build ID: f99d75f39f1c57ebdd7ffc5f42867c12031db97a CPU Threads: 1; OS Version: Windows 6.19; UI Render: GL; rows are visible again.
Review for the fix: https://gerrit.libreoffice.org/#/c/26421/
@m.a.riosv Could you please check also if this file is working correctly with MS Excel? I tested it with Office 365, but I would confirm if it also working correctly with standard MS Excel.
Sorry, but I have not MS Excel.
Created attachment 125733 [details] OriginalFile after save to .xls with patched version of LibreOffice The fix is also resolving issue with hidden rows, also after save to .xls file.
I have tested .xlsx and .xls files generated by Libreoffice (with empty rows hidden), and everything is working perfectly fine on MS Excel 2010.
*** Bug 91153 has been marked as a duplicate of this bug. ***
Great! Any ETA?
Bartosz Kosiorek committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=228c25fd17727660a3372307e3f73dbcff5e71d2 tdf#98106 Preserving hidden and empty rows after xlsx export It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Bartosz Kosiorek committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=7dd19273530730478b5ed24b79f42ac480c7ae43&h=libreoffice-5-2 tdf#98106 Preserving hidden and empty rows after xlsx export It will be available in 5.2.5. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Eike Rathke committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f5bca308c910c4486b2e5c8f67f628ae8e9c2457 sc-perf: call RowHidden() only once, tdf#98106 follow-up It will be available in 5.4.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Tested Version: 5.3.0.0.beta1+ (x64) Build ID: 7f47d68c4310b8bae09286a81036a6fa669a1705 CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Layout Engine: new; TinderBox: Win-x86_64@62-TDF, Branch:libreoffice-5-3, Time: 2016-12-08_16:10:30 Locale: es-ES (es_ES); Calc: CL Version: 5.4.0.0 alpha0+, TB Win-x86@39, Time 2016-12-10_23:50:52
I can confirm as well this bug is now fixed. Thank you!
The fix has caused several bug reports. If these are not properly fixed before 5.2.6 is released, I suggest that this patch be reverted from the 5.2 series.
changed earliest version affected to 3.5 - the earliest I could test with bibisect43all.
Justin Luth committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=3e67dc9dbbd802dd82b92304098aaa44e70c014c&h=libreoffice-5-2 revert tdf#98106 Preserving hidden and empty rows after xlsx export It will be available in 5.2.6. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.