TM1WEB/EXCEL formatting ignored if DBRW...

[Ulix]

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...

[lotsaram]

Does your date format have to be "dd.mm.yyyy"? Not all number and date formats are supported in TM1 Web.

Why not use "dd/mm/yyyy" instead which definitely is supported?