Issue 113885 - VBA Macro does not recognise Name attribute for getting range name
Summary: VBA Macro does not recognise Name attribute for getting range name
Status: CONFIRMED
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:46 UTC by aseth1606
Modified: 2013-02-24 20:56 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 aseth1606 2010-08-14 08:46:29 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.

Worksheet_Change macro gets called appropriately; however, it fails as the
following VBA code fails on:
Application.EnableEvents = False  # Error 423 EnableEvents 

If Target.Validation.Type = 3 Then # Error 423 Type

If InStr(1, Target.Name.Name, "'") > 0 Then ... # Error 423 Name

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

Thanks & regards
Anil
Comment 1 noel.power 2010-09-03 16:40:05 UTC 
>Application.EnableEvents = False
fixed recently
>Validation.Type
known ( no idea when it might be implemented )
>Range.Target
known ( and same, no idea when we might get to that )