[Libreoffice-bugs] [Bug 75627] General number format change leads to inconsistent/lost formatting

[bugzilla-daemon]

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

Kira Tubo  changed:

   What|Removed |Added

 CC||kira.t...@gmail.com

--- Comment #11 from Kira Tubo  ---
Reproduced on master build 

Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: dd7fc07f83416a3d8a444947b7d28f7347520d6a
CPU threads: 6; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 75627] General number format change leads to inconsistent/lost formatting

[bugzilla-daemon]

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

--- Comment #10 from QA Administrators  ---
Dear tmacalp,

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://web.libera.chat/?settings=#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 75627] General number format change leads to inconsistent/lost formatting

[bugzilla-daemon]

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

--- Comment #9 from QA Administrators  ---
Dear tmacalp,

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present with the latest version of LibreOffice
from https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the information
from Help - About LibreOffice.

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a comment that includes the information from Help
- About LibreOffice.

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3) from
https://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to 'inherited from OOo';
4b. If the bug was not present in 3.3 - add 'regression' to keyword


Feel free to come ask questions or to say hello in our QA chat:
https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug

-- 
You are receiving this mail because:
You are the assignee for the bug.

[Libreoffice-bugs] [Bug 75627] General number format change leads to inconsistent/lost formatting

[bugzilla-daemon]

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

Xisco Faulí  changed:

   What|Removed |Added

   See Also||https://bugs.documentfounda
   ||tion.org/show_bug.cgi?id=11
   ||9509

-- 
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 75627] General number format change leads to inconsistent/ lost formatting

[bugzilla-daemon]

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

--- Comment #8 from Xavier Van Wijmeersch  ---
I can confirm that the behavior as explained in description is still there

Version: 6.0.0.0.alpha0+
Build ID: 19910c461230f70bb9e98ad44db3525f0d755724
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

and

Version: 5.4.3.0.0+
Build ID: 8d6dd32d58494cc21c32bc3c4798fdd4593bde08
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

and

Version: 6.0.0.0.alpha0+
Build ID: 892c719fffa06de4c7aeab497326cad7bae9e5c6
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time:
2017-09-27_03:02:09
Locale: nl-BE (en_US.UTF-8); Calc: group

-- 
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 75627] General number format change leads to inconsistent/ lost formatting

[bugzilla-daemon]

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

--- Comment #7 from Xisco Faulí  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of
LibreOffice 
(5.4.1 or 5.3.6  https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of
LibreOffice and 
your operating system, and any changes you see in the bug behavior

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave 
a short comment that includes your version of LibreOffice and Operating System

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not 
appropriate in this case)


If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your
bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword


Feel free to come ask questions or to say hello in our QA chat:
http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for helping us make LibreOffice even better for everyone!

Warm Regards,
QA Team

MassPing-UntouchedBug-20170929

-- 
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 75627] General number format change leads to inconsistent/lost formatting

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=75627

Matthew Francis fdb...@neosheffield.co.uk changed:

   What|Removed |Added

   Keywords||bisected
 CC||fdb...@neosheffield.co.uk,
   ||markus.mohrhard@googlemail.
   ||com

--- Comment #4 from Matthew Francis fdb...@neosheffield.co.uk ---
This behaviour changed over the course of a couple of commits. Before
57efd69c22e2c6f5cb4d057345644b6e07a62d48, the =A1 reference doesn't have an
independent format that can be reset or altered. From
e18f5306714e6ca4103dd236bcf3187d492cbb91 onwards (modulo a merge error fixing
commit which follows), the current situation where the format can be reset but
doesn't roundtrip correctly occurs.

Adding Cc: to markus.mohrh...@googlemail.com. Could you possibly take a look at
this? Thanks


commit 57efd69c22e2c6f5cb4d057345644b6e07a62d48
Author: Markus Mohrhard markus.mohrh...@googlemail.com
Date:   Fri May 24 22:41:44 2013 +0200

remove inherited number formats, related fdo#60215

Change-Id: I23d5e1b3baeb1499ada1fba1665027bdbe3fbb87

commit e18f5306714e6ca4103dd236bcf3187d492cbb91
Author: Markus Mohrhard markus.mohrh...@googlemail.com
Date:   Sat May 25 15:12:24 2013 +0200

all formula cells have now an explicit number format

Remove ScFormulaCell::GetStandardFormat

Change-Id: I0b19f572cfcf5c08c81009b0f10e7cc44a1aa2f4

-- 
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 75627] General number format change leads to inconsistent/lost formatting

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=75627

Beluga todven...@suomi24.fi changed:

   What|Removed |Added

 CC||todven...@suomi24.fi
 Whiteboard||bibisectRequest

-- 
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 75627] General number format change leads to inconsistent/lost formatting

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=75627

tmacalp tmac...@gmail.com changed:

   What|Removed |Added

 Whiteboard|bibisectRequest |bibisected

--- Comment #3 from tmacalp tmac...@gmail.com ---
Apparently, LO is saving the cleared format state, but ignoring that change on
document load.

Bibisected:
7a454addef42971c41393dd4f668123884973601 is the first bad commit
commit 7a454addef42971c41393dd4f668123884973601
Author: Bjoern Michaelsen bjoern.michael...@canonical.com
Date:   Thu Oct 17 09:21:19 2013 +

source-hash-23583553d1a9951eaa33dfb598606cdf55d3f01a

