Bug 135224 - LibreOffice does not seem to save conditionally formatted cells with data bars into XLS format
Summary: LibreOffice does not seem to save conditionally formatted cells with data bar...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.7.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: dataLoss, filter:xls
Depends on:
Blocks: Conditional-Formatting XLS
  Show dependency treegraph
 
Reported: 2020-07-28 11:55 UTC by shannongcole
Modified: 2022-12-23 00:31 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:
Regression By:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description shannongcole 2020-07-28 11:55:06 UTC
Description:
Conditionally formatted cells using Data Bars format properly, but conditional formatting formula disappears after saving, closing and reopening the file.  Version: Version: 6.4.4.2 (x64)

Steps to Reproduce:
1.Create a column of numbers or percentages, select all, go to Format, and Choose Conditional Formatting
2. Select data bars option.  Select OK and save.
3. Reopen file.

Actual Results:
Formula and display of conditional formatting is gone.

Expected Results:
Formula and display of conditional formatting remains after saving file and reopening.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
na
Comment 1 Michael Warner 2020-07-29 00:23:58 UTC
I was not able to replicate this in:

Version: 6.3.4.2
Build ID: 60da17e045e08f1793c57c00ba83cdfce946d0aa
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

Conditional data bars formatting saved and reloaded properly for me.
Comment 2 Roman Kuznetsov 2020-08-26 06:27:39 UTC
no repro for ODS and XLSX in

Version: 7.1.0.0.alpha0+ (x64)
Build ID: 15988fe00c4f49ae32ab2d5cf3c16495ab6e1d59
CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: Skia/Vulkan; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: CL

but repro for saving-reopening XLS!

@shannongcole@gmail.com which file format do you use for saving in that case?
Comment 3 shannongcole 2020-08-26 10:52:24 UTC
(In reply to Roman Kuznetsov from comment #2)
> no repro for ODS and XLSX in
> 
> Version: 7.1.0.0.alpha0+ (x64)
> Build ID: 15988fe00c4f49ae32ab2d5cf3c16495ab6e1d59
> CPU threads: 4; OS: Windows 6.1 Service Pack 1 Build 7601; UI render:
> Skia/Vulkan; VCL: win
> Locale: ru-RU (ru_RU); UI: en-US
> Calc: CL
> 
> but repro for saving-reopening XLS!
> 
> @shannongcole@gmail.com which file format do you use for saving in that case?

Thank you.

You are correct.  Yes, I am saving it in XLS, and this is where the problem is.  I apologize for omitting to add this to the steps.  I just tried saving in ODS and it works fine in that case.
Comment 4 Roman Kuznetsov 2020-08-27 13:17:46 UTC
In 4.4.7.2 the same problem
Comment 5 QA Administrators 2022-08-28 03:34:29 UTC Comment hidden (obsolete)
Comment 6 Roman Kuznetsov 2022-08-28 20:16:11 UTC
Still repro in

Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 4d78ed5c00b9c3c59ed28d24c28fd00e0f3a7657
CPU threads: 4; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win
Locale: ru-RU (ru_RU); UI: en-US
Calc: threaded