|
Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
| Summary: | [From Symphony]Fix some issues about API: Range | ||
|---|---|---|---|
| Product: | App Dev | Reporter: | lihuiibm <lihuibj> |
| Component: | vba | Assignee: | AOO issues mailing list <issues> |
| Status: | CONFIRMED --- | QA Contact: | |
| Severity: | Trivial | ||
| Priority: | P3 | CC: | issues |
| Version: | 3.3.0 or older (OOo) | ||
| Target Milestone: | --- | ||
| Hardware: | All | ||
| OS: | All | ||
| Issue Type: | DEFECT | Latest Confirmation in: | --- |
| Developer Difficulty: | --- | ||
| Attachments: | |||
Created attachment 65725 [details]
Patch of module "sc" for this issue
Created attachment 65726 [details]
Patch of module "oovbaapi" for this issue
Created attachment 65727 [details]
Test case sample for this patch.(Range.SpecialCells(xlLastCell))
Created attachment 65728 [details]
Test case sample for this patch: Range.SpecialCells(xlCellTypeLastCell)
Created attachment 65729 [details]
Test case sample for this patch: Range.FormulaArray
need some time to look at this Range.SpecialCells changes look ok :-) Range.FormulaLocal not familiar with this api but... you've got a test, the change wont break anything, I'm happy Range.FormulaArray seems reasonable but... there seems to be extra things in the patch a) vbanames.cxx probably this is something that needs a seperate issue, testcase, description etc. b) vbaworksheet.cxx the change here to the return value seems to do... nothing, was there some problem here I am not aware of? |
Following issues: Issue 1. Range.SpecialCells(xlCellTypeLastCell) Steps: 1.1 Run the sample(Range_SpecialCells(xlCellTypeLastCell).xls) file in attachments with OOo. 1.2 See the log under <User Home> Defect: Range.SpecialCells(xlCellTypeLastCell) could not return the last activate value. 2. Range.SpecialCells(xlLastCell) Steps: 2.1 Run the sample(Range.SpecialCells(xlLastCell).xls) file in attachment with OOo. Issue: Script code "range1.SpecialCells(xlLastCell).value" will lead to crash 3. Add new API Range.FormulaLocal 4. Range.FormularArray 4.1 Run the sample(Range_TST-A5FA7B.xls) file in attachments with OOo. 4.2 See the log under <User Home> For the problem of getting value from Range.FormularArray, it is because that the OOo core function returns a string with a couple of bracket ("{}") at the outside. So we must remove the bracket "{}"