Dear Santosh, This happens when user exports Pentaho report to excel, during export some cells are merged automatically during export and i think whether or not the columns are defined, it will not change what happens during the exporting process.
During report design (pentaho / crystal reports or any other reporting tool) one might place different data formats on top of others so excel uses its own "brain" to interpret the rows using the first rows on top of a report So for Pentaho users will always be challenged with this. I personally think it an issue of pentaho rather than data formats of the report template itself My Kind Regards Francis Guchie Kirago On Wed, Oct 23, 2019 at 10:06 AM Santosh Math < sant...@confluxtechnologies.com> wrote: > Hi Paul, > Please define number format for each column. It looks like date format is > taken for all columns. > > On Wed, Oct 23, 2019 at 6:05 AM Paul Mugoh via Mifos-users < > mifos-users@lists.sourceforge.net> wrote: > >> Hello, >> Every time I include a dates column in my Pentaho report designer, all >> numerical data changes to dates when I export the report to Excel. I have >> attached a screenshot of such a report. How do I resolve that? >> Thanks. >> Paul. >> _______________________________________________ >> Mifos-users mailing list >> Mifos-users@lists.sourceforge.net >> https://lists.sourceforge.net/lists/listinfo/mifos-users >> > > > -- > Thanks & Regards > > Santosh Math > > *QA Engineer* > > *Conflux Technologies Pvt Ltd <http://www.confluxtechnologies.com/>* > | *Office*: +91-080-41208662 | > > *Address*: #304, 2nd Floor, 7th Main Road, HRBR Layout 1st Block, > Bengaluru, Karnataka, 560043 INDIA > _______________________________________________ > Mifos-users mailing list > Mifos-users@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/mifos-users >
_______________________________________________ Mifos-users mailing list Mifos-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/mifos-users
