Modify

Opened 5 years ago

Closed 5 years ago

Last modified 5 years ago

#2829 closed Bug (Rejected)

_Excel_RangeRead unable to return Text values of excel cells

Reported by: anonymous Owned by:
Milestone: Component: AutoIt
Version: 3.3.12.0 Severity: None
Keywords: Cc:

Description

I have tried returning Value and Formula values using _Excel_RangeRead by setting $iReturn to 1 or 2 ( which works ) but if i set it to 3 to return Text value, the function has a problem reading $oWorkbook as an object.

Attachments (0)

Change History (4)

comment:1 Changed 5 years ago by Jpm

Please follows Ticket writing guidelines
repro script at the minimum
Thanks

Last edited 5 years ago by Jpm (previous) (diff)

comment:2 Changed 5 years ago by water

And please add an Excel workbook to reproduce the problem as well.

comment:3 Changed 5 years ago by Jpm

  • Resolution set to Rejected
  • Status changed from new to closed

As no info has been given, we close it

comment:4 Changed 5 years ago by water

Maybe I now understand what you mean.
Excel doesn't allow to return more than a single cell when using option 3 (return text).
_Excel_RangeRead has been changed to handle this error and correctly sets @error now.

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.