Issue 119836 - after refresh data lost in pivot result table
Summary: after refresh data lost in pivot result table
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.0
Hardware: PC All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: ms_interoperability
Depends on:
Blocks: 120823
  Show dependency tree
 
Reported: 2012-06-06 08:27 UTC by xiao ting xiao
Modified: 2013-06-22 21:46 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
sample file of pivot (16.00 KB, application/vnd.ms-excel)
2012-06-06 08:27 UTC, xiao ting xiao 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description xiao ting xiao 2012-06-06 08:27:57 UTC 
Created attachment 78065 [details]
sample file of pivot

Steps:
1. Open attached xls file in AOO
2. Right click on pivot result table, and click Refresh

Problem:
all data lost.
Comment 1 xiao ting xiao 2012-06-06 08:30:26 UTC 
The name of "Units"(it's in data area) has special blank at the front of string. Excel ignores it while create Pivot table. It makes the string different in source data and resault table. So after refresh, all data lost.
Comment 2 binguo 2012-06-12 07:20:13 UTC 
This bug can repros on AOO3.4.O Rev. 1327774,
and I change the status from Unconfirmed to confirmed.