Created attachment 67656 [details] Test Excel document Calc and Excel treat multi-level categories slightly differently, which causes interoperability problems. In Excel, empty cell values are treated as continuation of the previous category value while repeating values are not. In Calc, either case is treated as continuation of the previous category value. The attached test document demonstrates this.
I'm taking this.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=8baaff5c798984b0fa7fe7a764491ca27765623e fdo#55298: We should only treat empty values as continuation of previous ones. 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.
Kohei Yoshida committed a patch related to this issue. It has been pushed to "libreoffice-3-6": http://cgit.freedesktop.org/libreoffice/core/commit/?id=f665c41f2dfeedeee34f2a7024432083ed809a18&g=libreoffice-3-6 fdo#55298: We should only treat empty values as continuation of previous ones. It will be available in LibreOffice 3.6.3. 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.