Issue 68898 - VBA: support '[a1:b2]' range short cut
Summary: VBA: support '[a1:b2]' range short cut
Status: CLOSED FIXED
Alias: None
Product: General
Classification: Code
Component: scripting (show other issues)
Version: 680m180
Hardware: All All
: P3 Trivial (vote)
Target Milestone: OOo 2.4
Assignee: sled10guy
QA Contact: issues@framework
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-08-23 16:08 UTC by noel.power
Modified: 2009-07-20 15:18 UTC (History)
2 users (show)

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

Attachments
patch (2.50 KB, patch)
2006-08-23 16:09 UTC, noel.power 		no flags Details | Diff
patch for vbaoption use in parser and sub classes (3.23 KB, application/msword)
2006-08-23 16:10 UTC, noel.power 		no flags Details
simple testcase (21.50 KB, application/vnd.ms-excel)
2007-05-01 18:21 UTC, noel.power 		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 noel.power 2006-08-23 16:08:18 UTC 
This is a hack to the basic runtime that allow syntax like

msgbox [a1:b2].Address

[A1:b2] is a way of specifying a short-cut reference ( it also does other
evaluations but we don't cover those yet )
Comment 1 noel.power 2006-08-23 16:09:24 UTC 
Created attachment 38731 [details]
patch
Comment 2 noel.power 2006-08-23 16:10:58 UTC 
Created attachment 38732 [details]
patch for vbaoption use in parser and sub classes
Comment 3 noel.power 2006-08-23 16:12:33 UTC 
ok there are 2 patches here, the first one is to implement the functionality,
the second is to correct an error in the way that vbasupport option is detected
in the parser ( and codegen etc ) its needed for the first patch to work.
Comment 4 noel.power 2006-09-01 17:11:03 UTC 
.
Comment 5 Mathias_Bauer 2006-12-05 17:06:00 UTC 
Noel, you shouldn't assign patches to yourself. This spoils our initial response
time statistics. :-)
Comment 6 noel.power 2006-12-06 10:08:57 UTC 
mm it seems I still had this assigned to me ;-)
Comment 7 ab 2006-12-13 15:39:10 UTC 
STARTED, OOo 2.2
Comment 8 ab 2007-01-02 12:22:19 UTC 
ab->npower: Back to you to assign it to the next npower cws.
Comment 9 pavel 2007-01-24 11:34:22 UTC 
move target.
Comment 10 Mathias_Bauer 2007-04-10 11:12:22 UTC 
Noel, will you integrate this patch or should we close the issue?
Comment 11 noel.power 2007-04-23 14:35:43 UTC 
I will integrate this ( but of course there are other patches that are more
important that need to go in first ), putting to 2.x for the moment as it is not
an immediate priority
Comment 12 noel.power 2007-05-01 18:19:52 UTC 
add to npower7, update milestone
Comment 13 noel.power 2007-05-01 18:21:14 UTC 
Created attachment 44783 [details]
simple testcase
Comment 14 noel.power 2007-05-05 13:11:30 UTC 
fixed
Comment 15 noel.power 2007-07-11 12:47:20 UTC 
for qa
Comment 16 noel.power 2007-08-07 10:10:34 UTC 
change target
Comment 17 sled10guy 2007-08-28 16:17:44 UTC 
Ran test documents (eval-shortcutrangeref.xls) on released SLED10 SP1 OOo
2.1.14, Windows OOo 2.1 (Build 2007-06-04) and cws-npower7-m217 and Microsoft
Office 2007. Below are the results returned in the msgbox after pressing the
"click me" button:
• passed, very basic short cut range references work!
‣ RESULT: Test Passed.
Comment 18 thorsten.ziehm 2009-07-20 15:18:05 UTC 
This issue is closed automatically and wasn't rechecked in a current version of
OOo. The fixed issue should be integrated in OOo since more than half a year. If
you think this issue isn't fixed in a current version (OOo 3.1), please reopen
it and change the field 'Target Milestone' accordingly.

If you want to download a current version of OOo =>
http://download.openoffice.org/index.html
If you want to know more about the handling of fixed/verified issues =>
http://wiki.services.openoffice.org/wiki/Handle_fixed_verified_issues