Modify

Opened 13 years ago

Closed 13 years ago

Last modified 13 years ago

#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 by BrewManNH, 13 years ago

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.

comment:2 by guinness, 13 years ago

Resolution: Wont Fix
Status: newclosed

in reply to:  1 comment:3 by slash.cyberpunk@…, 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 guinness, 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.

Modify Ticket

Action
as closed The ticket will remain with no owner.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.