Issue 113883 - Range Names Inconsistent in sheet and VBA macros
Summary: Range Names Inconsistent in sheet and VBA macros
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: App Dev
Classification: Unclassified
Component: vba (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: PC Linux, all
: P3 Trivial
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-08-14 08:26 UTC by aseth1606
Modified: 2021-08-10 17:34 UTC (History)
2 users (show)

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

Attachments
See ODS sample with VBA macro included (14.14 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-07-30 15:10 UTC, oooforum (fr) 		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 aseth1606 2010-08-14 08:26:26 UTC 
I am trying to make an Excel sheet from
https://incometaxindiaefiling.gov.in/portal/downloads10-11/itr/ITR1_2010_11_R18.zip
run on OpenOffice.

Macros are failing as they are using a range name e.g. sheet1.FirstName.
However, on the sheet, the cell is named sheet1.FirstName_2. (Sheet name "Income
Details" and cell number C6) 

This could be because the cell sheet1.FirstName is actually on the second sheet.
Same pattern is visible for many fields.

I am trying this on OOo-dev 3.3.0 OOO330m2 (Build:9516)

Thanks & regards
Anil
Comment 1 oooforum (fr) 2021-07-30 15:10:09 UTC 
Created attachment 87047 [details]
See ODS sample with VBA macro included

Not reproduce with AOO 4.1.10
Macro displays the named range "MaDate" with VBA syntax
Comment 2 oooforum (fr) 2021-07-30 15:11:04 UTC 
Your link is not available. Please update and try again.