Add-ons
Check out the store for many more
Add-on

HanyuPinyinTools


(8)
offered by j2db.com
784 users

Overview

Converts Chinese text to Hanyu Pinyin.
FEATURES
--Comprehensive tone sandhi
--Automatic removal of tone 5 tone mark annotation
--Converts Traditional and Simplified Chinese characters
--Converts a single text value or a range of text values

POSSIBLE USES
--Build and share new vocabulary lessons directly in Google Sheets
--Design and deploy a custom dictionary lexicon
--Create Google Sheets backed Android apps
--Instruction support for a classroom-based activity
--Tutoring and online collaboration for a custom Mandarin Chinese curriculum

CUSTOM FUNCTIONS LIST
HANYUPINYIN: pinyin with tone numbers.
HANYUPINYIN_TONELESS: pinyin with no tones.
HANYUPINYIN_TONEMARKS: pinyin with backwards-compatible tone marks.
HANYUPINYIN_TONEMARKS_ISO: pinyin with ISO tone marks.

Version 15
-- Adds the ability to convert a text value or a text range. Using ranged text input allows for more conversions with "fewer" function calls. For example, either formula HANYUPINYIN_TONEMARKS(A1) or HANYUPINYIN_TONEMARKS(A1:A15) will work.

Previous Versions
--Adds new method HANYUPINYIN_TONEMARKS_ISO with ISO 7098 compliant format, with caron diacritic
--Reverts HANYUPINYIN_TONEMARKS to backwards-compatible format, with breve diacritic; should fix issues with apps that are looking for this version of third tone.
--Better, cleaner code, for better performance
--Improved tone removal for HANYUPINYIN_TONELESS function
--Bug fixes and improvements
--Pinyin third tone is now a ISO 7098 compliant caron (not a breve)
--More efficient tone processing

Details

Version: 15
Updated: January 17, 2016
Language: English