TM1WEB/EXCEL formatting ignored if DBRW...
Posted: Fri Sep 03, 2010 9:13 am
Hello All!
I can not deal here with a problem:
In Excel-file, there are cells with DBRW function that accesses the DATE-value in the format dd.mm.yyyy.
These cells made Excel-format DATE 'dd.mm.yyyy'. When checking in Excel and it works.
After the publication in TM1WEB in cells can not enter data in the format 'dd.mm.yyyy', because the cells are seen as numeric (Excel formatting is lost).
But! Somehow, a few times it appeared that the formatting preserved, but again failed...
Similar issue, but not my: https://www-304.ibm.com/support/entdocv ... wg1PK93165
Thanks...
I can not deal here with a problem:
In Excel-file, there are cells with DBRW function that accesses the DATE-value in the format dd.mm.yyyy.
These cells made Excel-format DATE 'dd.mm.yyyy'. When checking in Excel and it works.
After the publication in TM1WEB in cells can not enter data in the format 'dd.mm.yyyy', because the cells are seen as numeric (Excel formatting is lost).
But! Somehow, a few times it appeared that the formatting preserved, but again failed...
Similar issue, but not my: https://www-304.ibm.com/support/entdocv ... wg1PK93165
Thanks...