OpenOffice always returns a decimal number even when ODT cell is formatted to no decimal places

11 views
Skip to first unread message

SuperKevy

unread,
May 8, 2008, 5:17:04 PM5/8/08
to ruby-roo
I don't know if this a big issue or should be considered as an
enhancement.

Assume i have cell B1..B10 as the whole numbers 1..10 (entered with
no decimal place and the cell formated to no decimal places ie. type
general)
When I return the values to ruby calling definition it will always
return the value as 1.0....10.0 (ie. float)
It would be nice if the return value would be an integer unless I
actually had a float type in the cell

Cest le vie & regards

Thomas Preymesser

unread,
May 8, 2008, 9:05:54 PM5/8/08
to ruby-roo
Internally in the excel- and openoffice-files there is no difference
between integers and floats. There is only the type 'numeric'. So i
can not tell, if there was entered an integer or a float. The numeric
value of such a cell the same.

-Thomas

Reply all
Reply to author
Forward
0 new messages