Custom number format disappears after cell update
I am using the Java Google Sheets API to change the value of a cell in a spreadsheet. Doing this way:
CellEntry cell = ...
cell.changeInputValueLocal(newInputValue);
cell.update();
My problem is that the cell has its own number format ( # ###0 "colli"
) and it disappeared after I programmed the cell. I want to write a number to cell (200). After this operation, the cell number format is set to "Automatic".
What am I doing wrong?
+3
source to share
No one has answered this question yet
Check out similar questions: