Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Operator mismatch
Message
From
29/05/2010 12:29:34
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
 
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01465616
Message ID:
01466502
Views:
29
>Tamas,
>
>What I suggested should have worked regardless of the type of the cell. In other words,
transform(value) <="3.2"
But that's semantically wrong. What if value contained 1000?
"1000"<"3.2"
is still true as string comparison.

I'd go with
if val(.cell(...).text)<=3.2
I think Tamás is getting errors because in some rows .value is a number, in some rows it's a string, depending on what artificial stupidity of Excel may conclude.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Reply
Map
View

Click here to load this message in the networking platform