Issue 107501

Summary:	Indirect and Address functions with space in label sheet
Product:	Calc	Reporter:	jeffooo <jeffooo>
Component:	programming	Assignee:	kla <thomas.klarhoefer>
Status:	CLOSED FIXED	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues, jbf.faure, maison.godard, thomas.klarhoefer
Version:	OOO320m7	Keywords:	regression
Target Milestone:	---
Hardware:	All
OS:	All
Issue Type:	DEFECT	Latest Confirmation in:	---
Developer Difficulty:	---
Issue Depends on:
Issue Blocks:	99999

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.