[Bug 1345546] Re: [Upstream] Dates in cell change randomly on load
** Changed in: libreoffice (Ubuntu) Status: New => Invalid -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1345546 Title: [Upstream] Dates in cell change randomly on load To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1345546]
(In reply to comment #12) [...] I'm now facing difficulties to reproduce this even on the machine that originally exhibited this behaviour (which does not always even have internet access). So I don't know how to debug this further. Ok, so closing again as NotABug. Please fell free to reopen if the problem comes back for you. Best regards. JBF -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1345546 Title: [Upstream] Dates in cell change randomly on load To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1345546] Re: [Upstream] Dates in cell change randomly on load
** Changed in: df-libreoffice Status: New = Invalid -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1345546 Title: [Upstream] Dates in cell change randomly on load To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1345546]
What I can reproduce on another machine is: 1. create a file (ods) with default date settings 2. close file 3. change date setting 4. open file and find a different date displayed. I don't understand why this is happening, because the content.xml says table:table-cell office:value-type=date office:date-value=2014-01-01 calcext:value-type=date text:p01.01.14/text:p /table:table-cell which is no relative date. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1345546 Title: [Upstream] Dates in cell change randomly on load To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1345546]
(In reply to comment #6) Created attachment 106048 [details] screencast showing the change of the date when changing the setting This is on yet another machine, running ubuntu mint 16 with a fresh profile. It shows that the displayed date changes too when changing the setting. it is libreoffice 4.1 Yes, where is the problem ? the origin date is saved in the file, if you change it, the dates change accordingly because each date is an amount of days from the origin date. Why do you want to change the origin date for an existing file ? Closing as NotABug. Please feel free to reopen if you have an argument against this explanation. Best regards. JBF -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1345546 Title: [Upstream] Dates in cell change randomly on load To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1345546]
1/ How do you change date setting if the file is closed ? 2/ where is random ? All changes are made by you, Calc does only what you asked him to do. 3/ the origin date is saved in the content.xml if it is not the standard origin date (1899.12.30). Open such a content.xml and search for null- date. 4/ when reading a file Calc converts dates to numbers (decimal) of days from the null-date. It converts back to dates when formatting and saving. Set status to NEEDINFO. Please set it back to UNCONFIRMED once you have provided requested informations. Thank you for your understanding. Best regards. JBF -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1345546 Title: [Upstream] Dates in cell change randomly on load To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1345546]
Further, I would expect that change to only affect ambiguous dates (in file formats that do not use four digit years, for example) - because what is the point in changing a date based on a program setting? Or maybe when actually doing some calculation, because this setting is in the calculate section. Further, one can only change this setting with a calc file open (otherwise the menu is missing) - so it will always affect a file. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1345546 Title: [Upstream] Dates in cell change randomly on load To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1345546]
1/ How do you change date setting if the file is closed ? I created (opened) a new file (not saved) and changed it then. The change shows up in user/registrymodifications.xcu . 2/ where is random ? All changes are made by you, Calc does only what you asked him to do. I originally did what I wrote in steps to reproduce. Originally, I first had a document created on another computer that showed up with wrong dates. Then I found that even documents created locally showed wrong dates. After changing the setting mentioned back to defaults, the issue was gone. But it could be reproduced by the steps mentioned in steps to reproduce. So I thought this was an unacceptable issue with libreoffice. I'm now facing difficulties to reproduce this even on the machine that originally exhibited this behaviour (which does not always even have internet access). So I don't know how to debug this further. Regardless of the original issue, I find it very strange as a user that changing that very setting changes the static! document content. I think this is not easy to see as a user (when going through menu) and does not only affect calculations as one could expect from menu structure. 3/ the origin date is saved in the content.xml if it is not the standard origin date (1899.12.30). Open such a content.xml and search for null- date. thanks for pointing that out. 4/ when reading a file Calc converts dates to numbers (decimal) of days from the null-date. It converts back to dates when formatting and saving. I think it would improve user experience when changing that setting would not alter static (non-calculated) content. Set status to NEEDINFO. Please set it back to UNCONFIRMED once you have provided requested informations. Thank you for your understanding. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1345546 Title: [Upstream] Dates in cell change randomly on load To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1345546] Re: [Upstream] Dates in cell change randomly on load
** Changed in: df-libreoffice Status: Incomplete = New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1345546 Title: [Upstream] Dates in cell change randomly on load To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1345546]
Created attachment 106048 screencast showing the change of the date when changing the setting This is on yet another machine, running ubuntu mint 16 with a fresh profile. It shows that the displayed date changes too when changing the setting. it is libreoffice 4.1 -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1345546 Title: [Upstream] Dates in cell change randomly on load To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1345546]
ok, please give me some time. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1345546 Title: [Upstream] Dates in cell change randomly on load To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1345546]
Created attachment 106050 screencast again showing libreoffice 4.3 this is on ubuntu mint again, the old libreoffice profile has been removed in advance, and a new libreoffice 4.3 version from libreoffice.org installed. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1345546 Title: [Upstream] Dates in cell change randomly on load To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1345546]
I cannot confirm: Bodhi Linux 2.x (built on Ubuntu 12.04) LibreOffice 4.3.1.2 release Please try the following: https://wiki.documentfoundation.org/UserProfile and try installing 4.3. With three QA members now committing time and not being able to reproduce - I'm afraid that this might be your computer environment causing something to happen and therefore WORKSFORME. That being said, for now throwing in NEEDINFO - try the above steps and if you still see the problem mark as UNCONFIRMED and we'll see where to go from there. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1345546 Title: dates in cell change randomly on load To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1345546] Re: dates in cell change randomly on load
** Changed in: df-libreoffice Status: New = Incomplete -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1345546 Title: dates in cell change randomly on load To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1345546] Re: [Upstream] Dates in cell change randomly on load
** Summary changed: - dates in cell change randomly on load + [Upstream] Dates in cell change randomly on load -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1345546 Title: [Upstream] Dates in cell change randomly on load To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1345546]
for me not reproducible with LO 4.3.0.4 (Win 8.1), therefore it is maybe an Ubuntu only issue in case it is reproducible Step 1: TOOLS - OPTIONS - LIBREOFFICE CALC - CALCULATE -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1345546 Title: dates in cell change randomly on load To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1345546]
Hi, I was not able to reproduce. Does it happen with all your files or only specific one? Could you provide the file that shows the error? Thanks - Sophie -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1345546 Title: dates in cell change randomly on load To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1345546]
It happened with a specific one copied from another computer but I was able to reproduce this creating a new one. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1345546 Title: dates in cell change randomly on load To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1345546] [NEW] dates in cell change randomly on load
Public bug reported: Problem description: Steps to reproduce: 0. This is on Ubuntu x86_64 in german local, I did not test others. 1. Set Settings - Libreoffice Calc - Berechnen (Calculation?) - Date = 1.1.1904 2. Create new spreadsheet 3. Enter 2.6.2014 in the cell (here: german date format, maybe 2014-06-02 in English) 4. Save file 5. Close file 6. Reopen file 7. Display file 8. save the file Current behavior: After step 4, 2014-06-02 is saved in content.xml in the ods file: table:table-cell office:value-type=date office:date-value=2014-06-02 calcext:value-type=date text:p02.06.14/text:p /table:table-cell But it step 7, it is display as 1.6.2010 (that is 2010-06-01) . After saving in step 8, content.xml contains: table:table-cell office:value-type=date office:date-value=2010-06-01 calcext:value-type=date text:p01.06.10/text:p /table:table-cell The current mode of operation breaks file display and corrupts the original file! Expected behavior: The date should not change, neither while displaying nor when saving the file. ProblemType: Bug DistroRelease: Ubuntu 14.04 Package: libreoffice-calc 1:4.2.4-0ubuntu2 Uname: Linux 3.15.0-031500rc7-generic x86_64 ApportVersion: 2.14.1-0ubuntu3.2 Architecture: amd64 CurrentDesktop: KDE Date: Sun Jul 20 12:58:26 2014 SourcePackage: libreoffice UpgradeStatus: Upgraded to trusty on 2014-06-18 (31 days ago) ** Affects: df-libreoffice Importance: Unknown Status: Unknown ** Affects: libreoffice (Ubuntu) Importance: Undecided Status: New ** Tags: amd64 apport-bug trusty ** Bug watch added: freedesktop.org Bugzilla #81560 https://bugs.freedesktop.org/show_bug.cgi?id=81560 ** Also affects: df-libreoffice via https://bugs.freedesktop.org/show_bug.cgi?id=81560 Importance: Unknown Status: Unknown -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1345546 Title: dates in cell change randomly on load To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1345546] Re: dates in cell change randomly on load
Launchpad has imported 1 comments from the remote bug at https://bugs.freedesktop.org/show_bug.cgi?id=81560. If you reply to an imported comment from within Launchpad, your comment will be sent to the remote bug automatically. Read more about Launchpad's inter-bugtracker facilities at https://help.launchpad.net/InterBugTracking. On 2014-07-20T10:47:59+00:00 AZ wrote: Problem description: Steps to reproduce: 0. This is on Ubuntu x86_64 in german local, I did not test others. 1. Set Settings - Libreoffice Calc - Berechnen (Calculation?) - Date = 1.1.1904 2. Create new spreadsheet 3. Enter 2.6.2014 in the cell (here: german date format, maybe 2014-06-02 in English) 4. Save file 5. Close file 6. Reopen file 7. Display file 8. save the file Current behavior: After step 4, 2014-06-02 is saved in content.xml in the ods file: table:table-cell office:value-type=date office:date-value=2014-06-02 calcext:value-type=date text:p02.06.14/text:p /table:table-cell But it step 7, it is display as 1.6.2010 (that is 2010-06-01) . After saving in step 8, content.xml contains: table:table-cell office:value-type=date office:date-value=2010-06-01 calcext:value-type=date text:p01.06.10/text:p /table:table-cell The current mode of operation breaks file display and corrupts the original file! Expected behavior: The date should not change, neither while displaying or when saving the file. Reply at: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1345546/comments/0 ** Changed in: df-libreoffice Status: Unknown = New ** Changed in: df-libreoffice Importance: Unknown = Medium -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1345546 Title: dates in cell change randomly on load To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/1345546/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs