Reply to topic  [ 3 posts ] 
Value in Numeric Issue 
Author Message

Joined: Wed May 24, 2023 1:00 am
Posts: 6
Reply with quote
Post Value in Numeric Issue
I have Following Query for EasyXLS for VB 6

I have a Value in Numeric which is already in formatted format.

for Eg.
"123.00"
"12,345.00"
"1,234,56789.00"

If I am using format as "numeric" then it gives the Error while opening the Excel

If I am using format as "automatic" then it does not gives the Error but it does not Show it Properly and it is Left alignment and it is String Format.

I want the same to be Numeric Format in Excel.

I am attaching the VB6 Source Code and Excel Files

Can You Help me to correct the above Code or give the Sample code to do AutoFit of the all the column ?

Thanking You,

Bhavesh


Attachments:
File comment: "numeric" format Issue - 2
Numeric2.jpg
Numeric2.jpg [ 33.46 KiB | Viewed 72534 times ]
File comment: "numeric" format Issue - 1
Numeric.jpg
Numeric.jpg [ 23.92 KiB | Viewed 72534 times ]
Numeric Issue.zip [12.73 KiB]
Downloaded 9305 times
Wed Sep 06, 2023 2:43 pm
Profile

Joined: Wed May 24, 2023 1:00 am
Posts: 6
Reply with quote
Post Re: Value in Numeric Issue
Error in "automatic" format Issue


Attachments:
File comment: "automatic" format Issue
Automatic.jpg
Automatic.jpg [ 37.95 KiB | Viewed 72533 times ]
Wed Sep 06, 2023 2:44 pm
Profile

Joined: Fri Feb 03, 2006 12:23 pm
Posts: 199
Location: Brasov, Romania
Reply with quote
Post Re: Value in Numeric Issue
The numbers must be entered with no additional formatting like 1,000.00, 1.000,00 or $1000.
Also 1,234,56789.00 is not a number.

_________________
EasyXLS Team
.NET and Java library to read and write Excel files
Facebook X Reddit LinkedIn


Wed Sep 13, 2023 7:26 am
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 3 posts ] 

Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.