[Bug 1399951] Re: LibreOffice Calc removes sheet names from calculations when saving
[Expired for libreoffice (Ubuntu) because there has been no activity for 60 days.] ** Changed in: libreoffice (Ubuntu) Status: Incomplete => Expired -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1399951 Title: LibreOffice Calc removes sheet names from calculations when saving To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1399951/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1399951] Re: LibreOffice Calc removes sheet names from calculations when saving
Daniel Burton, thank you for reporting this and helping make Ubuntu better. First, I want to ensure the following isn't being tripped on here https://help.libreoffice.org/Calc/Addresses_and_References,_Absolute_and_Relative . If this isn't, could you please test one of the 5.x PPAs via https://launchpad.net/~libreoffice and advise if this is still reproducible? If so, please post as a comment the precise line item of the cell prior to when when the document is saved, closed, and reopened demonstrates this problem. ** Changed in: libreoffice (Ubuntu) Importance: Undecided => Low ** Changed in: libreoffice (Ubuntu) Status: Confirmed => Incomplete -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1399951 Title: LibreOffice Calc removes sheet names from calculations when saving To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1399951/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1399951] Re: LibreOffice Calc removes sheet names from calculations when saving
I'm pretty sure that the sheet name needs to be enclosed in single quotes. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1399951 Title: LibreOffice Calc removes sheet names from calculations when saving To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1399951/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1399951] Re: LibreOffice Calc removes sheet names from calculations when saving
Status changed to 'Confirmed' because the bug affects multiple users. ** Changed in: libreoffice (Ubuntu) Status: New = Confirmed -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1399951 Title: LibreOffice Calc removes sheet names from calculations when saving To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1399951/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1399951] Re: LibreOffice Calc removes sheet names from calculations when saving
I am facing the same issue, on 2 separate files. Calc keeps removing the sheet names from the formulas even before saving sometimes, but after switching from sheet to sheet. I am happy to share the files if required. -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1399951 Title: LibreOffice Calc removes sheet names from calculations when saving To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1399951/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
[Bug 1399951] Re: LibreOffice Calc removes sheet names from calculations when saving
Attached is my spreadsheet. The issue is on the first sheet, Columns BZ to CG. I have previous saved versions in this document, and in the most recent one, these calculations are correct, so you can see what they are supposed to look like. Oddly, when I compare to the last saved revision, the changes in these calculations do not show up. ** Attachment added: City Comparison.ods https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1399951/+attachment/4275322/+files/City%20Comparison.ods -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1399951 Title: LibreOffice Calc removes sheet names from calculations when saving To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/libreoffice/+bug/1399951/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs