[Libreoffice-bugs] [Bug 118678] Data don't show correctly when i use Subtotals and save it in ODS format

[bugzilla-daemon at bugs.documentfoundation.org]

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

Marcelo <viadigital at gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
     Ever confirmed|1                           |0
             Status|NEEDINFO                    |UNCONFIRMED

--- Comment #12 from Marcelo <viadigital at gmail.com> ---
I believe that: The gaps doesn't appear because you are appliying subtotals
from the supplied xls file and save it into ods format.
In that case. I neither get the gaps.

I try to explain a more detailed step by step:

 -Open a new, clean libreoffice Calc document.

 -Insert this data:
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

 - data-Subtotals
     select Group by: Grupo 1
     select A,B,C,D,E and select SUM
     OK
 - data-Subtotals
     select Group by: Grupo 2
     select A,B,C,D,E and select SUM
     OK
 - data-Subtotals
     select Group by: Grupo 2
     select A,B,C,D,E and select SUM
     OK

 - Save in .ods format
 - Close the file.
 - Open the file. Rith here i see the gaps...!!


If i repeat the whole process but i save the file in xls format, the gaps
doesn't appears.

Thanks guys! and  sorry for my bad english.

-- 
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/20180801/1d309890/attachment.html>