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.

Fri Jun 24, 2016 9:50 am

Hello,

I am trying to convert an excel file to PDF, but when converting i keep recieveing an unhandled exception

"No Expression foundUnexpected token type: tEqual, string value: at position 1. Formula: =Data!A14 & " Edition", Position: 2"
This is from the formula used in cell M2 in the Report Tab from the attatched document.

but when saving the file, and converting the saved file, it works fine.

below is the code i am using to convert the file

var book = new Workbook();
book.LoadFromFile(reportPath);
book.Worksheets[0].PageSetup.PrintArea = null;
book.Worksheets[0].SaveToPdf(pdfPath);

Is there a setting that needs to be enabled for this?
Attachments
file.zip
(21 KiB) Downloaded 326 times

Tom360
 
Posts: 15
Joined: Tue Apr 12, 2016 8:21 am

Mon Jun 27, 2016 3:52 am

Hi,

Thanks for your posting.
I have replicated your issue and forwarded it to our dev team. Sorry for the inconvenience caused by the issue. We will inform you when it is fixed.

Best Regards,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Mon Jun 27, 2016 11:52 am

OK thank you. Could you provide me with an estimated time scale?

Thanks,

Tom360
 
Posts: 15
Joined: Tue Apr 12, 2016 8:21 am

Tue Jun 28, 2016 1:57 am

Hi Tom,

Sorry that we have not had an estimated time now as the issue is under investigating. We will inform you at once when it is fixed.

Best Regards,
Amy
E-iceblue support team
User avatar

amy.zhao
 
Posts: 2766
Joined: Wed Jun 27, 2012 8:50 am

Mon Aug 15, 2016 3:59 am

Hi Tom,

Thanks for your waiting.
Now the issue has get resolved and the hotfix is released, here is a link you can download the version and have a try:
spire.xls_7.10.46 hotfix
If there is any further question, welcome to get it back to us.

Best regards,
Lucy
E-iceblue support team
User avatar

Lucy
 
Posts: 30
Joined: Wed Aug 03, 2016 1:59 am

Mon Aug 15, 2016 12:42 pm

Hi,

Thanks for the update and hotfix. I have copied the files to the correct location in the BIN folder of my project, however the issue is still there. Am i missing out a step that is needed for this to work?

Thanks

Tom360
 
Posts: 15
Joined: Tue Apr 12, 2016 8:21 am

Tue Aug 16, 2016 2:12 am

Hi,

Thanks for your reply.
I tested the new version and it worked fine for your excel document.
Please follow the following solution to replace the dlls.
1. First remove the old dlls from References.
2 And then add the new dlls as references into your project.

Best regards,
Lucy
E-iceblue support team
User avatar

Lucy
 
Posts: 30
Joined: Wed Aug 03, 2016 1:59 am

Wed Aug 17, 2016 8:59 am

Hi,

How is your issue now? Is it resolved now? Could you please give us some feedback at your convenience. Thank you an advance.

Sincerely,
Lucy
E-iceblue support team
User avatar

Lucy
 
Posts: 30
Joined: Wed Aug 03, 2016 1:59 am

Fri Aug 24, 2018 2:52 pm

To apply the hotfix, i should use paid version right?
Otherwise it will show the warning...

klevi01
 
Posts: 2
Joined: Fri Aug 24, 2018 1:03 pm

Mon Aug 27, 2018 7:32 am

Hi Klevis,

Yes, you need to use our paid version. If you encounter any issues while using our paid version, please do not hesitate to contact us. We are always here to help.

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Return to Spire.XLS