Apache OpenOffice (AOO) Bugzilla – Issue 82165
Defect in selection list with time
Last modified: 2013-08-07 15:14:13 UTC
In Calc 2.3 there is a defect in Selection list. If I choose a range of cells with time values than in selection list I can see only decimal numbers and not time. Example: Put in cells A1 7:00; A2 7:30; A3 8:00. For the cell B1 create the selection list, in validity window choose Range of cells and source A1:A3. In Calc 2.2 it worked fine.
Created attachment 48640 [details] Example
Hi Niklas, one for you I think. Frank
This was known and mentioned as a limitation in issue 56566 (dynamic ranges). Not sure if there is a quick fix or if we have to accept it for now.
Duplicate. *** This issue has been marked as a duplicate of 80318 ***
Closing dup.