Rows always stay hidden, but columns do not! I'm just trying to keep the sheets user friendly, and for looks sake, so it's not a must, but odd it does such, how do I keep them hidden? Calc.ods Version 6.3.2.2, on windows 10
I have ask this on Ask L. O. at https://ask.libreoffice.org/en/question/217483/hidden-columns-keep-reappearing-after-i-hide-them/
Please attach a sample file and detail the steps to reproduce the issue. And copy the information on Menu/Help/About LibreOffice.
Created attachment 156052 [details] All sheets locked, no password needed to unlock.
What columns were hidden that are visible on opening?
I hide columns that I do not use, Like column w to amj! I tried to leave a file, but didn't understand it to well, hope its there, if not here is how I share it. http://bit.ly/faithalone
[Automated Action] NeedInfo-To-Unconfirmed
Opening the sample file saved and reopening. Reproducible with: Version: 6.3.3.2 (x64)Build ID: a64200df03143b798afd1ec74a12ab50359878ed Version: 6.4.0.0.beta1 (x64)Build ID: 4d7e5b0c40ed843384704eca3ce21981d4e98920 Version: 6.5.0.0.alpha0+ (x64)ID: d312d02cf43928361be34207a0cdd2d95b3ec5fd But not with: Version: 6.1.6.3 (x64)Build ID: 5896ab1714085361c45cf540f76f60673dd96a72 Version: 6.2.8.1 (x64)Build ID: 815fe723fb0e60e4a39ff860f907cc63980a0232
I keep getting emails. Not sure why. I just downloaded my file. filled out starting data, saved it, closed it, oprned it, columns appeared! Even thou they were locked! Rows didn't, they stayed hidden. I'm ok with it, still, just thought you might want to know.
Because the bug have been marked as NEW.
OH, ok, thanks. I really new here!
Cannot reproduce with Version: 6.4.0.0.beta1+ Build ID: 930a03566c06c6a0ab358429628b8838e24dbb8f CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; open attached file hide columns W to AH save,reload columns are hidden Can you retest with dev version? http://dev-builds.libreoffice.org/daily/master/
Regression introduced by: https://cgit.freedesktop.org/libreoffice/core/commit/?id=7282014e362a1529a36c88eb308df8ed359c2cfa author Noel Grandin <noel.grandin@collabora.co.uk> 2019-02-01 15:15:16 +0100 committer Mike Kaganski <mike.kaganski@collabora.com> 2019-04-05 13:43:52 +0200 commit 7282014e362a1529a36c88eb308df8ed359c2cfa (patch) tree 2776ad9601f494330076ac58c08554e719c6ab3a parent df30a4515b1303b0891baa53754fa9b3e47e0c02 (diff) tdf#50916 Makes numbers of columns dynamic. Bisected with: bibisect-linux64-6.3 Adding Cc: to Noel Grandin
Still happening in LO 6.4.1 under Linux
Estou com a versão 7.0 instalada e esse problema continua ocorrendo. As colunas ocultas à direita da planilha voltam a aparecer cada vez que se abre uma nova versão dela, mesmo que se volte a ocultar as colunas e gravar. Não são todas as colunas que reaparecem, e ainda não consegui identificar um padrão para o problema.
No repro. Version: 7.1.0.0.alpha0+ (x64) Build ID: e00e2be30436b636d93f8852bb6af44972638a7c CPU threads: 4; OS: Windows 10.0 Build 20180; UI render: Skia/Vulkan; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: threaded
*** Bug 142769 has been marked as a duplicate of this bug. ***
*** Bug 142029 has been marked as a duplicate of this bug. ***
This bug was reported for 6.3-6.4, sample attachment 156052 [details] and column W to AMJ. Bug 142029 was reported for 6.4, sample attachment 171636 [details], column J to column AMJ. Bug 142769 was reported for 7.1, sample steps, D to last column. We had "no repro for 7.1" but also it was once for 6.4, meaning that something is missing, I guess exact or large number of hidden columns. I don't know how to select to AMJ, I hope it's not by scrolling.
Steps in bug 142769 are good, and with that and Bug 142029 I reproduced with 7.2+: 1) I create a calc ods spreadsheet file 2) select columns from D to last column with: Ctrl-Shift+right arrow and hide 3) save the file and close 4) reopen the file and type something in some cell 5) save the file again and close 6) reopen the file and see that columns BM through AMJ are visible again.
No repro Version: 7.1.4.2 (x64) / LibreOffice Community Build ID: a529a4fab45b75fefc5b6226684193eb000654f6 CPU threads: 4; OS: Windows 10.0 Build 21387; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: threaded
Miguel, you need to repro with some version to say WFM of bio repro with current. I did repro with 7.2+ so I set New again.
See the example video of the bug happening. The 'C' column should be the last visible column. But after reopening the edited file, the columns from BM onwards became visible. These columns were expected to be hidden. https://sendvid.com/kf3tqdzn or https://www.mediafire.com/file/al5ijvcmaern6jr/bug.mp4/file ------ Version: 7.1.4.2 / LibreOffice Community Build ID: 10(Build:2) CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3 Ubuntu package version: 1:7.1.4~rc2-0ubuntu0.20.04.1~lo1 Linux Mint Cinnamon x64 20.1 X11
*** Bug 136618 has been marked as a duplicate of this bug. ***
*** Bug 144316 has been marked as a duplicate of this bug. ***
If experimental Large spreadsheet is enabled, bug seen already after step 3 from Comment 19. If not, it takes another save and reopen, as explained.
I'm using 7.2.2.2 x86 portable version on Windows 10. I have a spreadsheet with 360 rows, columns A-P in use, Q-AMJ are hidden, or are supposed to be but they don't stay that way. This is what I'm seeing happen: Hide columns -> save -> exit Calc -> open ods -> columns still hidden. Open ods -> columns still hidden, but Calc forgot my last view (should be @ row 316 but view was at row 1) -> exit Calc. Repeated 5 times for consistency. Open ods -> change data in a cell -> exit Calc with X icon and save changes with dialog that pops up about unsaved changes -> open ods -> columns not hidden anymore. Seems like some condition in the load or save function is ignoring the hidden flag for the columns. Please let me know if I can help further.
Prior to comment 12's commit, LO was exporting something like table:number-columns-repeated="1017" // (1024- number of columns showing) but afterwards it was exporting table:number-columns-repeated="57" // (64 - number of columns showing)
Created attachment 176792 [details] hiddenEmptyColumns.ods: all 1017 columns after G are hidden. Round-tripping this minimalistic example changes it to repeat for only 64 columns. So I'm guessing that because there is no content in any of these columns, the spreadsheet remains at its INITIALCOLCOUNT of 64. That suggests that import just needs to increase the column allocation to account for the hidden columns.
Proposed fix at http://gerrit.libreoffice.org/c/core/+/126540. Note that we won't be able to FIX already broken documents, but this will prevent it from happening in the future. [I suppose that since we know the first 64 columns are hidden, we don't actually need to display more, so perhaps some work could still be done to FIX the already broken documents. However, I expect that will be a LOT more complex and regression-prone.]
Justin Luth committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/297ab561c6754f89326a1e8ce1751233669578d7 tdf#128895 sc xmlimport: create enough dynamic cols if props It will be available in 7.4.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Justin Luth committed a patch related to this issue. It has been pushed to "libreoffice-7-3": https://git.libreoffice.org/core/commit/ea229b09c3de7edb8fcb01a727b656f4d35821d4 tdf#128895 sc xmlimport: create enough dynamic cols if props It will be available in 7.3.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Justin Luth committed a patch related to this issue. It has been pushed to "libreoffice-7-2": https://git.libreoffice.org/core/commit/5e76c14d20799a2cbecdccc2e8b71961a0696f15 tdf#128895 sc xmlimport: create enough dynamic cols if props It will be available in 7.2.5. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
I updated 7.2.4.1 windows 10. Same computer I used when I first mentioned the bug! THANKS! A lot, it works. I sort a forgot how, why, it would reopen columns but I closed file and reopened it and no extra columns. Great work! Again Thanks