Issue 107501 - Indirect and Address functions with space in label sheet
Summary: Indirect and Address functions with space in label sheet
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOO320m7
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: kla
QA Contact: issues@sc
URL:
Keywords: regression
Depends on:
Blocks: 99999
  Show dependency tree
 
Reported: 2009-12-07 15:40 UTC by jeffooo
Modified: 2013-08-07 15:14 UTC (History)
4 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 jeffooo 2009-12-07 15:40:56 UTC 
Hi,

With OOo320m6 and OOo320m7 on WindowsXP & Vista

Steps to reproduce :

- open a new calc document
- menu Format > Sheet > Rename, insert a space in sheet name (for example "Sheet 1")
- in A1 :
"test"
- in A2 :
=INDIRECT(ADDRESS(1;1;;;"Sheet 1"))

-> #REF error
Comment 1 jbf.faure 2009-12-08 05:18:55 UTC 
I reproduce the problem with OOO320_m7 under Ubuntu 8.04.
No problem with OOo 3.1.1 => keyword regression set.

Regards
JBF
Comment 2 ooo 2009-12-08 12:40:59 UTC 
Grabbing issue.
Comment 3 ooo 2009-12-08 12:43:26 UTC 
Added issue to CWS jl146
http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=OOO320%2Fjl146
Comment 4 ooo 2009-12-09 11:18:58 UTC 
In cws jl146:

revision 277763
sc/source/core/tool/address.cxx
Comment 5 ooo 2009-12-11 11:54:23 UTC 
Reassigning to QA for verification.
Comment 6 kla 2009-12-11 16:39:01 UTC 
String works fine -> verified
Comment 7 jbf.faure 2009-12-21 09:18:29 UTC 
works fine in OOo 3.2 RC1 (OOO320_m8) under Ubuntu and Vista. Thanks.
Closing.