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-boun...@lists.freedesktop.org> от имени Vikas 
Mahato <vikasmaha...@gmail.com>
Отправлено: 25 июля 2018 г. 14:45
Кому: libreoffice@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
_______________________________________________
LibreOffice mailing list
LibreOffice@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice

Reply via email to