[Libreoffice-bugs] [Bug 65106] Reference to an empty date cell gives 1899-12-30

2013-11-21 Thread bugzilla-daemon 
https://bugs.freedesktop.org/show_bug.cgi?id=65106

Michael Stahl mst...@redhat.com changed:

   What|Removed |Added

  Attachment #79930|text/plain  |application/vnd.oasis.opend
  mime type||ocument.spreadsheet

-- 
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

[Libreoffice-bugs] [Bug 65106] Reference to an empty date cell gives 1899-12-30

2013-05-30 Thread bugzilla-daemon 
https://bugs.freedesktop.org/show_bug.cgi?id=65106

--- Comment #2 from Thomas Arnhold tho...@arnhold.org ---
Thanks mariosv. Didn't see this.

-- 
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

[Libreoffice-bugs] [Bug 65106] Reference to an empty date cell gives 1899-12-30

2013-05-29 Thread bugzilla-daemon 
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