Modify ↓

Opened 10 years ago

Closed 10 years ago

Last modified 10 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 10 years ago by Jpm

Please follows Ticket writing guidelines
repro script at the minimum
Thanks

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

comment:2 Changed 10 years ago by water

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

comment:3 Changed 10 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 10 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.

Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.