#2352 closed Bug (Wont Fix)
_ExcelWriteSheetFromArray incorrect start row and col array
Reported by: | slash.cyberpunk@… | Owned by: | |
---|---|---|---|
Milestone: | Component: | Standard UDFs | |
Version: | 3.3.9.6 | Severity: | None |
Keywords: | Cc: |
Description
In Excel.au3 in function _ExcelWriteSheetFromArray incorrect start row and col array by default. The default start line and column of the array starts at 0.
Before:
Func _ExcelWriteSheetFromArray($oExcel, ByRef $aArray, $iStartRow = 1, $iStartColumn = 1, $iRowBase = 1, $iColBase = 1)
After:
Func _ExcelWriteSheetFromArray($oExcel, ByRef $aArray, $iStartRow = 1, $iStartColumn = 1, $iRowBase = 0, $iColBase = 0)
Attachments (0)
Change History (4)
comment:1 follow-up: ↓ 3 Changed 11 years ago by BrewManNH
comment:2 Changed 11 years ago by guinness
- Resolution set to Wont Fix
- Status changed from new to closed
comment:3 in reply to: ↑ 1 Changed 11 years ago by slash.cyberpunk@…
Replying to BrewManNH:
That is the function's default setting, it has nothing to do with the array starting at 0 or not. The function appears to have been written to assume the array count is kept in $array[0][0] and the data in the array starts as 1.
Unfortunately, the data in the Excel workbook recorded starting from a position [0][0] in this function. In order to properly record the whole array of information, you need to specify all the parameters for the function with the start [0][0] or the easiest way to fix the function itself ...
Sorry for my bad English.
comment:4 Changed 11 years ago by guinness
I understand, but you can just change the parameters. I agree the Defaults should be 0, but it's not worth a script breaking change.
Guidelines for posting comments:
- You cannot re-open a ticket but you may still leave a comment if you have additional information to add.
- In-depth discussions should take place on the forum.
For more information see the full version of the ticket guidelines here.
That is the function's default setting, it has nothing to do with the array starting at 0 or not. The function appears to have been written to assume the array count is kept in $array[0][0] and the data in the array starts as 1.