https://bugs.documentfoundation.org/show_bug.cgi?id=169930
--- Comment #9 from JF <[email protected]> --- (In reply to ady from comment #7) > (In reply to JF from comment #3) > > > Doing so, will fix Problem. > > The STR in attachment 204569 [details] are not that easy to follow as you > might think. > > I would suggest trying to describe the steps in some easier format. Instead > of describing what you already did and mentioning all sorts of "sheetN_M", I > would suggest something like: > > 0. Starting from this (simple basic clear case in some simple basic > attachment)... > 1. Select "sheetL", "sheetM", "sheetN"... > 2. Right click one of the selected tabs. > 3. Perform x, y, z. > > Actual result: > In "sheetU, cell R1", the resulting formula is... > > Expected result: > In "sheetU, cell R1", the expected formula should be... > > > > Having said that, using relative worksheet addresses, there can be 2 > different expected outcomes when selecting multiple worksheets to copy. Some > users would expect the current behavior, and others would expect a different > one. I am not sure that there is a way to decide that one behavior is "more > adequate" than the other; it all depends on the desired outcome. Adv, You are absolutely right that my explanations is, to say the least, confusing. I have uploaded a new version of my spreadsheet (version 2) with a new sheet ("Sheet 9") that tries to better explain the issue. To your point about having two different behaviour, I don't think there is an issue with the expected outcome of the copy for a user. As you can see in the "sheet 9" of the version 2 of my spreadsheet that I have just uploaded, I don't think a user would expect anything else then the result of Step #3 (equivalent to copying all selected sheets as a whole). If a user wanted to have the result of the copy like "Step #4" in my spreadsheet, the user would just follow the steps, like I did, in "Step #4" (copy one sheet, or one line, at the time). So, in my humble opinion, just like copying cell in a sheet, the default behaviour should only be like "Step #3" and not “Step #4. What do you think? JF -- You are receiving this mail because: You are the assignee for the bug.
