Description:
LibreOffice Writer supports the use of furigana in kanji through the Asian Phonetic Guide option.

However, LibreOffice Calc does not support it in any way, in fact the Asian Phonetic Guide option is shown disabled in the Format menu. From my point of view, this is incomplete support in the LibreOffice suite of the furigana functionality supported through Asian Phonetic Guide.

It is not that furigana can be created and edited directly within a Japanese text in a cell, it is not even supported when pasting content, in fact if you copy a Japanese text with furigana from LibreOffice Writer to Calc, the furigana disappears. The only way to get it to display correctly is to paste the text as a LibreOffice 7.6 Text Document format, but doing it this way pastes it as a text box, making the spreadsheet unmanageable.

This lack of functionality was already reported a few years ago:

https://bugs.documentfoundation.org/show_bug.cgi?id=124473

But from what I see, it is still not implemented.

This functionality has been fully supported in Microsoft Excel for years, where you can create furigana in any cell for the kanji, it can be edited directly in the cell and it can be displayed or hidden individually for each cell.

Please, we need this functionality to be implemented in LibreOffice Calc, there are many reasons to need to use furigana when filling the contents of a cell with Japanese text, for example to create vocabulary lists for Japanese learners, and many other reasons.

I am willing to financially support the development of this functionality through some type of donation, if it is not excessively expensive.

Ultimately, although I would prefer not to do it, if there is no developer willing to undertake this task, I am a computer scientist, although I have not programmed for some years, but I would be willing to try to implement it if I receive enough support and help from other LibreOffice developers that they can guide me in the development of LibreOffice, since I have no idea how it is implemented (I don't even know in what programming language it is developed).

Steps to Reproduce:
1. Create a Japanese text in LibreOffice Writer that has kanji, and add some furigana for the kanji via the Asian Phonetig Guide option.

2. Copy the text and try to paste it into LibreOffice Calc, either as plain text, as rich format or as HTML, you will see that it is impossible, the furigana disappear.

3. Now try to paste the text in LibreOffice 7.6 Text Document format, you will see that now the furigana characters are displayed correctly above the kanji, but the problem is that it has been pasted as a text box, making the sheet unmanageable.

Actual Results:
By pasting the text into some manageable format that allows the content to be edited (plain text, RTF or HTML), the furigana disappears.

Expected Results:
Although you cannot create and edit furigana directly from LibreOffice Calc, as Microsoft Excel does allow, it should at least allow you to paste Japanese text with furigana from LibreOffice Writer, respecting the furigana format and displaying it correctly.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.6.4.1 (X86_64) / LibreOffice Community
Build ID: 60(Build:1)
CPU threads: 16; OS: Linux 6.6; UI render: default; VCL: kf5 (cairo+wayland)
Locale: es-ES (en_US.UTF-8); UI: en-US
7.6.4-1
Calc: threaded

For users who use Linux, we have no alternative. If you use Windows, you can indeed use Microsoft Excel, which supports this functionality. But for those users who usually use Linux, there is no alternative right now, there is no other spreadsheet on the market that supports the use of furigana on Linux. Therefore, LibreOffice being the most complete and important office suite used in Linux, it is important to support this functionality.