| Summary: | [XLSX] Function SUMIFS isn't correctly imported | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Teo91 <mcavalleri91> |
| Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED NOTOURBUG | QA Contact: | |
| Severity: | normal | ||
| Priority: | medium | CC: | mariosv, mcavalleri91, raal |
| Version: | 4.3.4.1 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| i915 platform: | i915 features: | ||
| Attachments: | XLSX with SUMIFS function not imported (cell C10) | ||
Hi @Teo91, thanks for reporting. Seems the issue is already in the file. <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <worksheet xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"><dimension ref="A1:D10"/><sheetViews><sheetView tabSelected="1" workbookViewId="0"><selection activeCell="B11" sqref="B11"/></sheetView></sheetViews><sheetFormatPr defaultRowHeight="14.25"/><cols><col min="1" max="1" customWidth="1" width="14.746094" style="1"/><col min="2" max="2" customWidth="1" width="14.996094" style="2"/><col min="3" max="3" customWidth="1" width="8.886719" style="3"/><col min="257" max="16384" width="9" style="0" hidden="0"/></cols><sheetData><row r="1" spans="8:8" ht="15.0"><c r="A1" s="1" t="s"><v>0</v></c><c r="B1" s="2" t="s"><v>1</v></c><c r="C1" s="3" t="s"><v>2</v></c></row><row r="2" spans="8:8" ht="15.0"><c r="A2" s="1"><v>41974.0</v></c><c r="B2" s="2" t="s"><v>3</v></c><c r="C2" s="3"><v>10.0</v></c></row><row r="3" spans="8:8" ht="15.0"><c r="A3" s="1"><v>41944.0</v></c><c r="B3" s="2" t="s"><v>4</v></c><c r="C3" s="3"><v>12.0</v></c></row><row r="4" spans="8:8" ht="15.0"><c r="A4" s="1"><v>41609.0</v></c><c r="B4" s="2" t="s"><v>5</v></c><c r="C4" s="3"><v>20.0</v></c></row><row r="5" spans="8:8" ht="15.0"><c r="A5" s="1"><v>41579.0</v></c><c r="B5" s="2" t="s"><v>6</v></c><c r="C5" s="3"><v>22.0</v></c></row><row r="6" spans="8:8" ht="15.0"><c r="A6" s="1"><v>41944.0</v></c><c r="B6" s="2" t="s"><v>7</v></c><c r="C6" s="3"><v>21.0</v></c></row><row r="7" spans="8:8" ht="15.0"><c r="A7" s="1"><v>41609.0</v></c><c r="B7" s="2" t="s"><v>8</v></c><c r="C7" s="3"><v>20.0</v></c></row><row r="10" spans="8:8" ht="15.0"><c r="A10" s="1"> <v>41974.0</v></c><c r="B10" s="2" t="s"><v>10</v></c><c r="C10" s="3"><f>_xlfn.SUMIFS(C2:C7,A2:A7,A10,B2:B7,B10) </f><v>10.0</v></c></row></sheetData><pageMargins left="0.7" right="0.7" top="0.75" bottom="0.75" header="0.3" footer="0.3"/><pageSetup paperSize="0" scale="285" orientation="landscape" copies="116"/></worksheet> Modifying the cell, saving and reopening works fine for me with 4.3.4.1 and 4.3.5.1 I can open with excel 2010 without problem. When I resave file in excel 2010 I can see correct formula SUMIFS in LO 4.3.4 How the file is created? I see <Application>WPS Office</Application> in xlxs file. Thanks anyone for the help! The .xlsx file was created using WPS Kingsoft Office mobile app. The bug is clearly on their side, so I'll close this report as RESOLVED NOTOURBUG. |
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.
Created attachment 110321 [details] XLSX with SUMIFS function not imported (cell C10) Problem description: Function SUMIFS in the attached .xlsx is imported as "_xlfn.sumifs" Steps to reproduce: 1. open the .xlsx attached 2. go to cell C10 3. function name is =_xlfn.sumifs(C2:C7;A2:A7;A10;B2:B7;B10) Current behavior: SUMIFS function from Excel spreadsheet is imported as "_xlfn.sumifs" Expected behavior: SUMIFS function should be imported correctly as SUMIFS.