Bug 143351 - Conditional format rule "range" part couldn't be imported.
Summary: Conditional format rule "range" part couldn't be imported.
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-Conditional-Formatting
  Show dependency tree / graph
 
Reported: 2021-07-14 10:07 UTC by Gülşah Köse
Modified: 2021-07-30 23:51 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
buggy file (86.38 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-07-14 10:07 UTC, Gülşah Köse 		Details
The example file in Excel and Calc (182.90 KB, image/png)
2021-07-15 13:44 UTC, NISZ LibreOffice Team 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Gülşah Köse 2021-07-14 10:07:47 UTC 
Created attachment 173555 [details]
buggy file

1) Open fdo87618-4.xlsx file in LibreOffice.
2) Click Format->Conditional->Manage...

Actual: Range part is empty for "No" rule.
Expected: Range part should refer to all related columns.

Additional info: Document reported in tdf#87618 for another reason that seems as resolved works for me.
Comment 1 NISZ LibreOffice Team 2021-07-15 13:44:55 UTC 
Created attachment 173601 [details]
The example file in Excel and Calc

Confirming with 

Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 717dc8e3575a18e1e18dc446031e6db4e60a873d
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL
Comment 2 NISZ LibreOffice Team 2021-07-15 13:48:11 UTC 
The range is given as $G:$G so the whole column G.

On the Calc UI I'm unable to select a whole column from the Conditional Formattting dialog. Manually entering $G:$G is converted by the OK button to G1:G1048576 - maybe the import could do this same magic.

Or just allow clicking on column/row headers in the minimized range selector.
Comment 3 Aron Budea 2021-07-30 23:51:09 UTC 
Already in 4.0.0.3.