Apache OpenOffice (AOO) Bugzilla – Issue 80764
Importing and exporting phonetic text in Excel format
Last modified: 2013-08-07 15:13:10 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)
Re-assigned to tora as he will work on this.
.
Created attachment 47704 [details] An example file of Excel
Created attachment 47705 [details] Its snapshot
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
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?
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. :-)
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
re-assigning to myself, for the integration work.
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.
Reset assignee on issues not touched by assignee in more than 1000 days.