SaveToFile PDF format

Tue Jul 14, 2020 9:40 am

: Sample Screen shot of how it is displayed; Snip.png (26.47 KiB) Viewed 1053 times

I have a work book that calculations are done in hidden sheets and are displayed on visible sheets, when i convert the workbook to pdf cell that contain calculated values from hidden sheets are displayed as #N/A, this means that it can't see calculated values from hidden sheets during conversion to pdf is there anyway i can resolve this?

string savedPath = HttpContext.Current.Server.MapPath(Path.Combine("~/ExcelPreview", pdfFile));
EventLogger.writeErrorLog("Excel saved successfully to " + savedPath);
workbook.SaveToFile(savedPath);

Tue Jul 14, 2020 10:02 am

Hello,

Thanks for your inquiry.
To help us investigate your issue more accurately, please provide us with your input file and your full testing code. You could attache them here or send them to us(support@e-iceblue.com) via email. Thanks in advance for your assistance.

Sincerely,
Rachel
E-iceblue support team

Wed Jul 15, 2020 2:09 am

Hi Gloria,

Thanks for providing your files via email.
I tested your case and indeed noticed the issue your mentioned. This issue has been passed to our Dev team with the ticket SPIREXLS-2535 for further investigation. If there is any update, we will inform you.
Sorry for the inconvenience caused.

Sincerely,
Rachel
E-iceblue support team

Wed Jul 15, 2020 8:27 am

rachel.lei wrote:Hi Gloria,

Thanks for providing your files via email.
I tested your case and indeed noticed the issue your mentioned. This issue has been passed to our Dev team with the ticket SPIREXLS-2535 for further investigation. If there is any update, we will inform you.
Sorry for the inconvenience caused.

Sincerely,
Rachel
E-iceblue support team

Thank you Rachel, Hope to hear from you soon

Wed Jul 15, 2020 9:28 am

Hi Gloria,

You are welcome.
Once there is any progress, we will inform you ASAP. Have a nice day!

Sincerely,
Rachel
E-iceblue support team

Wed Jul 22, 2020 6:15 am

Hi Gloria,

I’m writing to give you an update.
I just got news from our Dev team that your issue has been resolved! The fix will be included in the next version of Spire.XLS.
Once the new version is available, we will inform you ASAP. Thanks for your patience.

Sincerely,
Rachel
E-iceblue support team

Tue Aug 11, 2020 10:02 am

Hi Gloria,

Thanks for your patient waiting.
Glad to tell you we just released Spire.XLS Pack(Hotfix) Version:10.8.3 which fixes your issue. Welcome to download the hotfix from the following links.
Our website: https://www.e-iceblue.com/Download/down ... t-now.html
Nuget: https://www.nuget.org/packages/Spire.XLS/10.8.3

Sincerely,
Rachel
E-iceblue support team