I am evaluating Aspose Cells.Java and especially the smartmarkers feature.
What I found is that it seems that aspose completely ignores the actual data types of the Java objects that I use as the data source. Everything comes out as “text” cell type in Excel.
Why is that?
When the Java type is any numeric type (int, double, BigDecimal, …) I would expect Aspose to set the cell to numeric.
More pressing for me: When the Java type is a date type (Date, LocalDate, …) I would expect the Excel cell to also actually contain a date.
Here is an example result for some common data types:
bild.png (2.9 KB)
Why doesn’t Aspose just use the type information from the data source?
Is there any way I can use the smartmarker feature to insert an actual date in excel?