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 38975 times ]
File comment: "numeric" format Issue - 1
Numeric.jpg
Numeric.jpg [ 23.92 KiB | Viewed 38975 times ]
Numeric Issue.zip [12.73 KiB]
Downloaded 1993 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 38974 times ]
Wed Sep 06, 2023 2:44 pm
Profile

Joined: Fri Feb 03, 2006 12:23 pm
Posts: 190
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 Twitter 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:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware for PTF.