Summary: | Conditional Formatting with Styles creates bad style on FILESAVE | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | kenneth.w.hightowerjr |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | UNCONFIRMED --- | ||
Severity: | minor | CC: | alstca, ilmari.lauhakangas, miguelangelrv |
Priority: | medium | ||
Version: | 7.3.2.2 release | ||
Hardware: | All | ||
OS: | Windows (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Attachments: | Issue File |
Description
kenneth.w.hightowerjr
2022-04-09 19:24:38 UTC
What file format do you use to save? Can you attach a sample file in the native LibreOffice file format '.ods'? Created attachment 179431 [details]
Issue File
As requested.
I do tend to use Excel formats for compatibility as everyone else I know uses Office products
[Automated Action] NeedInfo-To-Unconfirmed If I remember fine, in xlsx format, the conditional formats are manage not the same as in LibreOffice, so new style names are created by LibreOffice when open that files. Is there an Excel format that wont break? Xlsm, or just basic xls? I don't think so, but you can just test. (In reply to kenneth.w.hightowerjr from comment #2) > Created attachment 179431 [details] > Issue File > > As requested. > I do tend to use Excel formats for compatibility as everyone else I know > uses Office products This file seems to not be an original ODS file, but was saved to ODS from XLSX as it already has the ConditionalStyle_1 styles. I have the same kenneth.w.hightowerjr@outlook.com 2022-04-09 problem: If I create a new style to use in conditional formatting, it is no longer used, but it is replaced to "ConditionalStyle_1" Version: 7.6.0.3 (X86_64) / LibreOffice Community Build ID: 69edd8b8ebc41d00b4de3915dc82f8f0fc3b6265 CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: it-IT (it_IT); UI: it-IT Calc: threaded (In reply to Luca from comment #8) > .... Maybe because you save in xlsx format. It is how excel manage the conditional format styles. (In reply to Luca from comment #8) > I have the same kenneth.w.hightowerjr@outlook.com 2022-04-09 problem: > If I create a new style to use in conditional formatting, it is no longer > used, but it is replaced to "ConditionalStyle_1" > > Version: 7.6.0.3 (X86_64) / LibreOffice Community > Build ID: 69edd8b8ebc41d00b4de3915dc82f8f0fc3b6265 > CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: > win > Locale: it-IT (it_IT); UI: it-IT > Calc: threaded Can you attach an example file that is in .ods format and has never been saved as .xlsx? Then mention the steps that you did before the problem appeared. (In reply to m.a.riosv from comment #9) > (In reply to Luca from comment #8) > > .... > Maybe because you save in xlsx format. It is how excel manage the > conditional format styles. YES!!!! YOU ARE RIGHT!!! I copied e pasted all in a new file and saved as .ods ALL PERFECT! NO ERROR! NO PROBLEM! I saved as .xlsx and, now, conditional formatting doesn't use my styles, but new "ConditionalStyle_xx" styles Thank you (In reply to Buovjaga from comment #10) > (In reply to Luca from comment #8) > > I have the same kenneth.w.hightowerjr@outlook.com 2022-04-09 problem: > > If I create a new style to use in conditional formatting, it is no longer > > used, but it is replaced to "ConditionalStyle_1" > > > > Version: 7.6.0.3 (X86_64) / LibreOffice Community > > Build ID: 69edd8b8ebc41d00b4de3915dc82f8f0fc3b6265 > > CPU threads: 16; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: > > win > > Locale: it-IT (it_IT); UI: it-IT > > Calc: threaded > > Can you attach an example file that is in .ods format and has never been > saved as .xlsx? Then mention the steps that you did before the problem > appeared. thank you too Buovjaga. Let's set back to unconfirmed until we hear from Kenneth. |