mercredi 10 août 2016

Data ss:Type="Currency"

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