[Libreoffice-bugs] [Bug 118678] Subtotals results moved left when saving in ODS format (steps in comment 12)

[bugzilla-daemon at bugs.documentfoundation.org]

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

b. <newbie-02 at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |newbie-02 at gmx.de

--- Comment #22 from b. <newbie-02 at gmx.de> ---
still in actual master (7.1 winx64 2020-08-05), 

is the following analysis correct? 

*.xlsx file works by 'direct adressing', see '"D9"' in following fragment, it's
the first subtotal which is 'shiftet left' when saving as *.ods, 

<c r="B9" s="1" t="s">
   <v>14</v>
</c>
<c r="C9" s="1"/>
<c r="D9" s="1" t="n">
   <f aca="false">SUBTOTAL(9,$D$2:$D$8)</f>
   <v>15</v>
</c>

while *.ods works with 'spacing cells' for 'whitespace', and would need one
more empty cell at the place where i'd add 
   "<table:table-cell/> missing here"
in the following fragment, it's the same part of data as above, 

<table:table-row table:style-name="ro1">
   <table:table-cell/>
   <table:table-cell office:value-type="string" calcext:value-type="string">
      <text:p>GRUPOC Result</text:p>
   </table:table-cell>
   "<table:table-cell/> missing here"
   <table:table-cell table:style-name="ce1"
table:formula="of:=SUBTOTAL(9;[.$D$2:.$D$8])" office:value-type="float"
office:value="15" calcext:value-type="float">
      <text:p>15</text:p>
   </table:table-cell>

-- 
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/20200808/51154af6/attachment.htm>