https://bugs.freedesktop.org/show_bug.cgi?id=42607
--- Comment #5 from Mike Finch <[email protected]> 2011-11-07 18:08:07 PST --- Rainer : I appreciate your effort in composing your detailed reply When I referred to DD-MM-YYYY format I should have said DD-MMM-YY. Sorry. In your email you seem to be dealing with two spreadsheets IN ISOLATION. I meant copying from ONE TO THE OTHER! I've just tried this (in 3.4.3) and am absolutely astonished : the first try gave no change, the second WENT BACK one day!!! Neither advanced one day!?!? I'm all at sea now! There seems to be inconsistency going on[?]. If I right click on a date : Format cells... : Numbers : Date, there seem to be a different number of options in the list than choosing a blank cell (in a blank spreadsheet). Anyway I'm downright confused now. Could you please have a go at copy/pasting between different spreadsheets and see how you go? Also what prompted me to use bugzilla was the very weird sensation of seeing the year advanced by four - into the future; it so happens that I'd frozen the column(s) containing the dates (two columns at the LHS). This is another problem that needs a solution. If you concur that there is weirdness going on then I will make an effort to put in a formal submission. [email protected] wrote: > https://bugs.freedesktop.org/show_bug.cgi?id=42607 > > Korrawit Pruegsanusak<[email protected]> changed: > > What |Removed |Added > ---------------------------------------------------------------------------- > CC| |detective.conan.1412@gmail. > | |com > > --- Comment #4 from Korrawit Pruegsanusak<[email protected]> > 2011-11-07 01:03:29 UTC --- > Also [NOT RERPODUCIBLE] LibreOffice 3.4.3 Ubuntu 11.10 en_US > > This is my test steps: > A. Default Formatting: > 1. Open new calc document > 2. In A1, enter "4/29/11" without quote and hit enter. It will be shown as > "04/29/11" > 3. In A1, Ctrl+C or right-click and select Copy > 4. In A2, Ctrl+V or right-click and select Paste > 5. Notice that cell A2 contains "04/29/11", identical to A1, which is expected > > B. Custom Formatting: > 1. Open new calc document > 2. right-click and select "Format Cells..." > 3. Select "Date" > 4. Enter "Format code" as "D-MMM-YYYY", then OK > 5. In A1, enter "4/29/11" without quote and hit enter. It will be shown as > "29-Apr-2011" > 6. In A1, Ctrl+C or right-click and select Copy > 7. In A2, Ctrl+V or right-click and select Paste > 8. Notice that cell A2 contains "29-Apr-2011", identical to A1, which is > expected > > Mike, please report your steps that produce the issue like mine. Also, some > screenshots/screencast (video clip) is appreciated. Thanks. > -- Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email ------- 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
