https://bugs.freedesktop.org/show_bug.cgi?id=68566
Priority: medium Bug ID: 68566 Assignee: libreoffice-bugs@lists.freedesktop.org Summary: EDITING: Cross references between tables / cell data broken Severity: normal Classification: Unclassified OS: Mac OS X (All) Reporter: i...@michael-krueger.org Hardware: Other Whiteboard: BSA Status: UNCONFIRMED Version: 4.1.0.4 release Component: Spreadsheet Product: LibreOffice Created attachment 84641 --> https://bugs.freedesktop.org/attachment.cgi?id=84641&action=edit The file that is working with 4.0.4 and fails with 4.1.0 I have a spreadsheet created with Libreoffice 4.0.4 which includes a master table into which I enter a sort of address book, listing lastname, firstname, position, roles, phone numbers, email and postal addresses. I use an auto filter to be able to sort that table using the column headers. Within the same file I have sheets for a subset of the information of the master table. All is working perfect in 4.0.4 and when I upgraded to the 4.1.0 release the following issues came up and made me downgrade back to the 4.0.4 release: 1) If you enter an email address in one cell on the master sheet the email is recognized as URI and reformated as a mailto link. This was no issue in 4.0.4, but in 4.1.0 other sheets refering to this column using a formular like: =T(Master.J22) do no longer get me the text from the master table but generate an empty cell. Seems that if the master contains text only (no URI) the reference is working, if its converted to a URI the reference is broken, and all child sheets show empty cells instead of showing the email address. 2) If you use the master table to resort the address list, the information is not always updated on the child sheets. E.g on the master I have roles for some persons. These roles are e.g. chief, leader team 1, leader team2, clerk, etc. In 4.0.4 I was able to sort the table by role to have all assigned roles at the top of the table. The child sheets reflected this and content sorting order matched the master. In 4.1.0 the roles will show according the sorting order as well as in their original position they have been before the master was resorted using a different criteria. Hope this is clear. I attach the sample file used. I made the first two entries on the master sheet URLs again, and they show on the child sheet using 4.0.4 correctly, but are empty on 4.1.0. Using lastname / function sorting again the dependent sheets are working fine on 4.0.4 and fail on 4.1.0. Operating System: Mac OS X Version: 4.1.0.4 release -- You are receiving this mail because: You are the assignee for the bug.
_______________________________________________ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs