Hackers' Pub

Hackers’ Pub

Syntax	Description	Examples
`"` keyword `"`	Finds the string within quotes, including spaces. Case-insensitive. (Escape quotes inside with `\"`)	`"Hackers' Pub"`
`from:` handle	Finds content written by the specified user.	`from:hongminhee` `from:hongminhee@hollo.social`
`lang:` ISO 639-1	Finds content written in the specified language.	`lang:en`
`#` tag	Finds content with the specified tag. Case-insensitive.	`#HackersPub`
condition condition	Finds content that satisfies both conditions on either side of the space (logical AND).	`"Hackers' Pub" lang:en`
condition `OR` condition	Finds content that satisfies at least one of the conditions on either side of the OR operator (logical OR).	`#HackersPub OR "Hackers' Pub" lang:en`
`(` condition `)`	Combines the operators within the parentheses first.	`(#HackersPub OR "Hackers' Pub" OR "Hackers Pub") lang:en`

MJ @voyager@g0v.social

6/16/2025, 12:05:07 PM

Public

今天真是Google試算表強者

主管想給Google表格收集的答案自訂格式，原來raw data的試算表無法，結果發現有算式可以把整張表格的內容倒過去，再在另一邊自訂格式；

然後又用條件式格式，設定加個標記便可以整行變色

最後再用隱藏功能把整張raw data表收起來

If you have a fediverse account, you can quote this note from your own instance. Search https://g0v.social/users/voyager/statuses/114692948481533763 on your instance and quote it. (Note that quoting is not supported in Mastodon.)