Dear LibO developers I found a problem in Calc formatting decimal places. This problem does not appear in any LibO stable releases (<=4.0.3.3) but begins in 4.1.0.0beta1+ (problem also appear in beta2). Tried both Linux and Win versions and problem persists regardless of platform. Example: | A | B --+--------+----------------------+ 1 | Name | Value | --+--------+----------------------+ 2 | X | 1.0 | --+--------+----------------------+ 3 | Y | 3.00 | --+--------+----------------------+ 4 | Z | 7 | --+--------+----------------------+ 5 | AVG | =AVERAGE(B2:B4) | --+--------+----------------------+ Formatting (addition/deletion) of decimal places in cell B5 is ok as long as the worksheet is not saved. Once the worksheet is saved and then re-opened, formatting of decimal places in B5 is disabled, other cells are still ok. It does not matter what function is used in cell B5, others like SUM(), TOTAL() can do the same. Hope that this issue could could be fixed prior to 4.1 stable release. Thanks a lot.
Confirmed. Win7x64 Ultimate Version 4.0.4.1 (Build ID: 7fdd5ee61c1c7379dd088f5d50265f0adbccf53) Works properly. Versión 3.6.6.1 (compilation: a61ad19)
Seems to work fine in master. IF you still can reproduce it in master or RC1 please attach a test document showing the issue.
Dear Markus Many thanks for looking this issue into matter. I tried again the same problem case with the latest snapshots from: http://dev-builds.libreoffice.org/daily/libreoffice-4-1/Linux-x86@34-Release-Configuration-RHEL5-Baseline/2013-06-24_06.49.29/libreoffice-4-1~2013-06-24_06.49.29_LibreOffice_4.1.0.1.0_Linux_x86_deb.tar.gz Version: 4.1.0.1.0+ Build ID: e34c72113363e942920e4f6d1557fe36656b208 TinderBox: Linux-x86@34-Release-Configuration-RHEL5-Baseline, Branch:libreoffice-4-1, Time: 2013-06-24_06:49:29 and http://dev-builds.libreoffice.org/daily/master/Win-x86@6/2013-06-23_23.38.35/master~2013-06-23_23.38.35_LibreOfficeDev_4.2.0.0.alpha0_Win_x86.msi Version: 4.2.0.0.alpha0+ Build ID: c639c0931c3fed566df0a6fb3ec68d2c9884d2d4 TinderBox: Win-x86@6, Branch:master, Time: 2013-06-23_23:38:35 (there is no latest master snapshot available for my Linux 32-bit platform) The Win32 master version works but the Linux 32-bit version still does not. The Linux 32-bit 4.1.0 RC1 does not work neither. I would be appreciated if you may correct this problem in any of the RCs so that any future stable releases are free from this bug. Thanks again.
Also tried the Win32 stable 4.0.4 release from: http://download.documentfoundation.org/libreoffice/stable/4.0.4/win/x86/ Version 4.0.4.2 (Build ID: 9e9821abd0ffdbc09cd8c52eaa574fa09eb08f2) This version works OK. The version of 4.1.0RC1 which does not work is from: http://www.libreoffice.org/download/pre-releases/ Linux 32-bit 4.1.0 RC1 Version: 4.1.0.1 Build ID: 1b3956717a60d6ac35b133d7b0a0f5eb55e9155 Looks like the 4.1 branch is still having problem.
I think I see what is going on :-/ for some reason the it seems that updates for that formula cell are not triggered after reload, I guess this is a side effect of some performance related work. Note: if you tweak one of the dependant cells e.g. b2,b3 or b4 ( from the example in this bug ) then the cell is updated ( and the format applied ). So the format is really applied to the cell I think ( but it is the cell itself is not refreshed ) I am not familiar with this stuff but I'll take the bug for a while, I go on vacation next week so if I dont make progress I'll return it to the list
*** This bug has been marked as a duplicate of bug 66242 ***
not really a duplicate of the bug mentioned previous anyway cc'ing Moggi for this problem ( he is already looking into other instances of this )
(In reply to comment #7) > not really a duplicate of the bug mentioned previous > anyway cc'ing Moggi for this problem ( he is already looking into other > instances of this ) I still think it is a duplicate of Bug 66076. The fix for it has been applied to 4-1 this morning which would explain why it worked already in master. @Noel: Could you reproduce it in a recent master build or only in a 4-1 build?
Hi Markus Thanks again for looking at this issue. Noel, from what he mentioned in his previous message, is likely on vacation for the time being. I am just able to download and try the latest (post-Jun 28) 4.1 snapshot for Linux 32-bit platform from http://dev-builds.libreoffice.org/daily/libreoffice-4-1/Linux-x86@34-Release-Configuration-RHEL5-Baseline/ Version: 4.1.0.1.0+ Build ID: 87daa3c948eaa928591d95c9528922471fde57c TinderBox: Linux-x86@34-Release-Configuration-RHEL5-Baseline, Branch:libreoffice-4-1, Time: 2013-07-02_08:05:12 I believe this version is patched and I can confirm this version works OK.
Also tried the latest snapshot from master on Win32 platform: http://dev-builds.libreoffice.org/daily/master/Win-x86@6/2013-07-02_23.36.17/ Version: 4.2.0.0.alpha0+ Build ID: 6f86d931b4266d00fec75c0124ac9fc3026a4f1b TinderBox: Win-x86@6, Branch:master, Time: 2013-07-02_23:36:17 This version works fine too. It looks this bug is resolved. Thanks again for Mario, Noel and Markus for your works on confirming, evaluating and fixing this problem. Cheers!
Then let us assume it is fixed. The patch has been pushed to 4-1 meanwhile so we can assume it is fixed. Please check with 4.1.0.2
(In reply to comment #8) > (In reply to comment #7) > > not really a duplicate of the bug mentioned previous > @Noel: Could you reproduce it in a recent master build or only in a 4-1 > build? I was only testing 4.1 ( and previous ) branches so no... didn't look on master. Also seen fixed now on 4.1