commit 23583553d1a9951eaa33dfb598606cdf55d3f01a
Author: Michael Stahl mst...@redhat.com
AuthorDate: Sun Jun 2 13:26:30 2013 +0200
Commit: Michael Stahl mst...@redhat.com
CommitDate: Sun Jun 2 20:37:57 2013 +0200

mysqlcppconn: MSVC 2010 finally has grown a stdint.h

Change-Id: I5b8d948aad94ba492075245c18c8ed781baa469e

:100644 100644 27848ba16c148657f41ac7b1df02e091a44dd29f
7beb466ac333cd27a5756f959c24f4514c12f47b M  ccache.log
:100644 100644 601e47632607a385493e43c480061748c2ca4c7b
57fbcee71fd8e9eb24ab4c293f9023f03784d884 M  commitmsg
:100644 100644 21e4be7670edb7af70f3d7bf4f3a21a45c2e09bd
35f68343cf886768eaa96263b6e4a8164eb92a05 M  dev-install.log
:100644 100644 fc4c2507cb79b70a4e64b27a328ce2b4507374f9
43d9c0d800f3e49309b6b8e5393c27810a50c177 M  make.log
:04 04 787f0b310a532028f6ef2a3b46651a691148
827d6a3eb295e2aabe319c0683bab9adc4e2e26e M  opt

$ git bisect log
# bad: [423a84c4f7068853974887d98442bc2a2d0cc91b]
source-hash-c15927f20d4727c3b8de68497b6949e72f9e6e9e
# good: [65fd30f5cb4cdd37995a33420ed8273c0a29bf00]
source-hash-d6cde02dbce8c28c6af836e2dc1120f8a6ef9932 
git bisect start 'latest' 'oldest'  
# bad: [e02439a3d6297a1f5334fa558ddec5ef4212c574]
source-hash-6b8393474974d2af7a2cb3c47b3d5c081b550bdb
git bisect bad e02439a3d6297a1f5334fa558ddec5ef4212c574 
# good: [8f4aeaad2f65d656328a451154142bb82efa4327]
source-hash-1885266f274575327cdeee9852945a3e91f32f15
git bisect good 8f4aeaad2f65d656328a451154142bb82efa4327
# good: [9995fae0d8a24ce31bcb5e9cd0459b69cfbf7a02]
source-hash-8600bc24bbc9029e92bea6102bff2921bc10b33e
git bisect good 9995fae0d8a24ce31bcb5e9cd0459b69cfbf7a02
# good: [8ad82bc1416a07501651e8d96fe268e47d3931d3]
source-hash-13821254f88d2c5488fba9fe6393dcf4ae810db4
git bisect good 8ad82bc1416a07501651e8d96fe268e47d3931d3
# good: [d084d250b04446535ca1d7c29cf2062e6bd042b3]
source-hash-688f72e3a2c3ef923389bbd21f6aea3afe1114db
git bisect good d084d250b04446535ca1d7c29cf2062e6bd042b3
# good: [c2069a369d738078124812312d51f21ea1ce2421]
source-hash-f160e4935c474a5293b3d3c11b3d538efb4767a0
git bisect good c2069a369d738078124812312d51f21ea1ce2421
# good: [a0f20bc04a32a7791ba765d2de2f44f1b74033d1]
source-hash-1de66ba440855050a794b3b2a8647c1b02c210b8
git bisect good a0f20bc04a32a7791ba765d2de2f44f1b74033d1
# bad: [a48fbf799e4d4d555fe383b7233c804f573eca4e]
source-hash-bb6ecd8b40313b7cc83d4e619029f4e001334a52
git bisect bad a48fbf799e4d4d555fe383b7233c804f573eca4e
# bad: [7a454addef42971c41393dd4f668123884973601]
source-hash-23583553d1a9951eaa33dfb598606cdf55d3f01a
git bisect bad 7a454addef42971c41393dd4f668123884973601
# good: [bb1ef709fce943598a8bcab0234b9a4ba1b2e69a]
source-hash-c4cca49f49408bc4094bdfcf782de2f7cd16ce6a
git bisect good bb1ef709fce943598a8bcab0234b9a4ba1b2e69a
# first bad commit: [7a454addef42971c41393dd4f668123884973601]
source-hash-23583553d1a9951eaa33dfb598606cdf55d3f01a

-- 
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 75627] General number format change leads to inconsistent/lost formatting

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=75627

--- Comment #1 from tmacalp tmac...@gmail.com ---
Created attachment 94921
  -- https://bugs.freedesktop.org/attachment.cgi?id=94921action=edit
Example spreadsheet

-- 
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 75627] General number format change leads to inconsistent/lost formatting

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=75627

tmacalp tmac...@gmail.com changed:

   What|Removed |Added

   Priority|medium  |high
   Keywords||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 75627] General number format change leads to inconsistent/lost formatting

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=75627

m.a.riosv mari...@miguelangel.mobi changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 CC||mari...@miguelangel.mobi
 Ever confirmed|0   |1

--- Comment #2 from m.a.riosv mari...@miguelangel.mobi ---
Hi tmacalp, thanks for reporting.

Clearing the format, when reopening the inherited format is restored.
But if you set up a format (not clear), the new format is preserved after
reload.

The issue is still there with:
Win7x64Ultimate
Version: 4.2.2.1 Build ID: 3be8cda0bddd8e430d8cda1ebfd581265cca5a0f

-- 
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