Issue 97728 - Named multi-ranges incompatible between 2.x and 3.x
Summary: Named multi-ranges incompatible between 2.x and 3.x
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOO300m9
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2009-01-03 22:11 UTC by villeroy
Modified: 2013-01-29 21:42 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description villeroy 2009-01-03 22:11:24 UTC 
In version 2 $SheetX.$A$1;$SheetX.$C$1 is a valid reference for a named
reference (Ctrl+F3).
In version 3 only ($SheetX.$A$1;$SheetX.$C$1) is valid.
Both syntactical variants are incompatible to each other.
See http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=13839 for
further reference and example file.
Comment 1 Regina Henschel 2009-01-04 00:46:32 UTC 
I think, that in OOo3 the concatenation operator is a tilde. After entering it
with semicolon it is converted automatically to tilde. So it should be
($SheetX.$A$1~$SheetX.$C$1).

But the problem remains, that a tilde is not converted to semicolon when saving
in ODF1.1 format, and the other way round, a semicolon in named expressions is
not converted to a tilde when importing an ODF1.1-document.

I have used OOo3.0 and OOoDEVm37 on WinXP.