[Libreoffice-bugs] [Bug 96356] XLSX user defined number format roundtrip error

[bugzilla-daemon]

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

--- Comment #11 from lagarder  ---
Created attachment 130564
  --> https://bugs.documentfoundation.org/attachment.cgi?id=130564=edit
test file - start

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 96356] XLSX user defined number format roundtrip error

[bugzilla-daemon]

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

--- Comment #13 from lagarder  ---
Open TEST.xlsx file -> Microsoft Excel.
B3 cell 34 000 Ft (Format - currency)
1. Open TEST.xlsx file -> LibreOffice Calc 5.2.4.2
2. Modify B3 cell 17000 (not modify format !)
3. SAVE
4. Open TEST.xlsx file -> Microsoft Excel.
RESULT 17 Ft 

Attachment -> progress(BUG.jpg)

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 96356] XLSX user defined number format roundtrip error

[bugzilla-daemon]

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

--- Comment #14 from lagarder  ---
Created attachment 130566
  --> https://bugs.documentfoundation.org/attachment.cgi?id=130566=edit
Progress

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 96356] XLSX user defined number format roundtrip error

[bugzilla-daemon]

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

--- Comment #12 from lagarder  ---
Created attachment 130565
  --> https://bugs.documentfoundation.org/attachment.cgi?id=130565=edit
Result

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 96356] XLSX user defined number format roundtrip error

[bugzilla-daemon]

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

Bartosz  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |WORKSFORME

--- Comment #10 from Bartosz  ---
This issue was resolved with LibreOffice 5.1. Tested on Ubuntu 16.04

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 96356] XLSX user defined number format roundtrip error

[bugzilla-daemon]

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

Bartosz  changed:

   What|Removed |Added

 CC||glautercarre...@hotmail.com

--- Comment #9 from Bartosz  ---
*** Bug 101738 has been marked as a duplicate of this bug. ***

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 96356] XLSX user defined number format roundtrip error

[bugzilla-daemon]

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

Johnny_M  changed:

   What|Removed |Added

 CC||kla...@partyheld.de
   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=10
   ||1738

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 96356] XLSX user defined number format roundtrip error

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

   Keywords||bibisectRequest
 CC||xiscofa...@libreoffice.org

--- Comment #8 from Xisco Faulí  ---
Adding keyword 'bibisectRequest'.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 96356] XLSX user defined number format roundtrip error

[bugzilla-daemon]

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

--- Comment #7 from lagarder  ---
I forgot exactly.

Works correct in Version: 4.0.6.2
Build az.: 2e2573268451a50806fcd60ae2d9fe01dd0ce24) 

Repair expected?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 96356] XLSX user defined number format roundtrip error

[bugzilla-daemon]

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

--- Comment #4 from Andras Timar  ---
I used Linux, the original reporter (http://bug.openscope.org/browse/OOO-1056)
used Windows 7. Maybe I have to try 5.0.4.1, and check if this bug was fixed
there.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 96356] XLSX user defined number format roundtrip error

[bugzilla-daemon]

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

raal  changed:

   What|Removed |Added

Version|5.0.1.2 release |4.1.0.4 release

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 96356] XLSX user defined number format roundtrip error

[bugzilla-daemon]

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

--- Comment #6 from lagarder  ---
Thanks

I tested several versions
OS Windows 7 64bit

Works correct in Version: 4.0.0.3 x86
Works correct in Version: 4.0.6.2 x86
19 000Ft (before) -> 19 000Ft (after saving)

!!! The problem starts --- From Version: 4.1.0.1 x86
After saving - Different 
19 000Ft -> 19Ft
Version: 4.1.0.1 x86
Version: 4.2.0.1 x86
Version: 4.3.0.1 x86
Version: 4.3.7.2 x86
Version: 4.4.0.1 x86
Version: 4.4.0.3 x86
Version: 5.0.4.1 x64
Version: 5.0.3 x86

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 96356] XLSX user defined number format roundtrip error

[bugzilla-daemon]

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

raal  changed:

   What|Removed |Added

   Keywords||regression
 Status|UNCONFIRMED |NEW
 CC||r...@post.cz
 Ever confirmed|0   |1

--- Comment #5 from raal  ---
I can confirm with Version: 5.2.0.0.alpha0+
Build ID: de9d0e797903e7ecc19be2b05c7e89d5936ae02d
Threads 4; Ver: Linux 4.2; Render: default; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time:
2015-12-03_04:13:00

proba format cell C4: # ##0 "Ft"  is the same after after  resave, but
representation on screen is different - 19 000 Ft and 19Ft

Works correct in Version: 4.4.0.0.alpha0+
Build ID: c0a709e9912de8adb6777b40197accf865c4f046 -> regression

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 96356] XLSX user defined number format roundtrip error

[bugzilla-daemon]

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

--- Comment #1 from Andras Timar  ---
Created attachment 121170
  --> https://bugs.documentfoundation.org/attachment.cgi?id=121170=edit
proba2.xlsx

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 96356] XLSX user defined number format roundtrip error

[bugzilla-daemon]

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

--- Comment #3 from m.a.riosv  ---
I forgot.
Win10x64
Version: 5.0.4.1 (x64) Build ID: 2def61bcbb29a7a8611b833682fe1291910b11ad

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 96356] XLSX user defined number format roundtrip error

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 CC||miguelangelrv@libreoffice.o
   ||rg

--- Comment #2 from m.a.riosv  ---
Hi @Andras,

with the first sample, I'm not able to reproduce the issue. The same format
after save and reopen.

The second one has a different format.
proba:  #.##0" Ft"
proba2: #.##0."Ft"

The second format has a different meaning because the dot after the number
places, it is used to divide the value per thousand, by million with two dots.

Seems strange this change of format. " Ft" -> ,"Ft"

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs