[Libreoffice-bugs] [Bug 52529] New: PIVOTTABLE: bad sort on formulas results

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=52529

             Bug #: 52529
           Summary: PIVOTTABLE: bad sort on formulas results
    Classification: Unclassified
           Product: LibreOffice
           Version: 3.5.4 release
          Platform: Other
        OS/Version: All
            Status: UNCONFIRMED
 Status Whiteboard: BSA
          Severity: normal
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: p.lejarre at free.fr


Problem description: 

Steps to reproduce:
1. Insert "=alea()*99 + 1 in A1:A10 
2. insert ten names, for exemples patrick, marc, jacqueline,  jean, alain 
3. do données/trier/colonne A

Current behavior:
1- when automatic calcul enabled, the ten alea numbers  A1:A10 are modified. 
2- when manual calc, the ten A1:A10 are not correctly sorted 
Expected behavior:

if possible do not refesh the alea functions on menu "données/trier" 
sort correctly the aléa number when automatic calc is disabled...  

exemple 

column A | column B
=alea()*99+1 gives 663,35198932 | marc 
=alea()*99+1 gives 48,377773371 | justine 
....
=alea()*99+1 gives 56,494387401 | andré


after "données / trier"


63,35198932    eric 
48,3777733715    audrey
89,5887611583    patrick
65,8924716595    remy
40,936540226    justine***
6,4223370268    andré***
39,4029091988    marc***
23,4476218726    alain 
56,4943874008    jean paul

it "works"  with all formulas in sorted columns. Such as 
=janvier:C10 
=fevrier:C10
...
=decembre:C10

to have a correct result on "données/trier" I must do a copy paste of the
calculated values and do "données trier" on the pasted values. So the sort is
normal.  

y vould like to randomly sort names for compétitions. for exemple 


marc 
justine
...
andré 

with randomized numbers. 



Platform (if different from the browser): 
the bug "works" even on windows 7 sp1

Browser: Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:14.0) Gecko/20100101
Firefox/14.0.1

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.