Download it now!
Bug 129940 - FILEOPEN: Cell content in ODS exported by Excel with Asian phonetic guide ​​is displayed as empty
Summary: FILEOPEN: Cell content in ODS exported by Excel with Asian phonetic guide ​​i...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, regression
: 130750 (view as bug list)
Depends on:
Blocks: Ruby CJK CJK-Japanese
  Show dependency treegraph
 
Reported: 2020-01-11 08:24 UTC by Naruhiko Ogasawara
Modified: 2020-02-18 06:05 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
ODS file exported by Excel, with Asian phonetic guides (3.19 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-01-11 08:24 UTC, Naruhiko Ogasawara
Details
Modified ODS file, take text:ruby tag out from the cell content (3.40 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-01-11 08:27 UTC, Naruhiko Ogasawara
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Naruhiko Ogasawara 2020-01-11 08:24:15 UTC
Created attachment 157073 [details]
ODS file exported by Excel, with Asian phonetic guides

Cell content in ODS exported by Excel with Asian phonetic guides ​​is displayed as empty.

Step to reproduce:

1. Open attached ODS file (BookByExcel.ods)
2. See the content

Expected:

Can see the content "小笠原" "徳彦"

Actual:

No content displayed
Comment 1 Naruhiko Ogasawara 2020-01-11 08:25:25 UTC
The "content.xml" in the ODS seems:

  <office:body>
    <office:spreadsheet>
      <table:calculation-settings table:case-sensitive="false" table:search-criteria-must-apply-to-whole-cell="true" table:use-wildcards="true" table:use-regular-expressions="false" table:automatic-find-labels="false"/>
      <table:table table:name="Sheet1" table:style-name="ta1">
        <table:table-column table:style-name="co1" table:number-columns-repeated="16384" table:default-cell-style-name="ce1"/>
        <table:table-row table:style-name="ro1">
          <table:table-cell office:value-type="string" table:style-name="ce1">
            <text:p>
              <text:ruby text:style-name="ru1">
                <text:ruby-base>小笠原</text:ruby-base>
                <text:ruby-text text:style-name="T1">オガサワラ </text:ruby-text>
              </text:ruby>
            </text:p>
          </table:table-cell>
          <table:table-cell office:value-type="string" table:style-name="ce1">
            <text:p>
              <text:ruby text:style-name="ru1">
                <text:ruby-base>徳彦</text:ruby-base>
                <text:ruby-text text:style-name="T1">ナルヒコ </text:ruby-text>
              </text:ruby>
            </text:p>
          </table:table-cell>
          <table:table-cell table:number-columns-repeated="16382"/>
        </table:table-row>
        <table:table-row table:number-rows-repeated="1048575" table:style-name="ro1">
          <table:table-cell table:number-columns-repeated="16384"/>
        </table:table-row>
      </table:table>
    </office:spreadsheet>
  </office:body>

And with modification of the ODS as follows (attached BookByExcel-modified.ods), I can see the cell content "小笠原":

  <office:body>
    <office:spreadsheet>
      <table:calculation-settings table:case-sensitive="false" table:search-criteria-must-apply-to-whole-cell="true" table:use-wildcards="true" table:use-regular-expressions="false" table:automatic-find-labels="false"/>
      <table:table table:name="Sheet1" table:style-name="ta1">
        <table:table-column table:style-name="co1" table:number-columns-repeated="16384" table:default-cell-style-name="ce1"/>
        <table:table-row table:style-name="ro1">
          <table:table-cell office:value-type="string" table:style-name="ce1">
            <text:p>小笠原</text:p>
          </table:table-cell>
          (...snip...)
        </table:table-row>
      </table:table>
    </office:spreadsheet>
  </office:body>

So I guess the problem is Calc can't handle <text:ruby> tag inside <table:table-cell> tag well.
Comment 2 Naruhiko Ogasawara 2020-01-11 08:27:19 UTC
Created attachment 157074 [details]
Modified ODS file, take text:ruby tag out from the cell content
Comment 3 Ming Hua 2020-01-13 18:34:01 UTC
I can reproduce the reported behavior (no content displayed in attachment 157073 [details], "小笠原" displayed in the modified ODS attachment 157074 [details]) on 6.3.4:
版本: 6.3.4.2 (x64)
Build ID: 60da17e045e08f1793c57c00ba83cdfce946d0aa
CPU 线程: 2; 操作系统: Windows 10.0; UI 渲染: 默认; VCL: win; 
区域语言: zh-CN (zh_CN); UI 语言: zh-CN
Calc: threaded

I have no idea if this is LO's fault or Excel exporting a problematic ODS file, though.  So let's ping the Ruby meta bug and see if the experts there can shine some light on this.
Comment 4 Xisco Faulí 2020-02-17 14:56:43 UTC
I can reproduce it in

Version: 7.0.0.0.alpha0+
Build ID: 28d844a589e52abfe62dc66b888e78665221ba28
CPU threads: 4; OS: Linux 4.19; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded

and


Version: 4.3.0.0.alpha1+
Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e

but not in

Version 4.1.0.0.alpha0+ (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)

thus, seems to be a regression
Comment 6 Naruhiko Ogasawara 2020-02-18 04:36:52 UTC
*** Bug 130750 has been marked as a duplicate of this bug. ***