Bug 81743 - Absolute reference for conditional formatting impossible
Summary: Absolute reference for conditional formatting impossible
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: high major
Assignee: Not Assigned
Depends on:
Reported: 2014-07-25 11:34 UTC by Dominik
Modified: 2014-07-30 14:05 UTC (History)
2 users (show)

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


Note You need to log in before you can comment on or make changes to this bug.
Description Dominik 2014-07-25 11:34:31 UTC
as soon as a conditional formatting is added, the $'s disappear.

reproducible: always

# open calc
# format -> conditional formatting -> manage
# choose anything, select a cell or range (notice the default $'s for absolute reference)
# click OK
# range is displayed as relative reference (without $'s)
Comment 1 Joel Madero 2014-07-26 22:30:50 UTC

New - confirmed
Major - loss of data
High - default seems fine

regression - works on 3.3 at least

Updating version to rc as I've confirmed on that version (version is the oldest version that we can confirm on not the latest - we just use comments on that)
Comment 2 Markus Mohrhard 2014-07-27 11:56:59 UTC
Are you guys talking about the range field?
Comment 3 Joel Madero 2014-07-30 03:23:50 UTC
@Markus - Indeed and I just realized I was comparing two different things (the dialog looks different in 3.3). I can't confirm that this is a regression so removing regression and bibisectRequest + updating version

Verified same issue: release
Comment 4 Markus Mohrhard 2014-07-30 14:05:58 UTC
Which makes this bug report invalid.

That is a range and not a reference and ranges are never absolute or relative. This just represents a range in a sheet.