This queue is for tickets about the Spreadsheet-XLSX CPAN distribution.

Report information
The Basics
Id:
122340
Status:
new
Priority:
Low/Low

People
Owner:
Nobody in particular
Requestors:
k1complete [...] gmail.com
Cc:
AdminCc:

BugTracker
Severity:
(no value)
Broken in:
(no value)
Fixed in:
(no value)



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: Email
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.


This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.