Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Tue Oct 03, 2017 3:34 pm

Hello

I read data from excel and feed it to a system that supports culture info.
I'm wondering how Spire.XLS shows numbers in "displayedtext" property? Is cultural info saved in xlsx file and numbers shown based on that info? or maybe spire shows numbers in format of system culture? Or, maybe always in en-US?

Thnaks

ahmadi_rad@yahoo.com
 
Posts: 43
Joined: Thu Apr 13, 2017 3:53 pm

Wed Oct 04, 2017 3:37 am

Hello Alireza Ahmadi,

Thanks for your inquiry.
Kindy note that if there's any number format settings for certain a cell in the workbook, the property "DisplayedText" will return a value according to the setting, otherwise it will return a value based on your local cultrue.
You could use the code
Code: Select all
CellRange.NumberFormat
to set the number format in orde to mentain the value.

Sincerely,
Jane
E-iceblue support team
User avatar

Jane.Bai
 
Posts: 1156
Joined: Tue Nov 29, 2016 1:47 am

Wed Oct 04, 2017 7:29 am

So, spire will always use '.' for decimal separator? Is this '.' hard coded in spire or is it coming from regional settings of windows?

ahmadi_rad@yahoo.com
 
Posts: 43
Joined: Thu Apr 13, 2017 3:53 pm

Wed Oct 04, 2017 7:33 am

Hi,

Thanks for your response.
The decimal separator is totally based on the regional settings of your system.

Sincerely,
Jane
E-iceblue support team
User avatar

Jane.Bai
 
Posts: 1156
Joined: Tue Nov 29, 2016 1:47 am

Mon Oct 09, 2017 10:02 am

Hello,

Greetings from E-iceblue.
Did we resolve your issue?
Thanks in advance for your valuable feedback and time.

Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Mon Oct 09, 2017 10:02 am

Hello,

Greetings from E-iceblue.
Did we resolve your issue?
Thanks in advance for your valuable feedback and time.

Sincerely,
Gary
E-iceblue support team
User avatar

Gary.zhang
 
Posts: 1380
Joined: Thu Apr 04, 2013 1:30 am

Mon Oct 09, 2017 2:03 pm

Hello

Thanks for follow up. Yest it resolved my issue. I wanted to make sure from where the '.' sign comes and I got my answer accurately

Thanks again for good job

ahmadi_rad@yahoo.com
 
Posts: 43
Joined: Thu Apr 13, 2017 3:53 pm

Tue Oct 10, 2017 1:23 am

Hi,

Thanks for the feedback.
Please feel free to contact us if you need any assistance.

Sincerely,
Jane
E-iceblue support team
User avatar

Jane.Bai
 
Posts: 1156
Joined: Tue Nov 29, 2016 1:47 am

Return to Spire.XLS