大佬们,下拉框从数据库取值以后显示如下图,想要每个数字一行而不是所有数字都在一行显示,怎么处理?
公式:SQL("JDBC4","select id from salesIssue where documentNo = '"+$text_documentNo+"'",1)
实际值公式:
=split(SQL("JDBC4","select id from salesIssue where documentNo = '"+$text_documentNo+"'",1),",")
显示值:=$$$