Unplanned
Last Updated: 21 Jun 2023 10:56 by ADMIN
Fredrik Edström
Created on: 06 Jan 2023 14:42
Category: SpreadProcessing
Type: Feature Request
2
SpreadProcessing: Handle files with xf elements with out-of-range number format id
In the styles part of the xlsx file there is a cellXfs collection which contains xf elements. Each xf element has a numFmtId attribute which has to refer to an entry in the numFmts collection. Some libraries produce files with numFmtId's which are not valid but Excel handles such situations. SpreadProcessing throws KeyNotFoundException on import.
2 comments
ADMIN
Yoan
Posted on: 21 Jun 2023 10:56

Hello Chris,

Thank you for the provided feedback. Your effort towards improving and optimizing our services is much appreciated and essential for us.

If there is anything else you'd like to share, please feel free to do so.

Regards,
Yoan
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Chris
Posted on: 15 Jun 2023 20:22
FYI, I'm needing to pre-process Excel files to fix any number-formatting that is referencing a non-standard number-format ID. I'm using OpenXML to do this.