Hi,
I built an application where some numbers are formatted using the ($) currency and other cell numbers use (€) symbol. The cells of spreadsheet are saved to the db using the standard interface php (and table structures).
I used the custom formatting feature of tabbar of spreadsheet with the pattern: 0.00 € for the cells with euro currency
When I save the popup formatting form, the cell is formatted fine with the right pattern but if I reload the formatting is not preserved.
Am I missing something ? If I choose other formatting patterns, reloading the page, the format is preserved.
Thanks
Hello,
We tested the issue and everything works correctly on our side.
{
"styles": [
[
"wss1",
";;;;;;;;;;;fmt0;;;;"
]
],
"data": [
[
1,
1,
"10",
"wss1"
]
],
"formats": [
[
"fmt0",
"0.00 €"
]
]
}
Please, try to use serialize method before reloading the page and after it to check the data from server-side
it seems that the table “formats” is not included in the tables of the server example in php.
I will try to implement !!
Massimo