https://bugs.documentfoundation.org/show_bug.cgi?id=81135
--- Comment #17 from [email protected] --- (In reply to Yousuf (Jay) Philips from comment #16) > (In reply to klsu from comment #15) > So if i get you correctly, you want the standard paste that is available > through Ctrl+V and does so without text formatting, rather than doing > regular paste and then right-click 'Clear Formatting' and then reapplying > the cell number formats. I'm not sure you understand me. My concern is for copying and pasting from a range in a LibreOffice Calc spreadsheet to the same range (to convert all formulas to values) or to a different range (to copy all values, converting all formulas to values in the process). The problem is with the three options in the Paste Special dialog that applies to copying within a spreadsheet only: Text Numbers Date & time Unless they're all checked, they all delete the values in any cell of the type that is not checked. Paste means paste, not delete; and no-one has yet been able to give me a real world example of a valid use for such a paste operation. The only use I have ever had for pasting values is to convert formulas in a range to values or to copy all the values and formulas in a range to values in another range. There now a button for this at the top left of the Paste Special dialog. I don't understand why a button was added instead of just replacing those three items that aren't useful unless all three are checked, with one item (Paste Special > Values). It now appears to me that the button with the paste options you are asking about shouldn't be active if the range being copied is in a LibreOffice Calc spreadsheet (see comment below). When I copy and paste these three lines: This is a test 4526 8/12/15 ...from a LibreOffice Writer document to a Calc spreadsheet range formatted General, using the paste "Unformatted text" option, it copies the first line as text (left justified), the second line as a number (right justified and recognized as a number by a formula), and the third line as a number (recognized as a number by a formula) and formatted as text (but left justified instead of right justified as it would be if I had typed in the date in Calc - so I guess that's a minor bug). > > I'm not sure why the options in the button > > pull-down are nowhere in the "Edit" > "Paste Special..." dialog, but because > > of the [RTF] and the import dialog, I think these paste options are intended > > for copying from other documents into LibreOffice Calc. > > There are two paste special dialogs that open through Edit > Paste Special, > one which shows the same options as in the paste button in the toolbar and > the second that appears when you copy and paste text in calc. I see now that the second Paste Special dialog is displayed from the menu, only when I copy from an external document (e.g., LibreOffice Writer), not a range in a LibreOffice Calc spreadsheet. If that means the Paste Button with those other options is supposed to be only for pasting from an external document, shouldn't it be inactive when the range being copied is within a LibreOffice Calc document? -- 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
