[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 Kohei Yoshida changed: What|Removed |Added Assignee|libreoffice-b...@lists.free |ko...@libreoffice.org |desktop.org | Status|NEW |ASSIGNED --- Comment #26 from Kohei Yoshida --- I'm looking. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 --- Comment #25 from Eike Rathke --- If this is a regression of the upgrade to mdds 2.0 as comment 21 indicates then best Kohei would inspect. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 --- Comment #24 from Herb B --- I just downloaded and tested this version: Version: 7.2.6.1 (x64) / LibreOffice Community Build ID: ce99d6a58f9368279ff1495b5b367eb64343b26c CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded This bug does NOT seem to exist in this version. Both sum and '+' operator auto calcing correctly on changed data values. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 Xisco Faulí changed: What|Removed |Added CC||er...@redhat.com --- Comment #23 from Xisco Faulí --- @Eike, I thought you might be interested in this issue -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 Xisco Faulí changed: What|Removed |Added OS|Windows (All) |All --- Comment #22 from Xisco Faulí --- Also happening in Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 0723b41bed9bb4ad50d2993744a60177966d1a21 CPU threads: 8; OS: Linux 5.10; UI render: default; VCL: gtk3 Locale: es-ES (es_ES.UTF-8); UI: en-US Calc: threaded using the file attached @Eike, I thought you might be interested in this issue -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 Xisco Faulí changed: What|Removed |Added Keywords|bibisectRequest |bibisected, bisected CC||ko...@libreoffice.org --- Comment #21 from Xisco Faulí --- Regression introduced by: https://cgit.freedesktop.org/libreoffice/core/commit/?id=eb07a0e76fe240a184348d96a6cebf7c0a229ac0 author Kohei Yoshida2021-11-01 14:01:22 -0400 committer Kohei Yoshida2021-11-03 21:17:18 +0100 commit eb07a0e76fe240a184348d96a6cebf7c0a229ac0 (patch) tree23ab960b7a163696e4a7c1d4c4c20c1340fa14b3 parent 9b9f4a4487e9ada1885d45a8b1ba0234a4a9fc26 (diff) Upgrade mdds and liborcus to 2.0.0 and 0.17.0, respectively. Bisected with: bibisect-linux64-7.3 Adding Cc: to Kohei Yoshida -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 Xisco Faulí changed: What|Removed |Added Severity|normal |major Status|RESOLVED|NEW Priority|medium |high Resolution|DUPLICATE |--- --- Comment #20 from Xisco Faulí --- Reproduced in Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community Build ID: b1fe159fa39b2fc5217848e14d68c674979c181c CPU threads: 16; OS: Windows 6.3 Build 9600; UI render: default; VCL: win Locale: en-GB (en_GB); UI: en-US Calc: threaded Using the attached file -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 --- Comment #19 from JO3EMC --- (In reply to Xisco Faulí from comment #18) > Please, share the info from Help - About LibreOffice Version: 7.3.2.0.0+ (x64) / LibreOffice Community Build ID: 9e32472d623998a1beaaf69342c53d1be5d1732f CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: CL Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 4202ea2c932a14d216e74617bbb74a85030c9a59 CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: CL -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 --- Comment #18 from Xisco Faulí --- (In reply to JO3EMC from comment #17) > (In reply to Xisco Faulí from comment #16) > > I created a unittest for bug 147398 and this one looks pretty much the same > > as that one. > > This should be fixed in LibreOffice 7.3.1, due to be released next week. > > > > *** This bug has been marked as a duplicate of bug 147398 *** > > No. > 7.3.2 and 7.4.0a0, which resolve Bug 147 398, do not resolve this Bug 148 > 298 issue. > I don't think it is expected to be resolved even in 7.3.1. Please, share the info from Help - About LibreOffice -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 --- Comment #17 from JO3EMC --- (In reply to Xisco Faulí from comment #16) > I created a unittest for bug 147398 and this one looks pretty much the same > as that one. > This should be fixed in LibreOffice 7.3.1, due to be released next week. > > *** This bug has been marked as a duplicate of bug 147398 *** No. 7.3.2 and 7.4.0a0, which resolve Bug 147 398, do not resolve this Bug 148 298 issue. I don't think it is expected to be resolved even in 7.3.1. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 Xisco Faulí changed: What|Removed |Added CC||xiscofa...@libreoffice.org Status|NEW |RESOLVED Resolution|--- |DUPLICATE --- Comment #16 from Xisco Faulí --- I created a unittest for bug 147398 and this one looks pretty much the same as that one. This should be fixed in LibreOffice 7.3.1, due to be released next week. *** This bug has been marked as a duplicate of bug 147398 *** -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 Buovjaga changed: What|Removed |Added Keywords||bibisectRequest, regression --- Comment #15 from Buovjaga --- Could someone please bibisect it on Windows https://wiki.documentfoundation.org/QA/Bibisect/Windows -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 --- Comment #14 from JO3EMC --- Bug 147398 seems to have been fixed in 2022-02-17 in 7.4.0 and 7.3.2. I tried today's daily build, but this issue doesn't seem to be fixed. It may be another issue. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 --- Comment #13 from Herb B --- Confirmed. I just tried same test using + operator instead of sum. Same problem. I also just put some values in some existing columns to the right of columns that already had some values in it. Then copied over the sum formula. Changes in values do not result in correct sum. So problem is not confined to newly inserted columns. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 --- Comment #12 from JO3EMC --- excuse me... for my post in Japanese. This issue reproduced not only with sum(), but also with + operator. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 --- Comment #11 from JO3EMC --- この問題は、sum()だけでなく、+演算子でも再現されました。 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 --- Comment #10 from JO3EMC --- Sorry. Bug 147398. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 JO3EMC changed: What|Removed |Added See Also||https://bugs.documentfounda ||tion.org/show_bug.cgi?id=14 ||7398 --- Comment #9 from JO3EMC --- Also, recalculation (F9) in the sheet full selection (Ctrl + A) state does not work. I haven't verified it enough yet, but it may be the same problem as Bug 147 398. It seems that it has been fixed and reflected in 7.3.1. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 --- Comment #8 from Herb B --- I agree the importance should be changed from normal to 'major' or 'critical'. .I dont have the authority to do that. This problem is producing wrong results. Easily reproduceable. I also see problem on existing columns, but havent figured out to exactly reproduce that..yet.. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 JO3EMC changed: What|Removed |Added CC||jo3...@jarl.com Status|UNCONFIRMED |NEW Ever confirmed|0 |1 --- Comment #7 from JO3EMC --- It is reproduced in 7.3.0.3, 7.3.1.1, 7.4.0.0a0. There is no problem with 7.2.5.2. I think it's fatal. Immediate response is desired. I haven't been able to determine the reproduction conditions, but in my environment it seems that the same phenomenon can occur not only with column insertions, but also with simple copies. Version: 7.3.0.3 (x64) / LibreOffice Community Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3 CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: default; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: CL Version: 7.3.1.1 (x64) / LibreOffice Community Build ID: 349cd3ad57dce98d6b54b76f8e9f456ac7d7edb7 CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Vulkan; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: CL Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 2bb10a827ac13d0caf009e8526ccd9f17dc71653 CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: ja-JP (ja_JP); UI: ja-JP Calc: CL -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 Imran Iqbal changed: What|Removed |Added CC||iqba...@hotmail.com --- Comment #6 from Imran Iqbal --- Hitting the same problem ever since I upgraded to the following version: ``` Version: 7.3.0.3 / LibreOffice Community Build ID: 30(Build:3) CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: x11 Locale: en-GB (en_GB.UTF-8); UI: en-GB Ubuntu package version: 1:7.3.0~rc3-0ubuntu0.20.04.1~lo1 Calc: threaded ``` The only workaround I've found is hitting `Ctrl+Shift+F9`, i.e. `Data > Calculate > Recalculate Hard`. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 --- Comment #5 from Herb B --- Just downloaded and installed 7.4.0.0 alpha. Windows 11 x64. Bug still exists. Auto calculate not working. Version: 7.4.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 95b80365218f9406a5d952c1250d53222d319000 CPU threads: 8; OS: Windows 10.0 Build 22000; UI render: Skia/Vulkan; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 raal changed: What|Removed |Added CC||r...@post.cz --- Comment #4 from raal --- No repro with Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 23846867ea32667ccf328c36142394dd6aaee8ba CPU threads: 4; OS: Linux 5.11; UI render: default; VCL: gtk3 Locale: en-MY (cs_CZ.UTF-8); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 --- Comment #3 from Herb B --- Just retested and confirmed this bug is not in 7.2.5.2 Also downloaded and clean installed 7.3.1.1. This bug does exist in this version as well. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 --- Comment #2 from Herb B --- Bug should probably be a 'major' bug since workbook values are incorrect. Easily noticeable on very small spreadsheets but could be problematic on large workbooks. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 147298] Auto Calculate does not work on newly inserted columns in ods or xls formats
https://bugs.documentfoundation.org/show_bug.cgi?id=147298 --- Comment #1 from Herb B --- Created attachment 178239 --> https://bugs.documentfoundation.org/attachment.cgi?id=178239=edit Excel spreadsheet showing the auto calculate bug See instructions in workbook to easily recreate this bug. bug also occurs in Opencalc ods file formats -- You are receiving this mail because: You are the assignee for the bug.