https://bugs.documentfoundation.org/show_bug.cgi?id=145414
Carl Pearson <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEEDINFO |UNCONFIRMED Ever confirmed|1 |0 --- Comment #3 from Carl Pearson <[email protected]> --- Hi, Heiko, thanks for reaching out. Yes, I have looked at Paste Special. Looks like Transpose has recently been added. One Windows machine I use has 7.1.2.2, and it's not there. My Mac machine has 7.3.5.2, and Transpose is present. In any event, in the original submission I'd really made just two suggestions: One regarding easier ways to get at the various options in the context menu's "Paste Special" section; the other, adding "Paste Column Widths" as a new choice. On the first suggestion, there are two issues: Not all "Paste Special" operations are available in Tools/Customize; also, it does not appear possible to set a sub-menu item. (Currently only "Paste Special" and "Styles" have sub-menus. If one can modify those sub-menu choices, I haven't seen how. There is an arrow in Tools/Customize presumably indicating the existence of the sub-menu, but no apparent way to see or modify what that sub-menu does. The sub-choices themselves appear to be hard-coded, and the only way to actually see them is to use the context menu.) At least so far as pasting goes, the first issue could be resolved by adding all of the "missing" Paste Special choices into Tools/Customize (Formats, Objects, etc.). Even if the second issue was not addressed, keyboard-centric folk could just make a shortcut, while those preferring the mouse would be able to add one of the currently missing choices as a top-level option to the context menu, though of course being able to modify the sub-menu would be the ideal solution. On the second suggestion, pasting column widths has been possible for many years in another spreadsheet app, and is very handy for copying the look & feel of one tab to another (that's why I also threw row heights in there, which to my knowledge does not exist in the other app). Either way, making the regular "Paste" command width-aware, or adding a specific "Paste Widths" choice, would work. If you need any other info, please let me know! -- You are receiving this mail because: You are the assignee for the bug.
