如何序列化Jackson的JsonNode对象？(How can I serialize Jackson's JsonNode object?)

 组合的公式将足够长，以至于将来难以维护和更新。 问题是您要生成两次相同的查询。 
 
 我建议改为在B处插入一个新列（将当前列B推到C），然后写一个公式，如=IF(OR(C2="value 2",C2="value 3"),"skip","") 
 
 然后，为了清楚起见，将原始公式中的"value 3"更改为"skip" ，并且（如果您愿意）隐藏辅助列B.这将为您提供更易于维护的公式，并且您可以设置布尔条件在B栏中，你喜欢的复杂，没有太大的困难。 

The combined formula would be long enough that it would become difficult to maintain and update in the future. The problem is that you are generating the same query twice.
 
I recommend instead inserting a new column at B (which would push the current column B to C), and then writing a formula such as =IF(OR(C2="value 2",C2="value 3"),"skip","")
 
Then, for clarity's sake, change "value 3" in your original formula to "skip", and (if you wish) hide the helper column B. This would give you a formula far easier to maintain, and you can make the boolean condition in column B as complex as you like without significant difficulty.