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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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
Reply to author
Sign in to reply to author
Forward
Sign in to forward
Delete
You do not have permission to delete messages in this group
Copy link
Report message
Show original message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
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.