[Libreoffice-bugs] [Bug 123727] New: PIVOTTABLE Allow use of text columns as Data Fields

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 123727
           Summary: PIVOTTABLE Allow use of text columns as Data Fields
           Product: LibreOffice
           Version: 6.0.1.1 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: donaithnen at gmail.com

Description:
Per the question asked here:
https://ask.libreoffice.org/en/question/86251/how-do-you-reference-text-in-a-pivot-table-data-field/

As of 6.0 there's still no way to create a pivot table using columns with text
as Data Fields because all text values are ignored. If the text columns are
added as Row Fields the text is carried over into the pivot table but rows with
the same ID aren't combined.


Steps to Reproduce:
1.Create two sets of data with the same ID column and some shared IDs, but have
one set of text columns for the first block of data and another set of columns
for the second set of data.
2.Create a pivot table using the combined data.
3.Make the ID column a Row Field. If the text columns are included as Data
Fields the values disappear. If they're included as Row Fields they're not
combined.

Example
ID      Col1    Col2    Col3    Col4    Col5
1       Data 1 - 1      Data 2 - 1      Data 3 - 1              
1                               Data 4 - 1      Data 5 - 1


Actual Results:
Text as Data Fields

ID      Count - Col1    Max - Col2      Product - Col3  Max - Col4      Var -
Col5
1                                       

Text as Row Fields

ID      Col1    Col2    Col3    Col4    Col5    (empty)
1       Data 1 - 1      Data 2 - 1      Data 3 - 1      (empty) (empty) 
        (empty) (empty) (empty) Data 4 - 1      Data 5 - 1      



Expected Results:
ID      Col1    Col2    Col3    Col4    Col5
1       Data 1 - 1      Data 2 - 1      Data 3 - 1      Data 4 - 1      Data 5
- 1



Reproducible: Always


User Profile Reset: No



Additional Info:
The best way to address it would be either to have the Max or Min Data Field
functions work on text, or to add a new Data Field function "Text" or "First"
that would pick the first text field encountered for that column.

-- 
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/20190226/fa2f8325/attachment.html>