B4J Question [Workaround][jPOI] Integers/decimal from cell

KMatle

Expert
Licensed User
Longtime User
I'm converting an Excel Sheet into a SQLite table. To create it, I need to know the column formats which I extract from the contents of the cells. Excel converts a decimal ending with .00 into an integer (except you format the cell to TEXT which isn't an option here).

Example:
1.JPG

Input is 28000,00. When you press enter, it is converted to 28000 (the 28000,00) comes from formatting the cells. The content is still 28000.

2.JPG


All other cells in that column contain "real" decimals (<> .00 at then end) which is ok. Only in that cell I get an INTEGER value instead a decimal (REAL).

Question: Is there an option to get the "display value" from a cell? (= the value the user sees in Excel including the formatting)?
 

KMatle

Expert
Licensed User
Longtime User
Upvote 0
Top