[Libreoffice-bugs] [Bug 120116] New: Format Cells adds ' character to the beginning of every date, and does NOT format cells to date data type

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=120116

            Bug ID: 120116
           Summary: Format Cells adds ' character to the beginning of
                    every date, and does NOT format cells to date data
                    type
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: cajhne at gmail.com

Created attachment 145166
  --> https://bugs.documentfoundation.org/attachment.cgi?id=145166&action=edit
simple csv file with dates to be sorted for testing this bug.

I found this bug while trying to sort by date mm/dd/yyyy

So to turn the date column into a date data type or sorting I do the following:

1. Highlight the column
2. right-click and choose "Format Cells"
3. I choose Category "Date" and the Format "31/12/1999"
4. Click OK

Expected behaviour: Calc should format the selected cells to the Date data
type, so it can be sorted by date ascending/descending

What happens instead: Calc just adds a ' to the beginning of every single date
cell before the date string.

This is... baffling behaviour. :)

It notably does NOT format the column data to a date.

To reproduce, open any csv containing date data (like the attached file), and
try the above steps.


This is ver 6.0.3.2
running on Ubuntu Linux 18.04

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180925/87b98bb8/attachment.html>