SaveToFile PDF format

[GloriaBusungu]

Sample Screen shot of how it is displayed

Snip.png (26.47 KiB) Viewed 1034 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);

[rachel.lei]

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

[rachel.lei]

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

[GloriaBusungu]

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

[rachel.lei]

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

[rachel.lei]

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

[rachel.lei]

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