Bug 41540 - PIVOTTABLE: pivot table should preserve cell format "text"
Summary: PIVOTTABLE: pivot table should preserve cell format "text"
Status: RESOLVED DUPLICATE of bug 42169
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2011-10-06 14:35 UTC by Nino
Modified: 2011-11-08 05:29 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
example spreadsheet with described behavior (only reproducible with 3.4.3) (8.67 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-10-06 14:35 UTC, Nino
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Nino 2011-10-06 14:35:00 UTC
Created attachment 52061 [details]
example spreadsheet with described behavior (only reproducible with 3.4.3)

Problem description: 
When using a pivot table for aggregating data from mixed colums (text & numbers), the entries from the text column data should not be converted to numbers.

Steps to reproduce:
1. create a new spreadsheet
2. formate the first column as text
3. enter following data into a table

category  amount
01        3
02        4
01        2
03        7

4. create pivot table from the above table, draw "category" field into row fields, "amount" field into data fields.

5. Result: text entries "01", "02", "03" get convertet into (numbers) 1, 2, 3.

Expected behavior: 
Text should stay text, like in prior versions (e.g. 3.3.4)
Comment 1 raf32 2011-10-08 16:35:46 UTC
I have reproduced it, seems a little bit like bug 41577. And I think Nino meant "drag" instead of "draw" in step 4. =)
Comment 2 Nikos 2011-10-11 02:23:32 UTC
This too seems to me to be the same problem as
https://bugs.freedesktop.org/show_bug.cgi?id=38327
Comment 3 Kohei Yoshida 2011-11-08 05:29:18 UTC
This is caused by the same bug as bug 42169.

*** This bug has been marked as a duplicate of bug 42169 ***