Bug 130132 - FILEOPEN. Calc background color is gone after restart
Summary: FILEOPEN. Calc background color is gone after restart
Status: RESOLVED DUPLICATE of bug 129393
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.3.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: target:6.5.0
Keywords: bibisected, bisected, dataLoss, regression
Depends on:
Blocks:
 
Reported: 2020-01-22 20:49 UTC by romrodz77@outlook.com
Modified: 2020-01-29 16:19 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
example to reproduce the bug (15.67 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-01-22 20:51 UTC, romrodz77@outlook.com
Details

Note You need to log in before you can comment on or make changes to this bug.
Description romrodz77@outlook.com 2020-01-22 20:49:28 UTC
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
Comment 1 romrodz77@outlook.com 2020-01-22 20:51:12 UTC
Created attachment 157342 [details]
example to reproduce the bug
Comment 2 Dagmara 2020-01-23 11:35:52 UTC
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.
Comment 3 Roman Kuznetsov 2020-01-28 21:50:12 UTC
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?
Comment 4 Roman Kuznetsov 2020-01-28 22:09:00 UTC
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?
Comment 5 Xisco Faulí 2020-01-29 14:19:55 UTC
issue fixed by https://git.libreoffice.org/core/commit/bf17db716f4ecaf28c2a0797bf90c9b0731015d6
Closing as a duplicate of bug 129393
Comment 6 Xisco Faulí 2020-01-29 14:20:07 UTC

*** This bug has been marked as a duplicate of bug 129393 ***
Comment 7 Commit Notification 2020-01-29 16:19:30 UTC
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.