<html> <head> <meta http-equiv="Content-Type" content="text/html; charset=koi8-r"> <style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style> </head> <body dir="ltr"> <div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"> Hi Vikas,</div> <div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"> <br> </div> <div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"> 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.</div> <div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"> <br> </div> <div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"> Possibly it's better to refer to specific issue # or gerrit patch related to those transformations to allow some better suggestions?</div> <div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"> <br> </div> <div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"> -- </div> <div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"> Best regards,</div> <div style="font-family: Calibri, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);"> Mike Kaganski</div> <hr style="display:inline-block;width:98%" tabindex="-1"> <div id="divRplyFwdMsg" dir="ltr"><font face="Calibri, sans-serif" style="font-size:11pt" color="#000000"><b>От:</b> LibreOffice <libreoffice-bounces@lists.freedesktop.org> от имени Vikas Mahato <vikasmahato0@gmail.com><br> <b>Отправлено:</b> 25 июля 2018 г. 14:45<br> <b>Кому:</b> libreoffice@lists.freedesktop.org<br> <b>Тема:</b> Calc cell type</font> <div> </div> </div> <meta content="text/html; charset=utf-8"> <div> <div dir="auto">Hello all, <div dir="auto"><br> </div> <div dir="auto">I am trying to write some datatransformations related to date-time for calc.</div> <div dir="auto"><br> </div> <div dir="auto">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.</div> <div dir="auto"><br> </div> <div dir="auto">Regards,</div> <div dir="auto">Vikas Mahato</div> </div> </div> </body> </html>