Modify

Opened 5 years ago

Closed 5 years ago

Last modified 5 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 follow-up: Changed 5 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 5 years ago by guinness

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

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

Modify Ticket

Action
as closed The ticket will remain with no owner.
Author


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

 
Note: See TracTickets for help on using tickets.