[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 #15 from Robert Lacroix <ralacroix at hydro.mb.ca> ---
e: #(In reply to Robert Lacroix from comment #14)

> One workaround is to convert this column in the source data to a text value.
> One way to do this for computed values is to append an empty string onto the
> computation. For example:  =date(1995,7,28)&""  Then all the item labels
> will be text for that field.
> 
> This is an unsatisfactory workaround if you expect the field to have numeric
> values, like when applying conditional formatting or when using the labels
> in a numeric computation. For instance when cell A3 contains a text value 
> '1234  and cell D3 contains a formula  =A3>1235  the value of cell D3 is
> TRUE.

Actually, this workaround is barely even useful - it works only for numbers
whose integer part is fixed-length, like a bar code. Integers of varying length
converted to text strings will sort ascending lexically so that  "1000" comes
before "104". The workaround sorts the text representation of the date/time
values correctly but the resulting string of digits is practically worthless
because you can't interpret it as a date without converting it back to a
number.

-- 
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/723d4535/attachment.htm>