| Summary: | FILEOPEN: xlsb: missing formula based cells | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Angel Inkov <ainkov> |
| Component: | Spreadsheet | Assignee: | Markus Mohrhard <markus.mohrhard> |
| Status: | RESOLVED FIXED | QA Contact: | |
| Severity: | normal | ||
| Priority: | medium | Keywords: | regression |
| Version: | 4.2.6.3 release | ||
| Hardware: | x86 (IA32) | ||
| OS: | All | ||
| Whiteboard: | target:4.5.0 target:4.4.0.2 target:4.3.6 | ||
| i915 platform: | i915 features: | ||
| Attachments: | Sample xlsb file with failed formulas | ||
Confirmed with v4.3.4.1 under windows7 x64. Confirmed with v4.3.4.1 under mint 17 x64. Unconfirmed with v4.1.6.2 under mint 16 x64. Works fine with the 4.1 branch, not with the 4.2 branch or higher. Set to ALL, regression. That affects all shared formulas (formula groups in calc). Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=e1351ed4c5f9152c80b32bbaa53e3eff56671331 reimplement shared formula import for xlsb, fdo#86734 It will be available in 4.5.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Markus Mohrhard committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=4bc2212a048cde9fc17728eaad4d8637468c1586 add test for fdo#86734 It will be available in 4.5.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-4-4": http://cgit.freedesktop.org/libreoffice/core/commit/?id=98aae6bbf45e96267489198db5a9e5c8631d06dd&h=libreoffice-4-4 reimplement shared formula import for xlsb, fdo#86734 It will be available in 4.4.0.2. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. Markus Mohrhard committed a patch related to this issue. It has been pushed to "libreoffice-4-3": http://cgit.freedesktop.org/libreoffice/core/commit/?id=c931268890fdd0e9aec1bdab939495f299e11011&h=libreoffice-4-3 reimplement shared formula import for xlsb, fdo#86734 It will be available in 4.3.6. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback. |
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 110051 [details] Sample xlsb file with failed formulas Hi all, When I open the attached xlsb file, the cells which are defined as formula are missing. (These are in columns E, F and G in the attached file). When I open the same xlsb file in Microsoft Excel, it's ok. I tried several versions of Libreoffice (4.2.7, 4.3.4, 4.4.0 beta1 and the latest nightly build) but it's all the same. Thanks.