Bug 81743

Summary:	Absolute reference for conditional formatting impossible
Product:	LibreOffice	Reporter:	Dominik <d0m1n1k>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED NOTABUG	QA Contact:
Severity:	major
Priority:	high	CC:	jmadero.dev, markus.mohrhard
Version:	4.1.4.2 release
Hardware:	All
OS:	All
See Also:	https://bugs.freedesktop.org/show_bug.cgi?id=34949 https://bugs.freedesktop.org/show_bug.cgi?id=61696 https://bugs.freedesktop.org/show_bug.cgi?id=65660 https://bugs.freedesktop.org/show_bug.cgi?id=75500
Whiteboard:
i915 platform:		i915 features:

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.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.