Bug 64441 - EDITING: PIVOT TABLE, lose data fields updating PT with the Spanish UI a file created with the English UI
Summary: EDITING: PIVOT TABLE, lose data fields updating PT with the Spanish UI a file...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.0.3.3 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-05-10 19:25 UTC by m_a_riosv
Modified: 2017-05-22 22:31 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Sample file (13.54 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-05-10 19:25 UTC, m_a_riosv
Details
Sample file new with 4.0.3. English UI (13.27 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-05-14 14:28 UTC, m_a_riosv
Details
Sample file saved in 3.6.6 Englis UI (11.96 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-05-14 14:37 UTC, m_a_riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description m_a_riosv 2013-05-10 19:25:15 UTC
Created attachment 79118 [details]
Sample file

Win7x64 Ultimate
Version 4.0.3.3 (Build ID: 0eaa50a932c8f2199a615e1eb30f7ac74279539)
Version: 4.1.0.0.alpha0+ Build ID: 4c4b9db8bbaed7acd064a4015fabe784c4fbca2 TinderBox: Win-x86@6, Branch:master, Time: 2013-04-28_06:18:09

LibreOffice Version 3.3.4.1
OpenOffice 3.4.1

Open the sample file create with 4.0.3.3 from scratch with Englis UI, when it is open in any version with Spanish UI and the Pivot Table is updated de data field disappear.
Comment 1 Jacques Guilleron 2013-05-14 13:55:23 UTC
Hello Mario,

I cannot get your attachment. Bugzilla display an error for line number 1, column 3. Can you see that?

regards,

jacques Guilleron
Comment 2 m_a_riosv 2013-05-14 14:28:44 UTC
Created attachment 79302 [details]
Sample file new with 4.0.3. English UI

Sorry Jacques, 

yes and I don't know why, (Firefox) if I rigth click and select Save the link as, I can open it with LibreOffice. Maybe an issue with the plug-in.

Attached a new file from scratch 4.0.3. English UI

Miguel Ángel
Comment 3 m_a_riosv 2013-05-14 14:37:21 UTC
Created attachment 79303 [details]
Sample file saved in 3.6.6 Englis UI

As the problem for open persist with the new sample even with IE, attached a new one created also from scratch with 3.6.6. Englis (US) UI.
Let's see what happen.
Comment 4 m_a_riosv 2013-05-14 14:46:24 UTC
Seems the problem for open with left click, remains there with or without the LibreOffice browser plug-in enable or not. (Menu/Tools/Options/Internet/Browser plug-in)
Comment 5 Jacques Guilleron 2013-05-16 14:44:43 UTC
Hi Miguel Ángel,

Sorry for this delay. I was absent.
I wonder if something is lacking for PT to operate, as Data in Data field.

Regards,

Jacques Guilleron
Comment 6 Adolfo Jayme Barrientos 2013-06-17 07:38:46 UTC
Comment on attachment 79118 [details]
Sample file

I fixed the MIME types of the attachments.
Comment 7 Jacques Guilleron 2013-06-18 13:48:25 UTC
Hi Miguel Ángel,

Some changes here. 
With master LO 4.2.0.0.alpha0+
Build ID: c36348f20c4fcb6ae1acb0fd06c19edfa9fb108
there's no issue.
Selecting the Pivot table and right clic > Edit layout
show Sum - Data2 in Data Field
eirher with the .cgi file or Mime Type file.
and datas indeed doesn't disappear.

Have a nice day,

Jacques Guilleron
Comment 8 m_a_riosv 2013-06-18 20:09:13 UTC
Hi Jacques, thanks for review, but maybe there is an misunderstanding, the issue is opening the file create with 4.x and opening with Spanish UI in 3.6.6 oe lower.
Comment 9 Jacques Guilleron 2013-06-20 10:06:14 UTC
Hi Miguel Ángel,

Here is my position:
To build the Pivot Table in this state, Sum - Data is required into Data Fields.
Now a possible scenario:
I want to alter the layout.
For some reason, I delete the Sum - Data from the Data fields.
If I press OK, datas are immediately deleted from the Pivot table but, if I exit the layout window without validating, datas are not deleted until...
and I can save the spreadsheet in this state.
This scenario is indeed reproducible in any UI.
So for me, the issue that has to be fixed is to not exit the layout window without refresh if something was changed.

What is your opinion?

Regards,

Jacques Guilleron
Comment 10 Jacques Guilleron 2013-06-20 19:44:25 UTC
I set it to NEW. Not specific to any UI.

Jacques Guilleron
Comment 11 m_a_riosv 2013-06-20 21:05:28 UTC
Hi Jacques, thanks for set the status.

Maybe a very specific case, anyway it is not urgent, and I think Kohei is in deeper jobs, which I hope can facilitate the things in calc.
Comment 12 QA Administrators 2015-03-17 00:16:42 UTC Comment hidden (obsolete)
Comment 13 m_a_riosv 2015-03-17 02:16:39 UTC
Present and reproducible:
Win7x64
Versión: 4.4.2.1
Id. de compilación: 93fc8832889bf050a10ec6d0171dae213adc9b55
Configuration: es_ES
Comment 14 tommy27 2016-04-16 07:23:15 UTC Comment hidden (obsolete)
Comment 15 QA Administrators 2017-05-22 13:23:04 UTC Comment hidden (obsolete)
Comment 16 m_a_riosv 2017-05-22 22:31:50 UTC
Works for me.
Versión: 5.3.3.2
Id. de compilación: 3d9a8b4b4e538a85e0782bd6c2d430bafe583448
Subproc. CPU: 4; SO: Windows 6.2; Repr. de IU: predet.; Motor de trazado: HarfBuzz; 
Configuración regional: gl-ES (es_ES); Calc: group