https://bugs.freedesktop.org/show_bug.cgi?id=81346
--- Comment #2 from Aprax <[email protected]> --- Of course you're correct Kevin but: "Paste Only" does not provide the combination of 'number and format', which is what I'm after. I suggest that you try the following: 1) create two columns and format them as Time. 2) key a time value into a cell in one column, it should look like a Time value. 3) copy the Time value that you just keyed and then use "Paste Only - Numbers" to paste the value into a cell in the second column. The result is blank, nothing was pasted. The format of the cell is still Time. Paste didn't paste. Text doesn't work either. You have to use Paste Special - Date & time BUT WITHOUT the Formats option ticked. If the Formats option is ticked then Conditional Formatting Rules are fragmented and this gets very messy very quickly. My point is that when someone decided to provide an enhancement called "Paste Only" then they should have included "Date & Time" as a fourth option, not limit it to just Text, Number and Formula. J -- 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
