#2352 closed Bug (Wont Fix)
_ExcelWriteSheetFromArray incorrect start row and col array
| Reported by: | 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)
follow-up: 3 comment:1 by , 13 years ago
comment:2 by , 13 years ago
| Resolution: | → Wont Fix |
|---|---|
| Status: | new → closed |
comment:3 by , 13 years ago
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 by , 13 years ago
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.

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.