[Libreoffice-bugs] [Bug 141472] UK format dates reduced by 4 years and 1 day when copied/moved to different spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=141472 Bob Bruynooghe changed: What|Removed |Added Resolution|--- |NOTABUG Status|UNCONFIRMED |RESOLVED --- Comment #6 from Bob Bruynooghe --- Thanks. Problem solved. I have marked it as Resolved/Not a bug. I hope that is the correct thing to have done. Bob -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141472] UK format dates reduced by 4 years and 1 day when copied/moved to different spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=141472 Aron Budea changed: What|Removed |Added Product|LibreOffice Online |LibreOffice Component|Calc|Calc Version|unspecified |6.4.6.2 release -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141472] UK format dates reduced by 4 years and 1 day when copied/moved to different spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=141472 laurent combe changed: What|Removed |Added OS|Mac OS X (All) |All -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141472] UK format dates reduced by 4 years and 1 day when copied/moved to different spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=141472 --- Comment #5 from laurent combe --- in the original spreadsheet there is a specific option for date go to the option menu (click on incon in the upper right corner) in the menu, choose 'options ...', 'LibreOffice Calc' and 'calculate' in this popup you have a section Date with 3 choices in the Original Spreadsheet the '01/01/1904' option is selected when you copy your data to another spreadsheet with the default option (12/30/1899) your date appeared to be different with 4 years less -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141472] UK format dates reduced by 4 years and 1 day when copied/moved to different spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=141472 --- Comment #4 from Bob Bruynooghe --- The version of LibreOffice is Version: 6.4.6.2 Build ID: 0ce51a4fd21bff07a5c061082cc82c5ed232f115 CPU threads: 4; OS: Mac OS X 10.16; UI render: default; VCL: osx; Locale: en-GB (en_GB.UTF-8); UI-Language: en-US Calc: threaded (Finder says it is 6.4.6002) I have uploaded 2 spreadsheet files: the first is a duplicate of the file with which I had the original problem but with its contents much reduced and the second is the file into which the 2 sheet from the first file have been copied. I did the copy using the menu from the right hand mouse button on hovering over the sheet name. The first column in both sheets contains dates and it is these dates have been changed in the copying process. For example the first date in the Laura Ashley sheet is 12/11/2009 in the original spreadsheet and after copying it has become 11/11/2005. regards Bob -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141472] UK format dates reduced by 4 years and 1 day when copied/moved to different spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=141472 --- Comment #3 from Bob Bruynooghe --- Created attachment 170945 --> https://bugs.documentfoundation.org/attachment.cgi?id=170945=edit Spreadsheet into which 2 sheets have been copied -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141472] UK format dates reduced by 4 years and 1 day when copied/moved to different spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=141472 --- Comment #2 from Bob Bruynooghe --- Created attachment 170944 --> https://bugs.documentfoundation.org/attachment.cgi?id=170944=edit Original spreadsheet containing 2 sheets -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 141472] UK format dates reduced by 4 years and 1 day when copied/moved to different spreadsheet
https://bugs.documentfoundation.org/show_bug.cgi?id=141472 Aron Budea changed: What|Removed |Added CC||ba...@caesar.elte.hu --- Comment #1 from Aron Budea --- What is the version you are using, and could you upload a sample spreadsheet with direct reproduction steps? -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs