Bug 44088 - Calc FILEOPEN: Problem with opening file xml 2003 with formula (formula is lost)
Summary: Calc FILEOPEN: Problem with opening file xml 2003 with formula (formula is lost)
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.3.4 release
Hardware: All All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: MSO-XML2003
  Show dependency treegraph
 
Reported: 2011-12-23 00:44 UTC by StirLiZ
Modified: 2018-04-01 16:18 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
xml 2003 file with error (8.11 KB, text/xml)
2011-12-23 00:44 UTC, StirLiZ
Details

Note You need to log in before you can comment on or make changes to this bug.
Description StirLiZ 2011-12-23 00:44:35 UTC
Created attachment 54739 [details]
xml 2003 file with error

The problem with the formulas in cells E7, F7. 156 and 157 lines of file.

error in row 156-157 xml file.
             <Cell ss:StyleID="S06" ss:Formula="=Sum(R[-3]C[0]:R[-1]C[0])" />
             <Cell ss:StyleID="S06" ss:Formula="=Sum(R[-3]C[0]:R[-1]C[0])" />

        <Style ss:ID="S06">
            <Font ss:FontName="Tahoma" ss:Size="11" ss:Color="#000000" />
            <Alignment ss:Vertical="Bottom" />
            <Borders>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" />
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" />
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" />
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" />
            </Borders>
        </Style>

if I add a new style "S07", and replace style one  of cells with formula, I can see result of calculation

        <Style ss:ID="S07">
            <Font ss:FontName="Tahoma" ss:Size="11" ss:Color="#000000" ss:Bold="1" />
            <Alignment ss:Vertical="Bottom" />
            <Borders>
                <Border ss:Position="Left" ss:LineStyle="Continuous" ss:Weight="1" />
                <Border ss:Position="Top" ss:LineStyle="Continuous" ss:Weight="1" />
                <Border ss:Position="Right" ss:LineStyle="Continuous" ss:Weight="1" />
                <Border ss:Position="Bottom" ss:LineStyle="Continuous" ss:Weight="1" />
            </Borders>
        </Style>


             <Cell ss:StyleID="S07" ss:Formula="=Sum(R[-3]C[0]:R[-1]C[0])" />
             <Cell ss:StyleID="S06" ss:Formula="=Sum(R[-3]C[0]:R[-1]C[0])" />
Comment 1 sasha.libreoffice 2012-05-02 08:32:12 UTC
Reproduced in 3.3.4 and 3.5.3 on Fedora 64 bit
in cell E7 should be =summ(E4:E6)
in cell F7 should be =summ(F4:F6)

Changing version to 3.3.4 as most early reproducible
Comment 2 Teo91 2013-09-29 18:13:28 UTC
I can confirm this with LO 4.1.1 on Windows 7 SP1:
- in cell E7 should be =summ(E4:E6)
- in cell F7 should be =summ(F4:F6)
Both formulas are lost.
Comment 3 QA Administrators 2015-04-01 14:42:24 UTC Comment hidden (obsolete)
Comment 4 Buovjaga 2015-04-24 16:25:08 UTC
(In reply to Teo91 from comment #2)
> I can confirm this with LO 4.1.1 on Windows 7 SP1:
> - in cell E7 should be =summ(E4:E6)
> - in cell F7 should be =summ(F4:F6)
> Both formulas are lost.

Still missing.

Win 7 Pro 64-bit Version: 5.0.0.0.alpha1+ (x64)
Build ID: f3375fa07f27bd2ade519af3c07d69040d10eaa9
TinderBox: Win-x86_64@42, Branch:master, Time: 2015-04-22_23:38:50
Locale: fi_FI
Comment 5 QA Administrators 2016-09-20 09:33:20 UTC Comment hidden (obsolete)
Comment 6 eisa01 2018-04-01 16:18:15 UTC
This has been fixed

Version: 6.1.0.0.alpha0+
Build ID: a488c7ad2763b944713997911c1ddb0315d8c93f
CPU threads: 2; OS: Mac OS X 10.12.6; UI render: default; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2018-03-26_00:38:29
Locale: en-US (en_US.UTF-8); Calc: group