Skip to content
This repository has been archived by the owner on Mar 9, 2020. It is now read-only.

Issue when Accessing Text propertie of a Cell that uses format number 40 #55

Closed
Tarboeuf opened this issue Nov 14, 2017 · 1 comment
Closed

Comments

@Tarboeuf
Copy link

When you try to access to the Text properties of the cell A1 (in MonoCell.xlsx), there is an exception.

It seems to be caused by this code into the ExcelNumberFormatXml class.

        internal static void AddBuildIn(XmlNamespaceManager NameSpaceManager, ExcelStyleCollection<ExcelNumberFormatXml> NumberFormats)
        {
...
            NumberFormats.Add("#,##0.00;(#,##0.00)", new ExcelNumberFormatXml(NameSpaceManager, true) { NumFmtId = 39, Format = "#,##0.00;(#,##0.00)" });
            NumberFormats.Add("#,##0.00;[Red](#,##0.00)", new ExcelNumberFormatXml(NameSpaceManager, true) { NumFmtId = 40, Format = "#,##0.00;[Red](#,#)" });

...
            NumberFormats.NextId = 164; //Start for custom formats.
        }

Strings of the format 40 has to be equal, like for the format 39.

Regards and thanks for your job,

Pierre Epinat

JanKallman added a commit that referenced this issue Nov 26, 2017
@JanKallman
Copy link
Owner

Fixed in 4.5.1

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants