Bug 44088

Summary:	Calc FILEOPEN: Problem with opening file xml 2003 with formula (formula is lost)
Product:	LibreOffice	Reporter:	StirLiZ <kit2>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEW ---	QA Contact:
Severity:	major
Priority:	medium	CC:	sasha.libreoffice
Version:	3.3.4 release
Hardware:	All
OS:	All
Whiteboard:
i915 platform:		i915 features:
Attachments:	xml 2003 file with error

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.

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.