Bug 81743 - Absolute reference for conditional formatting impossible
Summary: Absolute reference for conditional formatting impossible
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.4.2 release
Hardware: All All
: high major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
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:

Attachments
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 Dominik 2014-07-25 11:34:31 UTC 
as soon as a conditional formatting is added, the $'s disappear.

reproducible: always

steps:
# 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 
Confirmed:

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

regression - works on 3.3 at least

Updating version to 4.2.6.2 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: 4.1.4.2 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.