ExcelNumberFormat
ExcelNumberFormat copied to clipboard
andersnm
Parse and render Excel number format strings
Hi i'm using ClosedXML in one of my projects and replaced only this library and got this exception Method not found 'System.String ExcelNumberFormat.NumberFormat.Format(System.Object, System.Globalization.CultureInfo)' StackTrace: at ClosedXML.Extensions.FormatExtensions.ToExcelFormat(Object o, String format)...
Upgrading from 1.0.10 to 1.1.0 caused ClosedXML / DocumentFormat.OpenXml to have unacceptable performance (10+ times longer runtime) and incorrect results when using _Worksheet.Columns().AdjustToContents();
Fixing issue when an excel cell is formatted as "Fraction" and the value is greater than int.MaxValue (2,147,483,647). Prior to this fix, a value greater than int.MaxValue throws the error...
Hi @andersnm, Thank you for this work, really helpful! We noticed that the Library was to able to parse ¥ and £ in NumberFormats (but € works for example). We...
Hi @andersnm, This is probably out of scope for the library, but given that you are likely knowledgeable on the subject I thought I'd ask. I have an app which...
Suggest a new `NumberFormat.Round()` method to return numeric inputs as numbers still, but with number formatting rules applied - i.e round to number of decimals, percent multiply, thousands division. F.ex...
Specifically: global color and alignment, variable width space, repeat-to-fill characters The basic goal is to return something allowing the caller to render the formatted value more precisely with an arbitrary...
From what I understand, this feature might not be properly supported, as shown in #36, but I'll post anyway to raise awareness. This may be a potential issue for users...
Formatting numbers only works with double, int and short. Other numeric types should be supported, such as byte, sbyte, ushort, uint, long, ulong, float, decimal. ```csharp var format = new...
Hi Thanks for providing this library, which in addition to ExcelDataReader is brilliant for lightweight reading of Excel spreadsheets. I think I've found an issue with the number formats mm:ss.0...
