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.

Mon May 04, 2015 1:47 pm

I ask this question is stackoverflow as you can see here :

stackoverflow.com/questions/30011614/spire-xls-cant-convert-excel-file-to-jpg-properly

the spire.xls can not convert the cells of excel file that has a formula properly why ?????
Last edited by spadsystem on Tue May 05, 2015 4:41 am, edited 1 time in total.

spadsystem
 
Posts: 4
Joined: Wed Apr 29, 2015 7:30 am

Tue May 05, 2015 3:18 am

Hello,

Thanks for your inquiry.
We recommend you calculate the formula before generated image. You can refer to the code below:
Code: Select all
Workbook book = new Workbook();
            book.LoadFromFile("d:\\test.xlsx");
            Worksheet sheet = book.Worksheets[0];
            book.CalculateAllValue();
            sheet.SaveToImage("e:\\4940.jpg");

If you still have issue, please package your sample file into ZIP file format. Then, upload your zip file. It would be helpful to replicate the issue and work out the solution for you ASAP.

Sincerely,
Sweety

E-iceblue support team
User avatar

sweety1
 
Posts: 539
Joined: Wed Mar 11, 2015 1:14 am

Tue May 05, 2015 4:36 am

Thank you for your reply,but it doesn't work for me .I uploaded the xlsm file as you said.

the question :

stackoverflow.com/questions/30011614/spire-xls-cant-convert-excel-file-to-jpg-properly

best regards
Attachments
a.zip
(100.81 KiB) Downloaded 246 times

spadsystem
 
Posts: 4
Joined: Wed Apr 29, 2015 7:30 am

Tue May 05, 2015 4:58 am

sweety1 wrote:Hello,

Thanks for your inquiry.
We recommend you calculate the formula before generated image. You can refer to the code below:
Code: Select all
Workbook book = new Workbook();
            book.LoadFromFile("d:\\test.xlsx");
            Worksheet sheet = book.Worksheets[0];
            book.CalculateAllValue();
            sheet.SaveToImage("e:\\4940.jpg");

If you still have issue, please package your sample file into ZIP file format. Then, upload your zip file. It would be helpful to replicate the issue and work out the solution for you ASAP.

Sincerely,
Sweety

E-iceblue support team


Thank you for your reply,but it doesn't work for me .I uploaded the xlsm file as you said.

the question :

stackoverflow.com/questions/30011614/spire-xls-cant-convert-excel-file-to-jpg-properly
Attachments
a.zip
(100.81 KiB) Downloaded 351 times

spadsystem
 
Posts: 4
Joined: Wed Apr 29, 2015 7:30 am

Fri May 08, 2015 1:39 am

Hello,

Thanks for your information.
I have reproduced your issue. And I have posted the issue to our dev team. We will inform you when it is fixed. Sorry for the inconvenience.

Sincerely,
Sweety

E-iceblue support team
User avatar

sweety1
 
Posts: 539
Joined: Wed Mar 11, 2015 1:14 am

Sun May 10, 2015 6:46 am

sweety1 wrote:Hello,

Thanks for your information.
I have reproduced your issue. And I have posted the issue to our dev team. We will inform you when it is fixed. Sorry for the inconvenience.

Sincerely,
Sweety

E-iceblue support team



thank you very much ,but unfortunately i don't have any time ,and i should do the project asap.
best regards

spadsystem
 
Posts: 4
Joined: Wed Apr 29, 2015 7:30 am

Mon May 11, 2015 2:00 am

Hello,

Thanks for your reply.
Once the issue is resolved or there are any progress, we will let you know ASAP.

Sincerely,
Sweety

E-iceblue support team
User avatar

sweety1
 
Posts: 539
Joined: Wed Mar 11, 2015 1:14 am

Return to Spire.XLS