edit date cells doesn't work

GoogleCodeExporter commented 8 years ago

What steps will reproduce the problem?
1. set a date-value to cell by program
2. edit this cell
3.

What is the expected output? What do you see instead?
I would expect to have the date value and can edit it.
Instead I get a double value.
It doesn't matter if the date has a time or not.

What version of the product are you using? On what operating system?
2.0.1, windows xp

Please provide any additional information below.
german locale

Original issue reported on code.google.com by stephan....@apinso.com on 10 Mar 2011 at 9:05

GoogleCodeExporter commented 8 years ago

I cannot replicate this issue. Can you tell me which API did you call to set 
the date-value to cell in step 1?

In Excel, the date/time is also stored as a number. If you expect to show 
date/time in a cell, the format of that cell has to be set to date/time format.

As in Excel, if you type "Jan 1" to a cell, what was done behind the scene is 
that it first converts the date to a "number", store it, and then set the 
format of that cell to "d-mmm"(a date format).

Original comment by chenhe...@gmail.com on 22 Mar 2011 at 3:25

GoogleCodeExporter commented 8 years ago

http://tracker.zkoss.org/browse/ZSS-15

    ---------
The ZK Spreadsheet team has moved the issue tracker from here to our own new 
system at http://tracker.zkoss.org/secure/IssueNavigator.jspa. Please remember 
to adopt to the new system.

Users are able to log into the new system using their ZK forum account. If you 
do not already have one, please register at http://www.zkoss.org/forum/

Our new system on Jira introduces a new and very powerful voting system 
enabling users to vote up for a desired new feature or a bug that other users 
also have problem encountering.

Original comment by chenhe...@gmail.com on 15 Jul 2011 at 7:44

sexroute / zkspreadsheet

edit date cells doesn't work #299