We need a way for writing excel file with Date only and Time only values which are displayed accordingly to user locale (it's a default format for date and time values inserted right in Excel). It is my understanding that currently (v3.7) we have the only option - provide exact number format to display time or date only. I attached example 'DateFormatExamples.xlsx' with locale specific formats for time and date.
Comment (1)