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

Reply via email to