https://bugs.freedesktop.org/show_bug.cgi?id=64647
Priority: medium
Bug ID: 64647
Assignee: [email protected]
Summary: EDITING: Loosing REF to related spreadsheet after
sorting
Severity: normal
Classification: Unclassified
OS: Mac OS X (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.0.3.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 79362
--> https://bugs.freedesktop.org/attachment.cgi?id=79362&action=edit
cells with "0" and the formula with broken relation
Problem description:
I read out values from another spreadsheets to sample and use then other
formulas.
When I sort the rows by information in certain columns other than the first
column I get e.g. "#REF" for some cells. These and some other cells show "0"
Using the first column a sort column not all the relations are broken or "0".
But this refuses to save and reopen zo get the right informations.
Steps to reproduce:
1. Produce 2 spreadsheets with relations
2. try to sort the "sampler" with formula for relations
Current behavior:
most of values get "0". Most of these cells show #REF n the formula
Expected behavior:
sorting by values in the cells
Operating System: Mac OS X
Version: 4.0.3.3 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs