[Libreoffice-bugs] [Bug 129940] FILEOPEN: Cell content in ODS exported by Excel with Asian phonetic guide ​​is displayed as empty

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=129940

--- Comment #1 from Naruhiko Ogasawara <naruoga at gmail.com> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200111/cd2bdb72/attachment-0001.htm>