Created attachment 95716 [details] planilhas Excel Problem description: Bom dia. Usava apenas Microsoft e quando conheci o Libre office fiquei apaixonado pelo sistema. tenho um arquivo em XLSX que é lido Office Microsoft e Ashampoo. mas não abre no libre Office. Essa seria um melhoramento maravilhoso. Obrigado pela atenção. Att., Wolney Wolghan Operating System: Windows 7 Version: 4.2.1.1 release
Invalid. Language for bugtracker is english. Pleas re-open if you can translate the issue to english.
@Foss: Avoid dick-triaging, things such as Google Translate do exist. LibreOffice bugs in foreign languages should be first forwarded to a LibreOffice translator first, instead of being systematically closed. The LibreOffice project has people who speak different languages, why not ask for their help? Also, let's respect the time and effort this bug's reporter has spent. I'll try to use my very basic Portuguese here: ------------ "Good day, I've been using only Microsoft products, but I stumpled upon LibreOffice and I loved it. "I've got this XSLX file which opens in Excel and Ashampoo but Calc can't read it. "If Calc could open it, that would be an awesome improvement. "Thank you for your attention. Yours, ..."
Good day. My name is wolney. In my company we are replacing all Officce Microsoft. and are opting for Libre office. I did some testing and this has been the best. But we found a problem. We work with a system that generates files with extension xlsx (Excel 2007). When we opened the file in Excel, the Archiving opens normally, when we opened the Ashampoo (Plan Maker TRIAL 2012) also opens normally. But when we try to open it in Libre or Open office it does not run and error. Our company has over 60 pc and we are willing to replace all Officce 2007 by Libre. But this little problem can not let us do these migration. In some spreadsheet that contains specific calculations, saving to XLS or XLSX corrupts the planila formulas. hope you can help us. and hope that our observation make a contribution. Enjoyed the libre. I sent the attached two spreadsheets. Att, Wolney Wolghan - analyst T.I From: bugzilla-daemon@freedesktop.org Sent: Thursday, March 13, 2014 6:48 PM To: cpdtrac@tractorbel.com.br Subject: [Bug 76115] FILEOPEN: Calc can't read this particular spreadsheet Maxim Monastirsky changed bug 76115 What Removed Added Attachment #95716 [details] mime type application/kset application/vnd.openxmlformats-officedocument.spreadsheetml.sheet -------------------------------------------------------------------------------- You are receiving this mail because: a.. You reported the bug. --- Este email está limpo de vírus e malwares porque a proteção do avast! Antivírus está ativa. http://www.avast.com
On pc Debian x86-64 with master sources updated today, I could reproduce this. Unzipping the file, I noticed the encoding was UTF-8 for all of them except xl/sheet1 Just to be sure (because I know nothing about xlsx format), is it normal? Another thing, I uncompressed your file and a quick test file I made from LO. Here's the result. your file: ./xl ./xl/sheet1.xml ./xl/workbook.xml ./xl/styles.xml ./xl/_rels ./xl/_rels/workbook.xml.rels ./[Content_Types].xml ./_rels ./_rels/.rels the test file: ./xl ./xl/workbook.xml ./xl/styles.xml ./xl/_rels ./xl/_rels/workbook.xml.rels ./xl/worksheets ./xl/worksheets/sheet1.xml ./[Content_Types].xml ./_rels ./_rels/.rels ./docProps ./docProps/core.xml ./docProps/app.xml Could the structure difference explain the difficulties of LO?
tested under Win7x64. can't read test file with 4.1.5.3 and 4.0.6.2 as well. status NEW. platform ALL according to previous comment. changed version field.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (4.4.2 or later) https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-05-02
I still can't open that file with LibO 5.0.0.0.alpha1+ (x64) Build ID: 967b8c33225ae2aab5733639f0713a84cb1971da TinderBox: Win-x86_64@42, Branch:master, Time: 2015-04-25_04:11:40 Locale: it_IT
This issue is still reproducible in Version: 5.2.0.0.alpha0+ Build ID: 3dca8575d63db50b0120fbff09bbfcd056fa3732 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@39, Branch:master, Time: 2016-04-20_05:07:29 Locale: es-ES (es_ES)
The problem is that the zip has "\" instead of "/" as the separators.
We could make it possible to open this with https://gerrit.libreoffice.org/#/c/24278/
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.2.7 or 5.3.3 https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug-20170522
FILEOPEN still impossible with LibO 5.3.3.2 under Win7x64
Still present Version: 6.1.0.0.alpha0+ Build ID: 8e8dd8f320a3ff59ff8a16c1a7a867888ce80700 CPU threads: 2; OS: Mac OS X 10.12.6; UI render: default; TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2018-03-13_23:59:29 Locale: en-US (en_US.UTF-8); Calc: group
Repro 6.4+
*** Bug 143958 has been marked as a duplicate of this bug. ***
(In reply to Caolán McNamara from comment #9) > The problem is that the zip has "\" instead of "/" as the separators. This could be fixed via integrating even more powerful library to parse the zip format.
(In reply to Caolán McNamara from comment #10) The patch prepared by Colan was abandoned. As commented by Michael Stahl: "we will be able to create invalid zip files with this change". So, is this a wontfix, or is there any other ways? I have reported the issue as reported in https://bbs.libreofficechina.org/thread-2881-1-1.html to the upstream software (Kingdee ERP), hopefully they will address this and generate valid zip file not using backslash as file name separators. But I guess there are many other software who generate such invalid files.
One question is, how can we know whether the FILEOPEN failing is due to that the xlsx file is using "\" as separator, or due to other issues?
Well, I debugged and find that the test file reported in bug 143958 raised "ZipException: PK64 zip file entry /home/suokunlong/lo/source/core/package/source/zipapi/ZipFile.cxx:950" In ZipPackage::initialize https://opengrok.libreoffice.org/xref/core/package/source/zippackage/ZipPackage.cxx?r=d0a8d4a9#779 Thus bug 143958 should not be marked as a duplicate of this bug.
The easiest way to detect whether the filename path separator is "\" or "/", under linux, is: For a invalid zip file: $ zipinfo ./Planilha.xlsx Archive: ./Planilha.xlsx Zip file size: 37348 bytes, number of entries: 6 -rw---- 2.0 fat 716 b- defN 14-Mar-12 16:55 [Content_Types].xml -rw---- 2.0 fat 312 b- defN 14-Mar-12 16:55 _rels\.rels -rw---- 2.0 fat 448 b- defN 14-Mar-12 16:55 xl\_rels\workbook.xml.rels -rw---- 2.0 fat 6792 b- defN 14-Mar-12 16:55 xl\styles.xml -rw---- 2.0 fat 289 b- defN 14-Mar-12 16:55 xl\workbook.xml -rw---- 2.0 fat 327284 b- defN 14-Mar-12 16:55 xl\sheet1.xml 6 files, 335841 bytes uncompressed, 36676 bytes compressed: 89.1% And For a "valid" zip file, it would be: $ zipinfo ./LibreOffice_writer.xlsx Archive: ./LibreOffice_writer.xlsx Zip file size: 4978 bytes, number of entries: 9 -rw---- 5.1 fat 1111 bx defN 16-Mar-14 10:42 [Content_Types].xml -rw---- 5.1 fat 386 bx defN 16-Mar-14 10:42 docProps/app.xml -rw---- 5.1 fat 588 bx defN 16-Mar-14 10:42 docProps/core.xml -rw---- 5.1 fat 288 bx defN 16-Mar-14 10:42 xl/sharedStrings.xml -rw---- 5.1 fat 4971 bx defN 16-Mar-14 10:42 xl/styles.xml -rw---- 5.1 fat 883 bx defN 16-Mar-14 10:42 xl/workbook.xml -rw---- 5.1 fat 2198 bx defN 16-Mar-14 10:42 xl/worksheets/sheet1.xml -rw---- 5.1 fat 549 bx defN 16-Mar-14 10:42 xl/_rels/workbook.xml.rels -rw---- 5.1 fat 571 bx defN 16-Mar-14 10:42 _rels/.rels 9 files, 11545 bytes uncompressed, 3590 bytes compressed: 68.9%
*** Bug 131575 has been marked as a duplicate of this bug. ***
Dear wolney, To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from https://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://web.libera.chat/?settings=#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
still repro with Version: 7.6.2.1 (X86_64) / LibreOffice Community Build ID: 60(Build:1) CPU threads: 4; OS: Linux 6.2; UI render: default; VCL: gtk3 Locale: de-DE (de_DE.UTF-8); UI: de-DE Ubuntu package version: 4:7.6.2~rc1-0ubuntu0.22.04.1~lo1 Calc: threaded
https://gerrit.libreoffice.org/c/core/+/160757
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/27632654feda626131196c996e3f815f3602d248 tdf#76115: pass RepairPackage property from media descriptor to ZipStorage It will be available in 24.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/975bbafaae39f4dc5d9120b4347498b07e7e2426 Related: tdf#76115 Also pass RepairPackage to FilterDetect It will be available in 24.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Mike Kaganski committed a patch related to this issue. It has been pushed to "libreoffice-24-2": https://git.libreoffice.org/core/commit/8e393c141487acc0460037dbe5af1793d3663aef tdf#76115: pass RepairPackage property from media descriptor to ZipStorage It will be available in 24.2.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Mike Kaganski committed a patch related to this issue. It has been pushed to "libreoffice-24-2": https://git.libreoffice.org/core/commit/6ef97ac2bc1fb335943112374cf66103a4610cc3 Related: tdf#76115 Also pass RepairPackage to FilterDetect It will be available in 24.2.0.0.beta2. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Xisco Fauli committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/c9cbcd21edbde84d793a45295f9df7196d1893d8 tdf#76115: sc_subsequent_filters: Add unittest It will be available in 24.8.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.