Apache OpenOffice (AOO) Bugzilla – Issue 106412
[From Symphony]Fix some issues about API: Range
Last modified: 2013-02-24 20:56:49 UTC
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 "{}"
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?