Modify

Opened 12 years ago

Closed 12 years ago

Last modified 12 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)

Change History (4)

comment:1 follow-up: Changed 12 years ago by 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.

comment:2 Changed 12 years ago by guinness

  • Resolution set to Wont Fix
  • Status changed from new to closed

comment:3 in reply to: ↑ 1 Changed 12 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 12 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.

Add Comment

Author


E-mail address and user name can be saved in the Preferences.

 
Note: See TracTickets for help on using tickets.