https://bugs.documentfoundation.org/show_bug.cgi?id=172349
--- Comment #6 from ady <[email protected]> --- Basically what you say is that you don't want to use absolute references. If the merged range is A10:A15, your dependent cells / formulas should not use "A10" as reference, but "A$10", so when copying the formula down the resulting formulas will still point to the only real value. If the merged range is A10:E10, then use "$A10" as reference in dependent formulas. Similarly, if the merged range is A10:E15, then the dependent formulas should use "$A$10". I'll ask again... Is there any spreadsheet tool that implements the optional behavior that you are requesting (i.e. automatically fill the "rectangular tail" of the merged area with a formula that points to the "home" cell of the merged area, if the whole "tail" has no content when merging)? -- You are receiving this mail because: You are the assignee for the bug.
