Decimal being created
C++ library for creating XLSX files for MS Excel 2007 and above.
Brought to you by:
oxod,
programmeralex
Hi
By going to >> Fomat Cells >> set Decimal places to 0 and tick commas
Then using this formula in a cell with data we get decimals
=A1(1+Sheet2!A1:A1)
or
=A1(1+38.90%)
add any number to A1 cell(our example for attachment below is 17,862)
In excell we see 24,810 for our formula answer, in webpage we see 24810.318 << plus no commas
Is it meant to do this, or its a limitation? As the excell page has no decimals. Only seems to do it to formulas
Test file below
Plus im just using XLSX to html table example
Last edit: Brian 2020-02-01
Hi,
Perhaps you made a mistake with the project site? The C++ library SimpleXlsxWriter is discussed here :-)