Posted 8 September 2017, 2:34 pm EST
I have two Excel cells. The first Excel cell is formatted with leading negative sign, thus -123. The second Excel cell is formatted with parenthesis, thus (123).
I pasted these two Excel cells to two Spread NumberCellType cells.
When NegativeFormat of CellType is set equal to Parenthesis, the first cell lost its negative sign, while the second cell is pasted correctly.
When NegativeFormat of CellType is set equal to NegativeSignBefore, the first cell is pasted correctly, while the second cell lost its negative sign.
I want to get it working for both Excel formats. How can I do this?
What about a customer cell type? If so, can you please show me an example.