I have export to excel and the format is string. The following is value is:
1,456.98
Now the problem is, when using String
format, you cannot sum it. Here is my following code:
<Cell ss:StyleID="right_align_with_border">
<Data ss:Type="String"><%= number_to_currency(1456.981, unit: "", precision: 2) %></Data>
</Cell>
I used number:
<Data ss:Type="Number">
But the specs is to render with comma-separated in thousands plus with delimiter and can sum the cells.
Is their a Currency
type to use? Like:
<Data ss:Type="Currency">
Aucun commentaire:
Enregistrer un commentaire