Description: Hello I'd like to report an issue I'm having This is what's happening: When I type numbers into two different cells, select those two + an empty one and click "Sum", I get the sum from those two cells and the result is typed into the third one. This is fine, the problem appears when I try to continue this by typing another number into a cell below the result, select the result, the new cell with a number and an empty cell. Now when I click "Sum" I just get the number from the new cell. An example to provide a better explanation: Type 2 in cell A1 Type 2 in cell A2 Select A1, A2 and A3 (A3 is empty, that's where I want my result) Click on "Sum" This works fine, I get 4 in cell A3 "=Sum(A1:A2)" But when I continue: Type 2 in cell A4 Select A3 to A5 Click "Sum" And now the number I get in A5 is 2 instead of 6 as it should be "=Sum(A4:A4)" instead of "=Sum(A3:A4)" I've observed this issue for some time now throughout all versions. It works as expected in Excel, but unfortunately doesn't in Libreoffice. Any help would be appreciated. Steps to Reproduce: Refer to description Actual Results: Refer to description Expected Results: New sum including existing sum Reproducible: Always User Profile Reset: Yes Additional Info:
Created attachment 150644 [details] Sum with existing sum created by using mouse
(In reply to Petr Polacek from comment #0) > But when I continue: > Type 2 in cell A4 > Select A3 to A5 > Click "Sum" > And now the number I get in A5 is 2 instead of 6 as it should be > "=Sum(A4:A4)" instead of "=Sum(A3:A4)" reproducible as described
This bug in Calc is very old and is on all platforms I tested: LibreOffice & OpenOffice on Windows PC - Intel/AMD (32 bit and 64bit) LibreOffice & OpenOffice on Linux PC (Centos, Debian) - Intel/AMD (32/64bit) LibreOffice on Linux - ARM CPU - BananaPi LibreOffice on PowerMac G5 - MacOS X & Linux (IBM PowerPC CPU) NeoOffice on PowerMac G5 - MacOS X (IBM PowerPC CPU)
Created attachment 150687 [details] In bottom status line is sum Ok
In bottom status line is sum as I want - second attachement. So the problem is only in automaticky generated formula by clicking on the Sum icon.
repro in Version: 6.3.0.0.alpha0+ (x64) Build ID: 35d9a2618dc0116378ab795a7b9277d248c5afd4 CPU threads: 8; OS: Windows 6.1; UI render: default; VCL: win; TinderBox: Win-x86_64@42, Branch:master, Time: 2019-04-05_04:55:04 Locale: de-DE (de_DE); UI-Language: en-US Calc: threaded i think the community needs someone to clean out - fix!, not 'plaster' - all theese old bugs ...
just tested, still buggy in 6.4.0.2, would be nice if someone with skills and knowledge about the code could care for it, perhaps it's quite easy ... as it's only a small 'isolated' functionality to suggest the selected range for the formula, instead of a part of it if it already contains a formula? looks as if it fails as well with manually entered formulas as with 'wizard inserted', looks as if it fails only with formulas referencing a range, regardless if represented by 'start:end' or enumeration (A1;A2;A3), but doesn't fail with distinct summation - 'A1+A2+A3', and fails only if one of the formulas (SUM, MIN, MAX, AVERAGE, COUNT) which are offered by the wizard is found into the list of operands, if you have a '=PRODUCT(Xi:Yn)' into the operands they are evaluated correctly, reg. b.
Dear Petr Polacek, 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
Still present: Version: 7.6.2.1 (X86_64) / LibreOffice Community Build ID: 60(Build:1) CPU threads: 4; OS: Linux 5.14; UI render: default; VCL: gtk3 Locale: es-MX (en_US.UTF-8); UI: en-US Calc: threaded And 7.5.9.2 on Windows.
Intended behaviour. For details see https://bugs.documentfoundation.org/show_bug.cgi?id=149041#c3 and following.