Remove Kana for Kanji from the search results of xlsx Excel file

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Won't Do
    • None
    • Component/s: None
    • None
    • 1

      Summary

      Remove Kana for Kanji from the search results of xlsx Excel file.
      All strings in the xlsx (OpenXML type document) Excel file are stored in xl/sharedStrings.xml file.
      The sharedStrings.xml has Kana for kanji int the file. Those are automatically added strings by Excel.

      <?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<sst xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" count="3" uniqueCount="3"><si><t>日本</t><rPh sb="0" eb="2"><t>ニホン</t></rPh><phoneticPr fontId="1"/></si><si><t>日本</t><rPh sb="0" eb="2"><t>ニッポン</t></rPh><phoneticPr fontId="1"/></si><si><t>横浜市</t><rPh sb="0" eb="2"><t>ヨコハマシ</t></rPh></si></sst>

      Inside contents of <rPh>..</rPh> are not need to display as the results.

        1. SearchResult.jpg
          SearchResult.jpg
          12 kB
        2. OriginExcel.jpg
          OriginExcel.jpg
          14 kB

            Assignee:
            Unassigned
            Reporter:
            Takuya Nagasaka (Inactive)
            Votes:
            2 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: