Calc cell type

mikekaganski@xxxxxxxxxxx (Kaganski Mike) · Wed, 25 Jul 2018 05:10:17 +0000

Hi Vikas,

Dates and times are internally just numbers ("serial date/time"), which are formatted for display as dates or times. For pivot tables, there's IsDateDimension methods (in ScDPCache and others), which help in the pivot table specific case.

Possibly it's better to refer to specific issue # or gerrit patch related to those transformations to allow some better suggestions?

--
Best regards,
Mike Kaganski
________________________________
Ð?Ñ?: LibreOffice <libreoffice-bounces at lists.freedesktop.org> Ð¾Ñ? Ð¸Ð¼ÐµÐ½Ð¸ Vikas Mahato <vikasmahato0 at gmail.com>
Ð?Ñ?Ð¿Ñ?Ð°Ð²Ð»ÐµÐ½Ð¾: 25 Ð¸Ñ?Ð»Ñ? 2018 Ð³. 14:45
Ð?Ð¾Ð¼Ñ?: libreoffice at lists.freedesktop.org
Ð¢ÐµÐ¼Ð°: Calc cell type

Hello all,

I am trying to write some datatransformations related to date-time for calc.

Is there any way to determine whether a column stores date or time value? I was only able to find CELLTYPE_STRING, CELLTYPE_NONE, CELLTYPE_VALUE etc in global.hxx but none related to date or time.

Regards,
Vikas Mahato
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20180725/6a26374e/attachment.html>