[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 #14 from Robert Lacroix <ralacroix at hydro.mb.ca> ---
Bug is present.

Version: 6.1.5.2
Build ID: 1:6.1.5-3+deb10u6
CPU threads: 12; OS: Linux 4.19; UI render: default; VCL: x11; 
Locale: en-CA (en_CA.utf8); Calc: group threaded

This happens with any numeric value used as a row field with the field option
"Repeat item labels" enabled. Original labels are numeric and repeated labels
are converted to text.

The problem is not merely cosmetic. Using the labels of this field in the PT as
the SearchCriterion of a VLOOKUP formula will have different results depending
on whether the particular row's item label is numeric or text.

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.

-- 
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/7f36a995/attachment-0001.htm>