[Libreoffice-bugs] [Bug 118678] New: File don't open correctly when i use Subtotals and save it in ODS format FILESAVE/FILEOPEN

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=118678

            Bug ID: 118678
           Summary: File don't open correctly when i use Subtotals and
                    save it in ODS format FILESAVE/FILEOPEN
           Product: LibreOffice
           Version: 6.0.5.2 release
          Hardware: x86 (IA32)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: viadigital at gmail.com

Description:
I'm triying to use subtotals in a Calc document.
I have tried many times until i discovered that: when i save the file in ods
format y try to open it, the file don't show the information properly. the
colums appears ordered not properly.
Othrwise, if i save the same file in xls format, que file show perfectly.

Steps to Reproduce:
1.I have in a Calc sheet the table:
GRUPO 1 GRUPO 2 GRUPO 3 A       B       C       D       E
GRUPOA  GRUPOC  GRUPOG  1       1       1       1       1
GRUPOA  GRUPOC  GRUPOG  2       2       2       2       2
GRUPOA  GRUPOC  GRUPOG  3       3       3       3       3
GRUPOA  GRUPOC  GRUPOH  4       4       4       4       4
GRUPOA  GRUPOC  GRUPOH  5       5       5       5       5
GRUPOA  GRUPOD  GRUPOH  6       6       6       6       6
GRUPOA  GRUPOD  GRUPOI  7       7       7       7       7
GRUPOA  GRUPOD  GRUPOI  8       8       8       8       8
GRUPOA  GRUPOD  GRUPOI  9       9       9       9       9
GRUPOB  GRUPOD  HRUPOJ  10      10      10      10      10
GRUPOB  GRUPOE  GRUPOK  13      13      13      13      13
GRUPOB  GRUPOE  GRUPOK  14      14      14      14      14
GRUPOB  GRUPOE  GRUPOK  15      15      15      15      15
GRUPOB  GRUPOE  HRUPOJ  11      11      11      11      11
GRUPOB  GRUPOE  HRUPOJ  12      12      12      12      12
GRUPOB  GRUPOF  GRUPOL  16      16      16      16      16
GRUPOB  GRUPOF  GRUPOL  17      17      17      17      17
GRUPOB  GRUPOF  GRUPOL  18      18      18      18      18
GRUPOB  GRUPOF  GRUPOM  19      19      19      19      19
GRUPOB  GRUPOF  GRUPOM  20      20      20      20      20

2.I'm appliying subtotals to group "GRUPO 1", "GRUPO 2" and "GRUPO3" and
calculate subtotal (sum) for collumns A, B, C, D and E

3.When the subtotal was applied, save the file with format ODS (Libreoffice
Calc) and XLS (Microsoft Excel 97/2003) at the same time.

4. Close both files

5. Open both files, now you can see the diference. The ODS file shows the data
not properly, and the XLS shows them fine.

Actual Results:
The data in the columns are incorrectly ordered in the ODS file.

Expected Results:
The data has to show correctly using both extension ODS and XLS.


Reproducible: Always


User Profile Reset: No



Additional Info:

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180710/d16b2f95/attachment.html>