如何在LibreOffice Calc中生成特定格式的自定义单词列表

不需要编写脚本，用内置函数组合就能实现需求，以下是具体操作方法：

基础函数说明 #

• 生成任意大写字母：CHAR(RANDBETWEEN(65,90))（ASCII码65-90对应A-Z）
• 生成任意小写字母：CHAR(RANDBETWEEN(97,122))（ASCII码97-122对应a-z）
• 生成随机元音字母（大写）：CHOOSE(RANDBETWEEN(1,5),"A","E","I","O","U")（小写替换成"a","e","i","o","u"即可）

生成指定格式的字符串 #

1. ??P??P格式（第2、5位为元音） #

在目标单元格输入公式：

=CONCAT(CHAR(RANDBETWEEN(65,90)),CHOOSE(RANDBETWEEN(1,5),"A","E","I","O","U"),"P",CHAR(RANDBETWEEN(65,90)),CHOOSE(RANDBETWEEN(1,5),"A","E","I","O","U"),"P")

2. ??K??K格式（第2、5位为元音） #

把上面公式中的两个"P"替换成"K"即可：

=CONCAT(CHAR(RANDBETWEEN(65,90)),CHOOSE(RANDBETWEEN(1,5),"A","E","I","O","U"),"K",CHAR(RANDBETWEEN(65,90)),CHOOSE(RANDBETWEEN(1,5),"A","E","I","O","U"),"K")

3. 自定义??X??X格式（X为任意指定字母） #

将公式中的固定字母替换为你需要的X即可，比如X为M：

=CONCAT(CHAR(RANDBETWEEN(65,90)),CHOOSE(RANDBETWEEN(1,5),"A","E","I","O","U"),"M",CHAR(RANDBETWEEN(65,90)),CHOOSE(RANDBETWEEN(1,5),"A","E","I","O","U"),"M")

4. 不需要第2、5位为元音的情况 #

把公式中的CHOOSE(...)替换成任意字母生成函数即可，比如基础??P??P格式：

=CONCAT(CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(65,90)),"P",CHAR(RANDBETWEEN(65,90)),CHAR(RANDBETWEEN(65,90)),"P")

批量填充列 #

1. 在目标列第一个单元格输入对应公式
2. 选中该单元格，鼠标移到单元格右下角的填充柄（小方块），按住左键向下拖动，即可批量生成符合格式的内容
3. 若要固定生成的内容（避免文件重新打开时随机值刷新）：选中生成的单元格，右键→复制，再右键→选择性粘贴→只粘贴数值

内容的提问来源于stack exchange，提问作者banuyayi