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.

Sun Oct 22, 2017 10:38 am

Hey
When I load a *.xlsx file , the cell has a date will be converted to a unknown number. 17:45 -> 0.71875
Is there a bug?
mfg GH

GHWels
 
Posts: 90
Joined: Sun Nov 23, 2014 7:22 pm

Mon Oct 23, 2017 3:57 am

Hi GHWels,

Thanks for your inquiry.
Could you please provide us with the input and output documents for further investigation ?

Thanks,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Mon Oct 23, 2017 7:51 am

Hi Betsy
Dim Wbook As Workbook = Nothing
Wbook = New Spire.Xls.Workbook
Wbook.LoadFromFile("Test-1.xlsx")
Wbook.SaveToFile("Test-1.pdf", Spire.Xls.FileFormat.PDF)
Wbook.Dispose()

thank you GH
Attachments
TestData.zip
Test-1.xlsx and Test-1.pdf
(20.37 KiB) Downloaded 238 times

GHWels
 
Posts: 90
Joined: Sun Nov 23, 2014 7:22 pm

Mon Oct 23, 2017 8:12 am

Hi GH,

Thanks for your files.
I have tested the input file with Spire.Office Platinum (DLL Only) Version:2.16.18, it worked fine on my side, please check the result on attachment. So please try to use this version. If the issue still happens, please tell us the OS and the Region/Language information, e.g. Win7 64bit, China/Chinese.

Many thanks,
Betsy
E-iceblue support team
Attachments
11934.zip
(43.48 KiB) Downloaded 225 times
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Mon Oct 23, 2017 8:36 am

Hi Betsy,

I use Version 2.16.18, windows 10, 64bit, German

GH
Attachments
TestData.zip
new files
(164.86 KiB) Downloaded 256 times

GHWels
 
Posts: 90
Joined: Sun Nov 23, 2014 7:22 pm

Mon Oct 23, 2017 10:23 am

Hi GH,

Thanks for your information.
Unfortunately, we still cannot reproduce the issue on my side. And we guess the issue might be caused by the culture, first we suggest you use following code to set the culture to check if the issue is solved.
Code: Select all
Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture;
Workbook workbook = new Workbook();
......

If the issue still happens, please provide us with the screenshot of the Region and the format setting in control panel.

Many thanks,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Mon Oct 23, 2017 2:29 pm

Hi Betsy,
That you, that solved my problem.
mfg GH

GHWels
 
Posts: 90
Joined: Sun Nov 23, 2014 7:22 pm

Tue Oct 24, 2017 1:41 am

Hi GH,

Thanks for your feedback.
Any question, please feel free to contact us.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.XLS