https://bugs.documentfoundation.org/show_bug.cgi?id=81135
--- Comment #11 from k...@cox.net --- I see the three predefined options now in LO Calc Version: 4.4.2.2 Build ID: 40m0(Build:2) Locale: en_US The first 2 appear to be what are required, and I am not asking for a predefined set for all scenario's; I am still wondering why there are still the three misleading paste special options: Text Numbers Date & time ...which actually mean: Paste text results as text and clear numbers and numbers formatted as dates. Paste numerical results as numbers and clear text and numbers formatted as dates. Paste numbers formatted as dates as dates and clear text and numbers. I still haven't been provided an example of a reasonable use for these options. The DATE() bug is 87386 and MOD() bug was 87506, which may have later been combined with 87386, because the cause of both may be the same. The example I gave when I reported 87386 creates a result that is wrong by one month (also in 4.4.2.2). Imagine tracking deliveries, financial transactions or medical procedures in a spreadsheet that randomly moved dates up by one month. I don't use LibreOffice Calc much anymore, because I use DATE() and MOD() for many things and can't accept the risk. -- 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