https://bugs.freedesktop.org/show_bug.cgi?id=65106

mariosv <mari...@miguelangel.mobi> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG
                 CC|                            |mari...@miguelangel.mobi

--- Comment #1 from mariosv <mari...@miguelangel.mobi> ---
I think could be good to look in the documentation for Calc:
http://www.libreoffice.org/get-help/documentation/
or in the program help to know about how dates are used in the spreadsheets.

Dates are kept as integer values in the cells, and zero as default for calc is
1899-12-30, this is set up in Menu/Tools/Options/LIbreOffice calc/calculate.
This is the reason to see this date on a cell formatted as date with zero as
value.

There are functions to know if a cell has some value or is empty as ISBLANK().
The cell format only use the cell value no interact with it.

I think this is not a bug, works as expected. If you are not agree please
reopen it.

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to