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.

Wed Nov 30, 2016 8:36 am

Hi,
We have encountered an issue with loading excel files from streams.
In our workflow we use ClosedXML v0.73.0.0 to create xlsx documents, and then load them with Spire.XLS v7.8.0.7040
To reproduce the issue you can run the following code with the file in attachment.
Code: Select all
            Workbook workbook = new Workbook();
            workbook.LoadFromFile("spire.xlsx", ExcelVersion.Version2010);
            workbook.SaveToFile("broken.xlsx", ExcelVersion.Version2010);

See broken.xlsx in the attachment for the result we get.
Is there any solution to this?

Regards
Attachments
Archive.7z
(11.5 KiB) Downloaded 263 times

kosinov.daniil.g@gmail.com
 
Posts: 3
Joined: Mon Nov 21, 2016 2:26 pm

Wed Nov 30, 2016 8:55 am

Hi,

Thanks for your inquiry.
I have noticed the issue and posted it to our Dev team. We will inform you when it is fixed.
Sorry for inconvenience caused.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Wed Nov 30, 2016 2:51 pm

I believe this is related to the subject also.
LoadFromStream also messes up margins on pdf.
Code: Select all
            Workbook workbook = new Workbook();
            workbook.LoadFromFile(from, ExcelVersion.Version2010);
            workbook.SaveToFile(to, Spire.Xls.FileFormat.PDF);

See files in the attachment.

Both issues seem to appear only for ClosedXML generated xlsx files, if you change something inside manually, the issue is no longer reproducible.

Looking forward to a solution.
Attachments
pdf.7z
(50.55 KiB) Downloaded 268 times

kosinov.daniil.g@gmail.com
 
Posts: 3
Joined: Mon Nov 21, 2016 2:26 pm

Thu Dec 01, 2016 1:51 am

Hi,

Thanks for the information again.
I have noticed that new issue and posted it to our Dev team. We will inform you once there is any great progress.
Sorry for all inconvenience caused.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Wed Dec 07, 2016 9:16 am

Hi,

We are experiencing the same issue when loading file generated by ClosedXML. Also we see cell number format is broken as well.
When do you think this issue can be fixed?

Best regards,
Alex

siricyalex@gmail.com
 
Posts: 2
Joined: Wed Dec 07, 2016 8:58 am

Wed Dec 07, 2016 9:24 am

Dear Alex,

Thanks for your inquiry.
Sorry that the issue is not fixed, and our Dev team is still working on it.
Due to the sample file is different, maybe the reason caused your issue is different, so please provide us your file so that we can look into your issue quickly.

Thanks,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Wed Dec 07, 2016 10:05 am

Please see files attached.
Thanks for the contribution.

Best regards,
Alex
Attachments
Spire.7z
(8.57 KiB) Downloaded 266 times

siricyalex@gmail.com
 
Posts: 2
Joined: Wed Dec 07, 2016 8:58 am

Thu Dec 08, 2016 1:55 am

Dear Alex,

Thanks for sharing the documents.
I have reproduced the issue and posted it to our Dev team. Once it is fixed, we will inform you immediately.
Sorry for inconvenience caused.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Fri Jan 06, 2017 8:45 am

Dear Alex,

Thanks for your waiting.
Now the issue has been resolved, welcome to test Spire.XLS Pack Hotfix Version:7.11.34.
If there is any question, welcome to get it back to us.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Tue Jan 10, 2017 8:10 am

Hi,

Did you test the hotfix ? Has the issue been resolved ?
We will appreciate if you can give us some feedback.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Tue Jan 17, 2017 11:49 am

Hi, Betsy,

Sorry for the delayed response.
I am still able to reproduce the issue with margins on pdf.
Regards

kosinov.daniil.g@gmail.com
 
Posts: 3
Joined: Mon Nov 21, 2016 2:26 pm

Wed Jan 18, 2017 2:31 am

Hi,

Thanks for your feedback.
So sorry that the margin issue is not resolved, and I have posted it to our Dev team again.
We will inform you as soon as it is fixed. So sorry for inconvenience caused.

Sincerely,
Betsy
E-iceblue support team
User avatar

Betsy.jiang
 
Posts: 3099
Joined: Tue Sep 06, 2016 8:30 am

Return to Spire.XLS

cron