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
