[Libreoffice-bugs] [Bug 113002] LibreOfficeCalc: Pivot Table recurring data field name will added a simple quotation marks before number

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #17 from Robert Lacroix <ralacroix at hydro.mb.ca> ---
(In reply to Robert Lacroix from comment #16)
correction:
> --or--
> 
> =IF(ISNUMBER(qe_date_field),qe_date_field,DATEVALUE(qe_date_field)+30))
> 
> 
> Long story short, the cell reference needed to work around this bug is both
> complex and fragile (being subject to the whims of source column formatting).

Actually this alternate formula doesn't work at all for quarter ending April
30.
See? Use accounting software.

-- 
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/20201227/0a8f6077/attachment.htm>