Description: When I fill a cell with a background color, after restart it will be white again. It happens if the cell is further away from the last row and column with any content inside (text, number, formula...). In other words, if the sheet has content in cells from A1 to Y60, the background color for Z1 or A61 will be gone after restart. In the sheets that I used and the problem could be reproduced I have used conditional formatting (somewhere else than the affected cells)and "Freeze files and columns" to keep some of them visible when scrolling. Steps to Reproduce: 1.Open the attachment. 2.Go to cell PO7, for example. 3.Fill cells from PO7 to PT15 with any colour. 4.Save and restart. Cells are white again. Actual Results: Cells are white again after restart. Expected Results: Cells should be coloured. Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: Versión: 6.3.4.2 (x64) Id. de compilación: 60da17e045e08f1793c57c00ba83cdfce946d0aa Subprocs. CPU: 8; SO: Windows 10.0; Repres. IU: GL; VCL: win; Configuración regional: es-ES (es_ES); Idioma de IU: es-ES Calc: CL
Created attachment 157342 [details] example to reproduce the bug
I can reproduce the bug with version: Version: 6.4.0.1 (x64) Build ID: 1b6477b31f0334bd8620a96f0aeeb449b587be9f CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: default; VCL: win; Locale: pl-PL (pl_PL); UI-Language: en-US Calc: threaded But the bug only appears when the cells with a background color are empty. I wrote some text in the the cells with a background color, saved and close. Then I reopened it and the cells had a color background as they were supposed to.
no repro in Версия: 6.5.0.0.alpha0+ ID сборки: 6095612850973388ba5b121b34d02292a2548e7d Потоков ЦП: 4; ОС:Linux 5.5; Отрисовка ИП: по умолчанию; VCL: kf5; TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2020-01-17_00:43:05 Локаль: ru-RU (ru_RU.UTF-8); Язык интерфейса: ru-RU Calc: threaded windows only?
confirm in Версия: 6.3.3.2 (x64) ID сборки: a64200df03143b798afd1ec74a12ab50359878ed Потоков ЦП: 4; ОС:Windows 10.0; Отрисовка ИП: GL; VCL: win; Локаль: ru-RU (ru_RU); Язык интерфейса: ru-RU Calc: threaded but not in Version: 6.4.0.3 (x64) Build ID: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8 CPU threads: 4; OS: Windows 10.0 Build 17763; UI render: GL; VCL: win; Locale: ru-RU (ru_RU); UI-Language: en-US Calc: threaded nor in Версия: 7.0.0.0.alpha0+ (x64) ID сборки: 47c598260a8f07cf3a1e4cab061df3f2d261932c Потоков ЦП: 4; ОС:Windows 10.0 Build 17763; Отрисовка ИП: GL; VCL: win; Локаль: ru-RU (ru_RU); Язык интерфейса: ru-RU Calc: threaded Xisco, how we can backport fix to 6.3 branch? Need a reverse bisect?
issue fixed by https://git.libreoffice.org/core/commit/bf17db716f4ecaf28c2a0797bf90c9b0731015d6 Closing as a duplicate of bug 129393
*** This bug has been marked as a duplicate of bug 129393 ***
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/1332a16f42c47f377a29cb53c17704a449235664 tdf#130132, tdf#129393: Add unittest It will be available in 6.5.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.