Created attachment 99455 [details] Demonstrar o erro Problem description: Ao inserir x linhas (mais de uma) antes de uma linha que contenha a função soma em uma de suas células, a função soma inclui automaticamente a quantidade de linhas inseridas no intervalo a ser somado. Steps to reproduce: 1. Posiciono o cursor sobre a célula A5, seleciono três linhas a partir desta linha (5) para baixo, ou seja, as linhas 5, 6 e 7. 2. A célula A6 contém a seguinte fórmula: SOMA(A7:A10) 3. Clico com botão direito do mouse sobre o intervalo selecionado e escolho a opção "inserir - linha inteira" ou "inserir linhas acima". 4. Foram inseridas três linhas em branco, o conteúdo das linhas 5,6 e 7 foram automaticamente para as linhas 8, 9 e 10 respectivamente. 5. A célula A9 passou a informar o seguinte erro: ERRO:522. 6. Ao clicar sobre a célula A9 a fórmula que antes de inserir as linhas era "SOMA(A7:A10)" passou automaticamente para "SOMA(A7:A13)". Current behavior: SOMA(A7:A13) Expected behavior: SOMA(A10:A13) Operating System: Windows 7 Version: 4.2.4.2 release
please translate in english which is the official language of the bugtracker, otherwise it will be hard to help for those who don't speak your language... is that portuguese?
Problem Description When inserting more then one rows before a row containing the sum function, the sum function automatically includes the number of rows inserted in the range to be added in the function. Steps to Produce 1. I position the cursor on cell A5, I select three lines from this line (5) down, ie, lines 5, 6 and 7. 2. A6 cell contains the following arguments: SUM(A7:A10) 3. I click with the right mouse button on the selected range and choose the option "insert - entire line" or "insert rows above". 4. Three lines were inserted blank, the contents of lines 5,6 and 7 were automatically to lines 8, 9 and 10 respectively. 5. The A9 cell went on to inform the following error: ERROR:522. 6. When you click on the A9 cell, the argument of the SUM function automatically changed to "SUM(A7: A13)". Current behavior: SUM(A7:A13) Expected behavior: SUM(A10:A13) Operating System: Windows 7 Version: 4.2.4.2 release Sorry for my english. I speak very little English. I am a Brazilian citizen and I speak my language fluently: Portuguese of Brazil.
This needs to be triaged.
tried to translate summary notes. please upload a test file.
Reproducible with: Win7x64 Version: 4.2.4.2 Build ID: 63150712c6d317d27ce2db16eb94c2f3d7b699f8 Works for me with: Win7x64 Version: 4.2.5.0.0+ Build ID: f3ca9cc78e77dda656b5c39be928fdbb7f8babe8 TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-05-23_03:10:34 I thinks this is a duplicate of https://bugs.freedesktop.org/show_bug.cgi?id=77647 Please if you are not agree, reopen it. *** This bug has been marked as a duplicate of bug 77647 ***