[Libreoffice-bugs] [Bug 153913] FILESAVE / FORMATTING: Failure to save / progressive loss of cell background colour of otherwise empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=153913 Stéphane Guillou (stragu) changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||3644 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153913] FILESAVE / FORMATTING: Failure to save / progressive loss of cell background colour of otherwise empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=153913 Stéphane Guillou (stragu) changed: What|Removed |Added See Also|https://bugs.documentfounda | |tion.org/show_bug.cgi?id=15 | |4066| -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153913] FILESAVE / FORMATTING: Failure to save / progressive loss of cell background colour of otherwise empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=153913 Stéphane Guillou (stragu) changed: What|Removed |Added CC||attila.sz...@collabora.com See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||1755 Resolution|WORKSFORME |FIXED Whiteboard||target:7.6.0 ||target:7.5.0.0.beta2 ||target:7.4.6 --- Comment #19 from Stéphane Guillou (stragu) --- Interestingly, I bibisected the fix to: commit c57d113e9ef8608f5690e8707a97879cb4f6a185 author Attila SzűcsTue Nov 29 09:45:36 2022 +0100 committer Andras TimarMon Dec 19 06:16:08 2022 + tdf#151755 fix export of borders of contentless cells Reviewed-on: https://gerrit.libreoffice.org/c/core/+/143880 I only checked using the XLS steps in comment 7, so please feel free to test other steps and filetypes to make sure the issue is indeed gone. In any case, thanks Attila! -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153913] FILESAVE / FORMATTING: Failure to save / progressive loss of cell background colour of otherwise empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=153913 Stéphane Guillou (stragu) changed: What|Removed |Added Status|NEEDINFO|RESOLVED Resolution|--- |WORKSFORME --- Comment #18 from Stéphane Guillou (stragu) --- (In reply to ady from comment #17) > Is this still happening in 7.6.alpha? I can't reproduce anymore using the steps in comment 8 or comment 7. Version: 7.6.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: a5c1c674e031087ef0516cebac049341dcdd2fcf CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153913] FILESAVE / FORMATTING: Failure to save / progressive loss of cell background colour of otherwise empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=153913 ady changed: What|Removed |Added Status|NEW |NEEDINFO --- Comment #17 from ady --- Is this still happening in 7.6.alpha? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153913] FILESAVE / FORMATTING: Failure to save / progressive loss of cell background colour of otherwise empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=153913 --- Comment #16 from Roman --- Yes, I'm sorry about that topic -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153913] FILESAVE / FORMATTING: Failure to save / progressive loss of cell background colour of otherwise empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=153913 --- Comment #15 from Stéphane Guillou (stragu) --- (In reply to Roman from comment #14) > Why is this off topic. I attached a screenshot showing that one column A has > formatting applied, but not the rest. I ran your steps, and the issue you describe is reproducible in 7.4 but not in 7.3. Therefore, it is the regression described in bug 154044 (the steps match exactly too). The issue described here is different and started a long time ago. Maybe you got the two reports confused? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153913] FILESAVE / FORMATTING: Failure to save / progressive loss of cell background colour of otherwise empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=153913 --- Comment #14 from Roman --- (In reply to Stéphane Guillou (stragu) from comment #13) > (Roman, what you describe is bug 154044, a different issue. I marked the > comments as "off-topic" to keep this report focused.) Why is this off topic. I attached a screenshot showing that one column A has formatting applied, but not the rest. I understand this should be an addition and input to the mass case since more than 2 people are reporting this issue. Почему это не по теме. я прикрепил скриншот на котором видно что в одном стобце A форматирование применилось, а на остальных нет. Я так понимаю это должно быть дополнение и ввод в массовый случай поскольку более 2 человек регистрирует эту проблему. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153913] FILESAVE / FORMATTING: Failure to save / progressive loss of cell background colour of otherwise empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=153913 --- Comment #13 from Stéphane Guillou (stragu) --- (Roman, what you describe is bug 154044, a different issue. I marked the comments as "off-topic" to keep this report focused.) -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153913] FILESAVE / FORMATTING: Failure to save / progressive loss of cell background colour of otherwise empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=153913 --- Comment #12 from Roman --- User Profile Reset: Yes -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153913] FILESAVE / FORMATTING: Failure to save / progressive loss of cell background colour of otherwise empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=153913 --- Comment #11 from Roman --- Created attachment 187390 --> https://bugs.documentfoundation.org/attachment.cgi?id=187390=edit А1 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153913] FILESAVE / FORMATTING: Failure to save / progressive loss of cell background colour of otherwise empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=153913 --- Comment #10 from Roman --- Description: Incorrect work with applying styles and values Steps to Reproduce: 1. Run Calc 2. Select more than 5 columns 3. Apply Border Borders 4. Press Ctrl+Z 5. look Calc_list Actual Results: The undo action was performed only on the first 1 columns Expected Results: Cancel all border selection Reproducible: Always User Profile Reset: No Additional Info: On version 7.4.2.3 Reverse history. And apparently it was corrected. The entire sheet in such cases should be single, and not partial. Version: 7.5.3.2 (X86_64) / LibreOffice Community Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3 CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: default; VCL: win Locale: ru-RU (ru_RU); UI: ru-RU Calc: CL threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153913] FILESAVE / FORMATTING: Failure to save / progressive loss of cell background colour of otherwise empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=153913 ady changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=15 ||4066 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153913] FILESAVE / FORMATTING: Failure to save / progressive loss of cell background colour of otherwise empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=153913 --- Comment #9 from ady --- >From bug 46738 comment 33 quote: - - - So validation and cell formatting is now saved for the first 1000 empty rows after the last one with actual cell content. Of course this is a temporary measure, so let's keep this one open for a proper solution for arbitrarily placed cell formatting. - - - Clearly the current situation is not "1000 empty rows", because I am only testing with some few rows, but the test is only a simplification, with no actual content, while the OP presents a case _with_ content. In either case we are not "1000" rows below the last cell with content. The second part of that quote is intriguing. Maybe some additional steps were taken, or maybe nothing else was done. I am wondering which permanent or temporal measures are currently valid. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153913] FILESAVE / FORMATTING: Failure to save / progressive loss of cell background colour of otherwise empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=153913 --- Comment #8 from ady --- (In reply to Stéphane Guillou (stragu) from comment #7) > I could reproduce (somewhat inconsistently) with steps in comment 3 and 4. Let me provide simple clear steps, just in case: 1. New Calc. 2. A1: > background color. 3. D10:E15 (or some other area) > background color. 4. G10:H15 (or some other area) > background color. 4.1 Add random areas as you wish with BC. 5. SAVE as XLS and/or XLSX. 6. Menu File > Reload. > See some area without background color now. 7. Save. 8. Menu File > Reload. Depending on the areas that were previously selected to have background color, at some point in the repeating cycle of SAVE and reload the file shows no new reduction of the BC attribute. IDK the exact pattern that actually "sticks" the attribute in the saved xls(x) file, but the behavior is consistently reproduced. What is not consistent is which exact area (or under which condition) gets the attribute actually saved "permanently" and which area loses the background color attribute when the file is saved and reloaded. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153913] FILESAVE / FORMATTING: Failure to save / progressive loss of cell background colour of otherwise empty cells
https://bugs.documentfoundation.org/show_bug.cgi?id=153913 Stéphane Guillou (stragu) changed: What|Removed |Added Blocks||108681 OS|Windows (All) |All See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=46 ||738 Keywords||notBibisectable, regression Summary|FILESAVE / FORMATTING: |FILESAVE / FORMATTING: |Failure to save cell|Failure to save / |background colour of|progressive loss of cell |otherwise empty cells |background colour of ||otherwise empty cells --- Comment #7 from Stéphane Guillou (stragu) --- (In reply to ady from comment #3) > (In reply to Stéphane Guillou (stragu) from comment #2) > > please share an original ODS document for us to test, not the resulting XLS > > file. > > Why? The report explicitly says this is about saving to xls. > Asking because I thought the issue happened when saving from ODS to XLS. I could reproduce (somewhat inconsistently) with steps in comment 3 and 4. I could also with the example XLS file: 1. Open attachment 185686 2. Go to sheet "Visual Growing Year" 3. Colour cell range N27:Y27 4. Save, then File > Reload Result: coloured cells lose colours. If you use the range L27:Y27 instead, the coloured range reduces to L27:O27 at first save + reload, then completely gone at second save + reload. Testing some more on the same row, with subsequent save + reloads, not sure if it helps: 12 cells -> nothing 13 cells -> 2 left -> nothing 14 cells -> 4 left -> nothing 15 cells -> 6 left -> nothing 16 cells -> 8 left -> nothing 17 cells -> 10 left -> 3 left -> nothing Not all rows behave like this. Regression, because I could not reproduce in OOo 3.3: OpenOffice.org 3.3.0 OOO330m20 (Build:9567) ...but might be a very early one, as Rainer points out in bug 46738. So not asking for a bibisect. Happy to keep this one open because the other one doesn't mention the *progressive* loss of background colour at each save action. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108681 [Bug 108681] [META] Cell formatting/style dialog bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.