Bug 89976 - FEATURE REQUEST:Add PHONETIC function
Summary: FEATURE REQUEST:Add PHONETIC function
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.0.3 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Excel-Functions
  Show dependency tree / graph
 
Reported: 2015-03-13 02:10 UTC by HD
Modified: 2022-09-10 16:45 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
Excel file with function PHONETIC() (9.22 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2015-03-13 06:11 UTC, HD 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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.

ex.
 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().

https://support.office.com/en-au/article/PHONETIC-function-27e75e01-1a9a-48ad-a52b-b6cd47d21990
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.