[
https://issues.apache.org/jira/browse/METAMODEL-190?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14935078#comment-14935078
]
Kasper Sørensen commented on METAMODEL-190:
-------------------------------------------
Hi there,
Thanks for the bug report. I think you're right that this doesn't look very
nice.
I can explain the background: Excel doesn't really have column-wise data types,
so we had to fall back to some common type (we chose a String) when defining
the ColumnType in MetaModel. In order to return values that are consistent with
the ColumnType, we thus decided to convert all values to Strings. A bit
unfortunate sometimes, but at least consistent.
I think we would want to keep this consistent type-and-value relationship, but
maybe we could just use Double.toString(...) instead. That would at least
retain the precision of the number.
> Excel number formatting
> -----------------------
>
> Key: METAMODEL-190
> URL: https://issues.apache.org/jira/browse/METAMODEL-190
> Project: Apache MetaModel
> Issue Type: Wish
> Affects Versions: 4.4.0
> Environment: excel
> Reporter: Davide Consonni
>
> Extracting numeric value from an excel file trim decimal precision to 2.
> Example: real value -> 6.765 obtained value -> 6.76
> The problem seems to depend on the number formatting used at line 201 in
> org.apache.metamodel.excel.ExcelUtils
> There is a way to obtain the actual value in those cases ?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
