[Libreoffice-bugs] [Bug 113896] EDITING: Formula should be extended to a newly inserted row/ column

[bugzilla-daemon]

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

Thomas Lendo  changed:

   What|Removed |Added

 Blocks||108253, 113943

--- Comment #4 from Thomas Lendo  ---
(In reply to Kevin Suo from comment #3)
> There is an option in:
> Tools - Options - LibreOffice Calc - General - Expand reference when new
> columns/rows are inserted.
> 
> Check is option and then try the steps in your original bug report, it works
> perfect.
> 
> That option is not checked by default, because when it is checked, the
> formula may change (expand) if new columns/rows are inserted, thus it's
> dangerous at some point - only enable this option when you know what you are
> doing.
> 
> Close as WORKSFORME.
Thank you very much, Kevin. That's what I requested. I should read the help
more carefully ...


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=108253
[Bug 108253] [META] Calc cell formula bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=113943
[Bug 113943] [META] Options dialog's Calc settings bugs and enhancements
-- 
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 113896] EDITING: Formula should be extended to a newly inserted row/ column

[bugzilla-daemon]

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

Kevin Suo  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 CC||suokunl...@126.com
 Resolution|--- |WORKSFORME

--- Comment #3 from Kevin Suo  ---
There is an option in:
Tools - Options - LibreOffice Calc - General - Expand reference when new
columns/rows are inserted.

Check is option and then try the steps in your original bug report, it works
perfect.

That option is not checked by default, because when it is checked, the formula
may change (expand) if new columns/rows are inserted, thus it's dangerous at
some point - only enable this option when you know what you are doing.

Close as WORKSFORME.

-- 
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 113896] EDITING: Formula should be extended to a newly inserted row/ column

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 CC||todven...@suomi24.fi

--- Comment #2 from Buovjaga  ---
Currently the formula is updated, if you move a cell referenced in it. In your
steps you do not move A3, so nothing happens.

The current behaviour would conflict with your proposed: "This would extend the
formula to newly created A1 if the user clicks "Insert Row Above" in row 1"

This sort of mind-reading is difficult and changed behaviour might cause users
to be upset.

A working solution for these simple "numbers + sum formula" things is to have
one blank row above the sum row and to include it in the sum range. Now when
you insert rows from the last row with numbers, the formula range is updated.

-- 
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 113896] EDITING: Formula should be extended to a newly inserted row/ column

[bugzilla-daemon]

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

--- Comment #1 from Xavier Van Wijmeersch  ---
I cannot reproduce

Version: 6.0.0.0.alpha1+
Build ID: 20f6242b2c50876754368eeadcdc8902cf76e79a
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
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