Skip to content

Export to excel raw values for numbers

Michael Prilop requested to merge export-to-excel-raw-values-for-numbers into main

In samarbeid Numbers are formatted with german locale. So a integer such as 100000 is formatted as 100.000. On Exporting to excel this caused an incorrect auto-format which cut off all (seemingly) insignificant zeros leading to the number 100 shown in Excel.

This only occurred as long as there was only one thousands seperator dot (cutting off insignificant zeros or interpreting it as decimal seperator).

This MR outputs Numbers ("Zahl ohne/mit Kommastellen") into ExcelExport as raw unformatted values and tries to hint the cell type to Excel.

Edited by Michael Prilop

Merge request reports