Issue 96154 - calc->insert->name
Summary: calc->insert->name
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.0
Hardware: Unknown Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2008-11-12 14:31 UTC by operesson
Modified: 2013-01-29 21:53 UTC (History)
2 users (show)

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

works in OOo2.4 but no longer in OOo3 (7.07 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-11-12 15:11 UTC, Regina Henschel
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description operesson 2008-11-12 14:31:29 UTC
Lorsque j'essaie d'affecter une plage de cellules sur plusieur feuilles
($Feuille1.$B$2;$Feuille2.$B$2;$Feuille3.$B$2) à un nom, le message suivant
s'affiche : "Expression incorrecte". J'utilisais cette fonctionalité sans
problème  sous OOo2.4
Comment 1 Regina Henschel 2008-11-12 15:09:59 UTC
This is an international issue tracker. Therefore please write your issue in

In OOo 2.4.1 a named range like
is possible. That is no longer possible in OOo3.0. Existing documents open with
#NAME? error and when you try to define such name you get an "Invalid
Expression" error.
Comment 2 Regina Henschel 2008-11-12 15:11:22 UTC
Created attachment 57940 [details]
works in OOo2.4 but no longer in OOo3
Comment 3 jean_francois_philip 2009-06-01 10:20:22 UTC

In 2.4.2, your named range "werte" is correct with a Sum function, but is
incorrect with Countif function (error 504)

In 2.4.2 too, your named range "werte" is incorrect when you use Data > Validity
> Cell range > Source "werte" (only first cell in validity)

In 2.4.2, a named range with dispersed cells is possible with Insert > Names
>Define, but forbidden in Name Box

You comfirm in 2.4.1 ?