Issue 96154 - calc->insert->name
Summary: calc->insert->name
Status: CONFIRMED
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:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
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: ---

Attachments
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
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 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
English.

In OOo 2.4.1 a named range like
$Tabelle1.$B$1;$Tabelle2.$B$1;$Tabelle3.$B$1
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 
Hi,

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 ?