Issue 80766

Summary: PHONETIC function
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, ooo, tora3
Version: recent-trunk   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on: 80764, 80765, 81366    
Issue Blocks: 62698    

Description bluedwarf 2007-08-17 06:06:43 UTC
Excel has the worksheet function PHONETIC() to show phonetic text in a
specified cell range. Calc should support the equivalent function to
improve interoperability with Excel. The implementation of this
function might depend on the support of the phonetic guide function
stated in i62698.

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 18 in page 3)

Microsoft Office Online has the following page to describe how
PHONETIC() function works,
http://office.microsoft.com/en-us/excel/HP052508411033.aspx

However, this page have some wrong points.

First, only a single cell adress or a range of adjacent cells are
allowed as the argument of PHONETIC function in Excel. If you enter a
text string as the argument like PHONETIC("ABC"), this function
returns "incorrect formula" error.

Second, the result of this function doesn't depend on the text but the
phonetic text stored in each cell. Thus, if cell C4 contains "東京都"
as the text and "トウキョウト" as the phonetic text in the cell,
PHONETIC(C4) returns "トウキョウト", but if cell C4 contains the same
text "東京都" and the different phonetic text "ヒガシキョウト",
PHONETIC(C4) returns "ヒガシキョウト".

Third, the result of this function also depends on the phonetic text
attribute. If the character type attribute is "Hiragana", all
half-width Katakana characters and full-width Katakana characters are
converted into Hiragana characters. In the first case above,
PHONETIC(C4) returns "とうきょうと".

Developers must be aware that PHONETIC function is not so simple
stated in the Online help.
Comment 1 frank 2007-08-17 08:33:58 UTC
Re-assigned to tora as he will work on this.
Comment 2 tora3 2007-08-17 13:39:40 UTC
.
Comment 3 bluedwarf 2007-09-07 14:49:10 UTC
Set new dependency.
PHONETIC function requires conversion between Halfwidth Katakana characters and
Fullwidth Katakana characters.
Comment 4 kyoshida 2009-09-17 20:51:04 UTC
re-assigning to myself, for the integration work.
Comment 5 ooo 2009-09-23 14:48:40 UTC
@kohei: I wonder how you would implement this. The result of PHONETIC() depends
on the IME state of the character sequences used during input.
Comment 6 kyoshida 2009-09-23 14:56:16 UTC
@er: no, this is just for file import/export.  We won't implement the core
phonetic support just yet.
Comment 7 kyoshida 2009-09-23 15:02:40 UTC
what I mean by 'core phonetic support' is the ability to input a new text with
full phonetic information.  We can't implement that just yet and you probably
know the reason why.  But we can still implement xls/ods import/export and the
PHONETIC cell function even without that.
Comment 8 ooo 2009-09-23 15:26:08 UTC
Does ODF provide the necessary feature to store it?
Comment 9 kyoshida 2009-09-23 15:34:42 UTC
I believe so.  There is already a ruby structure that Writer uses to store
phonetic information for Writer.  We can re-use that structure for Calc as well
since the cell element supports text paragraphs in full.  Hopefully we won't
have to extend the ODF to implement odf import/export, but we'll see.
Comment 10 niklas.nebel 2009-09-23 16:54:06 UTC
Wait... You're suggesting a partial implementation so we can load, save, import
and export, but not edit or input the extra data? That sounds very wrong.
Comment 11 kyoshida 2009-09-23 18:07:53 UTC
No, it doesn't.  The word 'wrong' is very subjective here, and I don't share
your view point on this case.

We still don't have full OpenFormula implementation, but we do implement it step
by step.  Is that also wrong in your view?
Comment 12 thorsten.ziehm 2010-09-23 08:54:08 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 13 Rob Weir 2013-07-30 02:41:55 UTC
Reset assignee on issues not touched by assignee in more than 1000 days.