Issue 32247 - display error in formulas contaning sheet references with spaces
Summary: display error in formulas contaning sheet references with spaces
Status: CLOSED DUPLICATE of issue 23893
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.1.2
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: ooo
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-07-28 18:48 UTC by mjmcvey
Modified: 2013-08-07 15:12 UTC (History)
1 user (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 mjmcvey 2004-07-28 18:48:58 UTC 
file was converted from excel initially, but I doubt that matters....

it seems that when editing a formula with references to another sheet, the
display is confused when the other sheet has a space in its name.

=sum($Other Sheet.a1:a2) will draw incorrectly when edited
=sum($Other_Sheet.a1:a2) will draw correctly when edited
Comment 1 frank 2004-07-30 16:07:17 UTC 
Hi,

I was not able to reproduce this Issue.

Please be more precise and add a step by step description how to reproduce your
problem.

Thanks

Frank
Comment 2 mjmcvey 2004-07-30 18:26:53 UTC 
open a new spreadsheet with Sheet1, Sheet2, Sheet3.

insert the following into Sheet1.A1:
=A2+SUM(Sheet2.$A2:$A3)

rename Sheet2 to 'Sheet 2'

Now go back and edit the formula in cell Sheet1.A1.
In the example, it shows only the part after the space in color (red for me) and
hi-lites that region on the *current* sheet. This can be misleading/distracting
in very complex formulas.

I think the formula is confused by the combination of the space and the : since
it seems OK with single-cell references.
Comment 3 frank 2004-08-02 09:33:10 UTC 
Hi Eike,

the problem is that the colored cell reference in Edit mode of the cell is not
correct if the Sheet name contains a Space.

Frank
Comment 4 frank 2004-08-02 09:36:23 UTC 
set the target
Comment 5 ooo 2004-10-12 11:04:25 UTC 
Dupe.


*** This issue has been marked as a duplicate of 23893 ***
Comment 6 ooo 2004-10-12 11:05:10 UTC 
Closing dupe.