Created attachment 110518 [details] Readings table 4 cols: timestamp; 3 readings Hi Creating "dynamic" named range: $Tabelle1.$B3:$B$3 (note missing $-sign on row indicator on range start) This is expanding as expected to $Tabelle1.$B3:$B$4 when inserting row above row 3 Functions using referencing name do not update during runtime. Update done when saving/reopening file. Same happening when deleting row from "dynamic" range Not tested with column Att.
I can confirm with Version: 4.5.0.0.alpha0+ Build ID: a26222f5af55e8ffe9784dd411485d3c5c72e983 TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2014-12-07_01:55:26 Steps to reproduce: open file insert empty for above row 3 insert value 10 into cell B3 watch cell B1 (no change) CTRL+SHIFT+F9 -> B1 change value
** Please read this message in its entirety before responding ** 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 on a currently supported version of LibreOffice (5.0.4 or later) https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System 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) http://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: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-12-20
Mint 17.3 4.2.0-19-generic Version: 5.0.3.2 Build-ID: 1:5.0.3~rc2-0ubuntu1~trusty2 Gebietsschema: de-CH (de_CH.UTF-8) still present can't confirm CTRL+SHIFT+F9 behavior as reported by "raal"
** Please read this message in its entirety before responding ** 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 on a currently supported version of LibreOffice (5.1.6 or 5.2.3 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System 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) http://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: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170103
still present no changes noticed 5.2.3.2 Mint 18.1
** Please read this message in its entirety before responding ** 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 http://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://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Still present: Version: 6.0.5.2 Build-ID: 1:6.0.5~rc2-0ubuntu0.18.04.1~lo1 CPU-Threads: 8; BS: Linux 4.15; UI-Render: Standard; VCL: gtk3; Gebietsschema: de-CH (de_DE.UTF-8); Calc: group
aaker thanks for following your bugs. But when testing, it's always better idea to test also with master. Normally you get it from https://dev-builds.libreoffice.org/daily/master/ but in Linux it's very convenient to use Appimage in Linux from https://www.libreoffice.org/download/appimage/ or daily from https://libreoffice.soluzioniopen.com/. As for this bug (test in Windows, so not Linux-only): I first opened attachment 110518 [details] with LO 6.2+ with steps from raal. Hard recalc doesn't help. Even setting to prompt user on fileopen for recalc, it asks, but doesn't solves the issue. Then I saved and reopened and it works. That's what puzzles me. I remember we had few bugs with "hard recalc doesn't help". Works with LO 4.1. I'll mark regression but that needs to be confirmed.
Created attachment 144221 [details] bibisect "need save/reload" in till51 repo, tail of terminal output Working on debian-buster in the till51 bibisect repository, I see that <Ctrl>+<Shift>+<F9> stopped recalculating B1 and save/reload became necessary somewhere in the 74 or so commits: commit s-h date -------- -------- ------------------- good b0072876 46564fd9 2015-06-15 00:07:25 bad 34b2392f 80ec99db 2015-06-15 21:49:07 The hard recalc became necessary somewhere in the the 42max repository. Is this of any interest? I am setting keyword bibisected.
Created attachment 149067 [details] column label function.ods this issue is not an issue about a problem with named ranges. average function uses column labels instead: Tools/Options.../LibreOffice Calc/Calculate [X] Automatically find column and row labels steps to reproduce with LO 6.1.5.2: - open attached "column label function.ods" - enter 400 in cell C7 - sum/average functions will update results - select row 4, context menu "Insert Row Above" (or row 3, context menu "Insert Row Below" - enter 50 in cell C4 - sum/average functions will *not* update results - CTRL+SHIFT+F9 (hard recalc) - sum/average functions will *not* update results - save and reload - sum/average functions will update results (if Tools/Options.../LibreOffice Calc/Formula "Recalculation on File Load" is activated otherwise use a hard recalc after reload) not problem at all with: - AOO 4.1.5 - LO Version 3.6.7.2 (Build ID: e183d5b) will update after hard recalc, no need to save and reload: - LO 4.4.7.2 needs a save and reload followed by a hard recalc: - LO 5.4.7.2 (x64) - LO 6.1.5.2 (x64) - LO 6.3.0.0.alpha0+ (x64) btw: Tools/Options.../LibreOffice Calc/General [ ] Expand references when new columns/rows are inserted seems to have no influence
(In reply to Oliver Brinzing from comment #10) > Created attachment 149067 [details] > column label function.ods > > this issue is not an issue about a problem with named ranges. > > average function uses column labels instead: > > Tools/Options.../LibreOffice Calc/Calculate > [X] Automatically find column and row labels > > steps to reproduce with LO 6.1.5.2: > - open attached "column label function.ods" > - enter 400 in cell C7 > - sum/average functions will update results > - select row 4, context menu "Insert Row Above" > (or row 3, context menu "Insert Row Below" > - enter 50 in cell C4 > - sum/average functions will *not* update results Bibisected with Linux 42max to https://git.libreoffice.org/core/+/ac645e88b91e95bc19ce7a8852fe45b0ec8780e7%5E!/ Extract this code into a local function.
Nice to see this post here and thanks for sharing this to us. GarageBand is a powerful audio recording and editing software for Mac. The garageband is a powerful mobile digital audio workstation for multitrack recording with impressive, on-board loops and production and editing. https://garagebandswindows.com
Comment on attachment 110518 [details] Readings table 4 cols: timestamp; 3 readings I adore your websites way of raising the awareness on your readers - <a href="https://minecraft-classic.com/">Minecraft Classic</a>
I have website read a few of the articles on your website now, and I really like your style of blogging - https://minecraft-classic.com/
Reproducible in master Version: 7.4.0.0.alpha0+ / LibreOffice Community Build ID: 3e9975cf507e24e9c501575c501833164d217acc CPU threads: 8; OS: Linux 5.13; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.UTF-8); UI: en-US Ubuntu_20.04_x86-64 Calc: threaded following steps from comment #1 CTRL+SHIFT+F9 does nothing but save ans reload update B1 Surprisingly, deleting the added row, updates B1. Best regards. JBF
Dear aaker, 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
Created attachment 192450 [details] verify Maybe misuse? (unexpected use?, not a bug?) Setting the named range as wizard will do to "$Tabelle1.$B$3:$B$6" (compare OP) and "Tools/Options/General/Expand references when new columns/rows are inserted" to "true" does it. Limits of named range are changing whenever row is added or removed at the limits of the range or somewhere else in the range and the value of the cell referencing the name of the range is updated immediately. Sorry for the trouble. Can be closed.