Issue 80764

Summary: Importing and exporting phonetic text in Excel format
Product: Calc Reporter: bluedwarf <bluedwarf>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: curvirgo, daniel.rentz, issues, kamataki, kyoshida, tora3
Version: recent-trunk   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on:    
Issue Blocks: 80766    
Attachments:
Description Flags
An example file of Excel
none
Its snapshot none

Description bluedwarf 2007-08-17 06:00:27 UTC
Excel supports phonetic guide function. This function are mentioned in the page
below
http://office.microsoft.com/en-us/excel/HP052507751033.aspx

Excel also has the function to save the phonetic (ruby) text into Excel format
file and load it from the file. To improve interoperability with Excel, Calc
should support the same function.

The same request are reported by Seagull Research Team 2006:
http://ooo-research.good-day.net/?en_top
http://www.ipa.go.jp/software/open/ossc/download/OOo_Requirements_Specifications.pdf
(ID 19 in page 4)
Comment 1 frank 2007-08-17 08:37:02 UTC
Re-assigned to tora as he will work on this.
Comment 2 tora3 2007-08-17 13:40:34 UTC
.
Comment 3 tora3 2007-08-22 02:27:39 UTC
Created attachment 47704 [details]
An example file of Excel
Comment 4 tora3 2007-08-22 02:28:17 UTC
Created attachment 47705 [details]
Its snapshot
Comment 5 tora3 2007-08-22 02:55:23 UTC
80764-example1.{xls,png} is the same example as 
http://sc.openoffice.org/servlets/ReadMsg?list=dev&msgNo=2563

Here is a hex dump of 80764-example1.xls. The following data 
blocks are stored sequentially without any separator.

0004 05 0028 0000
  5409 7530 6d69 5e73 = 吉 田 浩 平
    0001 0024 0006 0035 0002 0007 0007
      30e8 30b7 30c0 30b3 30a6 30d8 30a4 = ヨ シ ダ コ ウ ヘ イ
        0000 0000 0002 = 吉田(ヨシダ)
        0003 0002 0002 = 浩平(コウヘイ)

000f 05 0030 0000
  79c1 306f 4eca 30a2 30e1 30ea 30ab 3067 50cd 3044 3066 3044 307e 3059 3002
  = 私 は 今 ア メ リ カ で 働 い て い ま す 。
    0001 002c 0006 0035 0003 0008 0008
      30ef 30bf 30b7 30a4 30de 30cf 30bf 30e9
      = ワ タ シ イ マ ハ タ ラ
        0000 0000 0001 = 私(ワタシ)
        0003 0002 0001 = 今(イマ)
        0005 0008 0001 = 働(ハタラ)

0015 04 0010 0000
  73 70 65 63 69 61 6c 6d 61 72 6b 74 6f 66 69 6e 64 68 65 72 65
  = specialmarktofindhere
    0001 000c 0006 0035 0000 0000 0000
      0000

Note that byte order has been intentionally swapped for readability.

Documentation is available at 
http://sc.openoffice.org/excelfileformat.pdf, ch. 2.5.3, pages 17-20, 
introduced in the article by Daniel Rentz.
http://sc.openoffice.org/servlets/ReadMsg?list=dev&msgNo=2510
Comment 6 kyoshida 2009-09-11 16:31:50 UTC
Tora-san, I would like to upstream this feature based on your patch.  I had
modified your patch slightly to adjust for 3.x, which is currently in Go-OO.  Is
it okay to start with that patch to create a CWS for integration?
Comment 7 daniel.rentz 2009-09-11 16:45:38 UTC
FYI:

For ooxml import, I made some preparations, see the RichString class and related
...Phonetic... classes in oox/inc/oox/xls/richstring.hxx. All phonetic data is
already imported and stored in the members RichString::maPhonPortions (phonetic
text portions) and RichString::maPhonSettings (phonetic font settings and
alignment).

What to do to finalize this? In RichString::convert(), these members have to be
processed somehow. Hopefully, it is possible to receive the appropriate UNO
interface(s) needed to set phonetic information from the passed XText. :-)
Comment 8 tora3 2009-09-15 15:17:06 UTC
tora->kohei: Thank you for your efforts. Sure, it is okay to start it. 

The original patch was developed February 2008 by Hiroyuki Ikezoe as a member of 
the Japanese Seagull Development Project 2007 (jsdp2007). 

http://wiki.services.openoffice.org/wiki/Jsdp2007
http://jsdp2007.net/wiki/?shortcut=cf576f
http://jsdp2007.net/wiki/?shortcut=3f96d2
Comment 9 kyoshida 2009-09-17 20:51:03 UTC
re-assigning to myself, for the integration work.
Comment 10 thorsten.ziehm 2010-09-23 08:53:18 UTC
This issue is assigned to CWS calcphonetic. Currently this CWS has target OOo
3.4 and therefore I change the target of this issue accordingly. 
Comment 11 Rob Weir 2013-07-30 02:38:40 UTC
Reset assignee on issues not touched by assignee in more than 1000 days.