Bug 89976 - FEATURE REQUEST:Add PHONETIC function
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
Reported: 2015-03-13 02:10 UTC by HD
Modified: 2017-07-23 22:44 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Excel file with function PHONETIC() (9.22 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-03-13 06:11 UTC, HD

Note You need to log in before you can comment on or make changes to this bug.
Description HD 2015-03-13 02:10:22 UTC
Is there any possibility to add PHONETIC function to extract the phonetic (furigana) characters from a text string. I think many Japanese users want this function.

 If cells A1 contains "東京"  the following are true:
 =PHONETIC(A1) equals "トウキョウ"

Also, if you import Excel book which uses PHONETIC function, #NAME? error occurs because Calc doesn't have one.

Best regards.
Comment 1 raal 2015-03-13 05:59:11 UTC
(In reply to HD from comment #0)

> Also, if you import Excel book which uses PHONETIC function, #NAME? error
> occurs because Calc doesn't have one.

Please attach excel file with function phonetic().

Comment 2 HD 2015-03-13 06:11:34 UTC
Created attachment 114066 [details]
Excel file with function PHONETIC()

Thank you for your response.
I attached xlsx file.
Comment 3 Robinson Tryon (qubit) 2015-03-13 07:13:07 UTC
(Typofix in summary)

I'm also cc'ing Winfried, who is very knowledgeable about Calc functions.
Comment 4 raal 2015-03-13 10:30:45 UTC
@Eike: What's the status of PHONETIC function? http://lists.freedesktop.org/archives/libreoffice/2011-November/020844.html
I didn't found this function in odf format spec. Thank you
Comment 5 Eike Rathke 2015-03-13 19:00:46 UTC
On purpose.. in http://lists.freedesktop.org/archives/libreoffice/2011-November/020844.html you linked I gave the explanation. If some native Japanese speaking developer feels entitled to tackle this, welcome. I have no clue.