Modify ↓

Opened on Aug 8, 2014 at 2:32:40 AM

Closed on Oct 13, 2014 at 4:45:50 PM

Last modified on Oct 14, 2014 at 2:32:06 PM

#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 by J-Paul Mesnage, on Sep 2, 2014 at 4:55:22 PM

Please follows Ticket writing guidline
repro script at the minimum
Thanks

Version 1, edited on Sep 2, 2014 at 4:55:51 PM by J-Paul Mesnage (previous) (next) (diff)

comment:2 by water, on Sep 28, 2014 at 11:39:19 AM

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

comment:3 by J-Paul Mesnage, on Oct 13, 2014 at 4:45:50 PM

Resolution: → Rejected
Status: new → closed

As no info has been given, we close it

comment:4 by water, on Oct 14, 2014 at 2:32:06 PM

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.

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 .
Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.