Luc Wastiaux
patreon
Using batch mode on Mandarin Cantonese API add-on
🕑 Added 2019-10-19 01:37:28 +0000 UTCThe traditional way excel taught us to apply a formula to a bunch of cells was to drag the lower right-hand corner to extend the formula. This is fine but it creates some problems on google sheets addons:
- The function will be called separately for every row. This means you're more likely to run into those "urlfetch" limits that google imposes on all users
- As you write more rows with more chinese text, you'll have to keep on dragging the formula to apply it to new rows.
Batch mode solves these issues. By typing the formula on the fist row, it will automatically apply to subsequent rows.
More information: https://medium.com/@lucw/converting-chinese-characters-to-pinyin-jyutping-on-google-sheets-now-with-more-functionality-5047692950bf
