Description: since 6.3 alpha xxx, observed in alpha1, the 'expanding' of ranges referenced in formulae / formulas is somewhat changed. abstract description: in older versions - i used 4.1.6 to check - the referenced range was 'kept' and if necessary moved unless the insertion was completely inside it's borders (either horizontal or vertical). with insertions 'inside' the referencing ranges it became expanded. now (in some cases?) the ranges are already expanded if the areas of range and insertion share some space (cutting each other). sample: open attachment in next comment, check the range referenced in B2, mark the yellow range and insert rows above, check the range in the cell moved from B2 to B5, it's expanded above the cell with the formula. this behaviour is a little irritating and thus of reduced 'usability' for 'simple minded users' like me. i doubt if it's changed on purpose, if i'd like to know why. reg. b. Steps to Reproduce: see above description Actual Results: see above description Expected Results: see above description Reproducible: Always User Profile Reset: No Additional Info: Version: 6.3.0.0.alpha1+ (x64) Build ID: e92dcfdc7bd7b237e0bee26ff226a102d9e8e766 CPU threads: 8; OS: Windows 6.1; UI render: default; VCL: win; TinderBox: Win-x86_64@42, Branch:master, Time: 2019-05-14_00:00:57 Locale: de-DE (de_DE); UI-Language: en-US Calc: *unthreaded*
Created attachment 151432 [details] expanded_expansion_of_referenced_ranges a file to demonstrate the expanding of a referenced range in a situation where the user most likely want's it moved instead of expanded (as it was in former versions).
(In reply to b. from comment #0) > sample: open attachment in next comment, check the range referenced in B2, > mark the yellow range and insert rows above, check the range in the cell > moved from B2 to B5, it's expanded above the cell with the formula. Do you use same settings, e.g.: Tools/Options/LibreOfficeDEv Calc/General [ ] Expand references when new columns/rows are inserted Can you please add some screenshots/screencast to demonstrate?
@Oliver: thanks, that made it, Tools/Options/LibreOfficeDEv Calc/General [ ] Expand references when new columns/rows are inserted was checked in 6.3 and unchecked in 4.1, the wording for the option is somewhat cruel, a simple mind would think it governs whether expansion takes place at all (when inserting 'into' the range), but that's 'always on', the option makes the difference for overlapping areas. i'm not sure if there are useful cases where you need to turn insertion of in total, for a complete handling two options would be necessary, one turn on/of for insertion - inside - ranges, and one tuen on/of for insertion - touching - ranges, i think an option for expanding 'untouched' ranges can be omitted, notabug