Bug 123990 - FILEOPEN XLSX Conditional formatting of "Specific text" type should be case insensitive
Summary: FILEOPEN XLSX Conditional formatting of "Specific text" type should be case i...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Conditional-Formatting
  Show dependency treegraph
Reported: 2019-03-11 05:26 UTC by Aron Budea
Modified: 2020-10-08 08:49 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Sample XLSX (8.98 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-03-11 05:26 UTC, Aron Budea
Comparison screenshot (38.09 KB, image/png)
2019-03-11 05:27 UTC, Aron Budea

Note You need to log in before you can comment on or make changes to this bug.
Description Aron Budea 2019-03-11 05:26:18 UTC
Created attachment 149873 [details]
Sample XLSX

The attached XLSX contains sample conditional formatting created in Excel of type "Specific text" + all four types.
In Excel these rules are case insensitive, but in Calc they are interpreted case sensitively.

Observed using LO (4f810905fa74128871f2fe924a3d28a79f4e426), / Windows 7.
Comment 1 Aron Budea 2019-03-11 05:27:01 UTC
Created attachment 149874 [details]
Comparison screenshot
Comment 2 Justin L 2020-07-15 06:20:17 UTC
This could probably be an easyhack (although in practice this means it will ~never get fixed).
-OUString comparisons: https://api.libreoffice.org/docs/cpp/ref/a00774.html
-comparision code in sc/source/core/data/conditio.cxx

[Easy, unless of course this should be different for LO formats than MSO. Do you think there would be an uproar if ODS files started doing case-insensitive conditional formatting?  (The answer of course is yes, someone would complain.)]