| MIME-Version: | 1.0 (Mac OS X Mail 10.3 \(3273\)) |
| X-Spam-Status: | No, score=-1.334 tagged_above=-99.9 required=10 tests=[BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, FREEMAIL_FROM=0.001, SPF_SOFTFAIL=0.665] autolearn=no |
| X-Mailer: | Apple Mail (2.3273) |
| X-Cpan.org: | This message routed through the cpan.org mail forwarding service. Please use PAUSE pause.perl.org to configure your delivery settings. |
| X-Spam-Flag: | NO |
| Message-ID: | <10267C14-BE74-4CB7-8969-E6A45D759ADC@gmail.com> |
| content-type: | text/plain; charset="utf-8" |
| X-Received: | by 10.98.61.2 with SMTP id k2mr10368675pfa.90.1499093358988; Mon, 03 Jul 2017 07:49:18 -0700 (PDT) |
| X-Virus-Scanned: | Debian amavisd-new at bestpractical.com |
| X-Spam-Score: | -1.334 |
| Received: | from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 15FA6240313 for <cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com>; Mon, 3 Jul 2017 10:49:58 -0400 (EDT) |
| Received: | from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id dkUg0vbEcmYq for <cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com>; Mon, 3 Jul 2017 10:49:57 -0400 (EDT) |
| Received: | from xx1.develooper.com (xx1.develooper.com [207.171.7.115]) by hipster.bestpractical.com (Postfix) with ESMTPS id D2EAB2402D0 for <bug-Spreadsheet-XLSX@rt.cpan.org>; Mon, 3 Jul 2017 10:49:56 -0400 (EDT) |
| Received: | from localhost (xx1.develooper.com [127.0.0.1]) by localhost (Postfix) with ESMTP id 67C3F11FED9 for <bug-Spreadsheet-XLSX@rt.cpan.org>; Mon, 3 Jul 2017 07:49:55 -0700 (PDT) |
| Received: | from xx1.develooper.com (xx1.develooper.com [127.0.0.1]) by localhost (Postfix) with SMTP id 40B8C11FF40 for <bug-Spreadsheet-XLSX@rt.cpan.org>; Mon, 3 Jul 2017 07:49:51 -0700 (PDT) |
| Received: | from mail-pg0-f45.google.com (mail-pg0-f45.google.com [74.125.83.45]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (No client certificate requested) by xx1.develooper.com (Postfix) with ESMTPS id B74F811FF09 for <bug-Spreadsheet-XLSX@rt.cpan.org>; Mon, 3 Jul 2017 07:49:19 -0700 (PDT) |
| Received: | by mail-pg0-f45.google.com with SMTP id j186so96305483pge.2 for <bug-Spreadsheet-XLSX@rt.cpan.org>; Mon, 03 Jul 2017 07:49:19 -0700 (PDT) |
| Received: | from [192.168.1.24] (pl15423.ag1111.nttpc.ne.jp. [124.154.88.63]) by smtp.gmail.com with ESMTPSA id u194sm32661066pgb.24.2017.07.03.07.49.17 for <bug-Spreadsheet-XLSX@rt.cpan.org> (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 03 Jul 2017 07:49:18 -0700 (PDT) |
| Authentication-Results: | hipster.bestpractical.com (amavisd-new); dkim=pass header.i=@gmail.com |
| Delivered-To: | cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com |
| Subject: | Phonetic hints concatenated in shared string in cell value. |
| Return-Path: | <k1complete@gmail.com> |
| X-RT-Mail-Extension: | spreadsheet-xlsx |
| X-Original-To: | cpan-bug+Spreadsheet-XLSX@hipster.bestpractical.com |
| Dkim-Signature: | v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=from:content-transfer-encoding:mime-version:subject:message-id:date :to; bh=QAAk6Fq7thEpiTIM8rEUHlpPvm7m3q2tWGLdOTeXnO4=; b=YHy+FzmNJK9AeuXBv9nRQhPvlXlYeGLVWZ4QFDTqh07pXpx3J3tetW4Q7+Klxx87HE rZD2JykNwA/b8fpXJ1QNpsaKyHO74lMnqpcmohRob/PfmgJux6DhyGJxcQlUt+lC1Z5/ vVFWyrrGdKlt+2JTNTKIn3AzNM+UDtAws+J6zhIS6ZNGUTLYPkO4HbRgb/HnFizDVYH3 eNHW4Ig4hTsrpv/r8siDLBAQPbGrROAG41Q31baZfQ2dlgvjPyRpIbvcPAm4Vj3qZhcX xnJyuis2GJnicMcOl3QxQy82SdwSm+pUcZrTp5/l7iBlogQXELpGDQGN1e3XjdQyDR6B NXjA== |
| X-Google-Dkim-Signature: | v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:content-transfer-encoding:mime-version :subject:message-id:date:to; bh=QAAk6Fq7thEpiTIM8rEUHlpPvm7m3q2tWGLdOTeXnO4=; b=JQuGzEiOBv5LcDMoVu7qgd+d+WlDnO/vdmFwXfC5kfSQW7z784mCkGZ4Rd1LyDZCpl 1OSzQ4mFIAc+0VUf85M8lW8Fpacly+gSukT/ojZYFK9wGPmNWgQXrkJ7jPSZgfoexlT7 4mY3rXD8drB3L0AeAWsHRB0uPFlxTlWDmxSpGlsonuD34a2q22H/zy4LdKscH1zwZT2K RncrxiB4lV3n/nq/COWkmdInxqD8jV+SOL4wUFHAhHBMnEAtMsTwBribodb0VuIF40AQ bADFnyK3OLdOiXfX/U+cmMTfbkmkBIDqfoLfIiPL9pG5Ft0XDKxVzEXK7U4I5HcpDDBM rYQQ== |
| X-PMX-Spam: | Gauge=IIIIIIII, Probability=8%, Report=' HTML_NO_HTTP 0.1, MIME_LOWER_CASE 0.05, BODYTEXTP_SIZE_3000_LESS 0, BODY_SIZE_1500_1599 0, BODY_SIZE_2000_LESS 0, BODY_SIZE_5000_LESS 0, BODY_SIZE_7000_LESS 0, DKIM_SIGNATURE 0, HTML_TAG_NAME_RND_CAP 0, SINGLE_URI_IN_BODY 0, SPF_PASS 0, URI_WITH_PATH_ONLY 0, WEBMAIL_SOURCE 0, __ANY_URI 0, __CN_FROM_SHORT 0, __CP_URI_IN_BODY 0, __CT 0, __CTE 0, __CT_TEXT_PLAIN 0, __DQ_NEG_HEUR 0, __DQ_NEG_IP 0, __FRAUD_CONTACT_NAME 0, __FRAUD_MONEY_CURRENCY 0, __FRAUD_MONEY_CURRENCY_DOLLAR 0, __FRAUD_WEBMAIL 0, __FRAUD_WEBMAIL_FROM 0, __FROM_GMAIL 0, __HAS_FROM 0, __HAS_HTML 0, __HAS_MSGID 0, __HAS_X_MAILER 0, __HELO_GMAIL 0, __HIGHBITS 0, __HTTPS_URI 0, __INT_PROD_LOC 0, __MIME_TEXT_ONLY 0, __MIME_TEXT_P 0, __MIME_TEXT_P1 0, __MIME_VERSION 0, __MSGID_APPLEMAIL 0, __PHISH_SPEAR_STRUCTURE_1 0, __RDNS_GMAIL 0, __SANE_MSGID 0, __SINGLE_URI_TEXT 0, __STOCK_PHRASE_24 0, __TO_MALFORMED_2 0, __TO_NO_NAME 0, __URI_IN_BODY 0, __URI_NOT_IMG 0, __URI_NO_MAILTO 0, __URI_NO_WWW 0, __URI_NS , __URI_WITH_PATH 0, __USER_AGENT_APPLEMAIL 0, __X_MAILER_APPLEMAIL 0, __YOUTUBE_RCVD 0, __blackholes.mail-abuse.org_TIMEOUT , __zen.spamhaus.org_ERROR ' |
| Date: | Mon, 3 Jul 2017 23:49:17 +0900 |
| X-Spam-Level: | |
| X-PMX-Version: | 5.6.1.2065439, Antispam-Engine: 2.7.2.376379, Antispam-Data: 2017.7.3.143916 |
| To: | bug-Spreadsheet-XLSX@rt.cpan.org |
| Content-Transfer-Encoding: | quoted-printable |
| From: | 小田 照敬 <k1complete@gmail.com> |
| X-GM-Message-State: | AIVw112PKzx7PuplITMBSiCjRI6fekcCtmC04et1btBDPbwT/QdBeIFh Y/3ZFXP+vtJ2gA1LEgo= |
| X-RT-Original-Encoding: | utf-8 |
| X-RT-Interface: | |
| Content-Length: | 1345 |
Hi. I have a idea.
Distribution-name: Spreadsheet-XLSX-0.15
Perl-version: 5.18.2
OS-version: Darwin air13.local 16.6.0 Darwin Kernel Version 16.6.0: Fri Apr 14 16:21:16 PDT 2017;\
root:xnu-3789.60.24~6/RELEASE_X86_64 x86_64
Request-Type: Enhancement
Description:
In east asian environment, Often XLSX file includes phonetic hint resources.
This case, $cell->[0][0]->{Val} is concatenated <rph><t>…</t></rph> and <t>…</t>.
I make support to rPh and phoneticPr markup for far east asian environment.
Phonetic hint, used in far east asia is supported by 'RPh' and 'PhoneticPr'
key:
<si>
<t>課きく 毛こ</t>
<rPh sb="0" eb="1">
<t>カ</t>
</rPh>
<rPh sb="4" eb="5">
<t>ケ</t>
</rPh>
<phoneticPr fontId="1"/>
</si>
if a cell[0][0]->{Val} is '課きく 毛こ', The
cell[0][0]->{RPh}->[0]->{Val} is 'カ', cell[0][0]->{RPh}->[0]->{Sb} is
0, and cell[0][0]->{RPh}->[0]->{Eb} is 1,
cell[0][0]->{RPh}->[1]->{Val} is 'ケ', cell[0][0]->{RPh}->[1]->{Sb} is
4, and cell[0][0]->{RPh}->[0]->{Eb} is 5,
cell[0][0]->{PhoneticPr}->{FontId} is 1,
cell[0][0]->{PhoneticPr}->{Type} is undef. Phonetic hint keys are
named by capitalizing the first letter from ecma-376 attribute names.
I put a patch on GitHub below:
https://github.com/k1complete/Spreadsheet-XLSX/pull/1/files
Regards.