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 tree / graph
 
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
View All Add an attachment (proposed patch, testcase, etc.)

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