https://bugs.freedesktop.org/show_bug.cgi?id=71058
--- Comment #9 from Ralf <[email protected]> --- (In reply to comment #7) > Currently I see two options > 1. just set a request to change the behaviour: Selecting Transpose should > not affect the pasting of formulas. > 2. as the UX-list... > > Think what would happen if we change as in option 1.. > Would that rip users of the posibility of transposing without having > formulas untouched? > Of course the experienced user (and those using transposing are) could also > use an extra step in another sheet?? > Ideas? Unfortunately, I do not get the hang of these two options. But you ask for ideas, so let me give it a try. Option A (nice and clean): LO Calc produces the expected result, which is described in the bug request and illustrated in the attached ODS spreadsheet. Ideally bug 68976 is fixed as well. I consider bug 68976 to be more severe than this one. Option B (quick and dirty): If cells are cut and if the "Paste Special" menu is opened subsequently, the option "Transpose" is shaded grey in the "Paste Special" menu and cannot be selected like after copying cells. I don't know how quickly option B could be implemented, but it is not as dirty as it might appear at first sight for three reasons: a) The change or loss of data of bug 68976 is avoided. b) No functionality of LO Calc is lost. "Copy" and then "Paste Special" with option "Transpose" works properly. The current behaviour of "Cut" and then "Paste Special" with option "Transpose" does not add functionality. It confuses (see this bug) or even leads to data loss or change (see bug 68976). c) It does not fall back behind MS Excel 2007 (I don't know about other Excel versions). If you cut cells with MS Excel and if you want to paste with options afterwards, the option to transpose is shaded grey and cannot be selected. So option B would fix something without losing anything. However, it's not great like option A. Does option 1 or 2 coincide with option A or B? Maybe I miss the point. -- 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
