Spire.Xls can't convert excel file to jpg properly help plz

[spadsystem]

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 ?????

[sweety1]

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

[spadsystem]

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

[spadsystem]

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

[sweety1]

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

[spadsystem]

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

[sweety1]

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