https://bugs.documentfoundation.org/show_bug.cgi?id=85538
--- Comment #9 from Paulo da Silva <[email protected]> --- In addition to being out of the standard of existing spreadsheets, which in itself is bad, changing external references from one sheet to another makes no sense and is useless except for some uses more or less esoteric. In years of heavy use of spreadsheets, employment and personal work, there are fundamentally the following situations to copy sheets: 1. To have a new sheet to make some changes or some experimental analysis; 2. To create a new view; 3. To build several (many) sheets with the original as a model. In all these cases the rules should be: 1. External references (references to other sheets) should be kept intact (unchanged); 2. The internal references (references to cells in the sheet being copied) should be changed to the new sheet (the one resulting from the copy). Ex.: Sheet SA being copied to SA_2: =Rec.A11 must be kept as =Rec.A11 =SA.F3:G12 must be changed to =SA_2.F3:G12 =F12 must be kept as =F12 Charts refs. included. *** In summary, the resulting sheet must have the same aspect and behaviour as its original. *** There is plenty of room for improvement, specially with new ideas, but do not alter the basic behaviour established over the years in spreadsheets. Mainly because it is the most intuitive. In case of doubt, try with other spreadsheets programs available, some online. Regards Paulo da Silva -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list [email protected] http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
