使用中还发现,当大量使用DATATYPE函数嵌套时,多条输出,,编译测试通过,,但在副图时,会出现一条或者多条输出不显示,,如下公式,分别输出了DA1,,DA2,DB1,DB2,DC1,,DC2
6条输出,,但是副图上却有一条或者几条输出不显示,例如DA2或者DA1输出不显示等等,,测试发现如果输出显示少的情况下正常显示,,只要大量使用DATATYPE函数嵌套时输出显示的多,就会出错
该问题一直困扰着我,,测试遍数>40次,出错率100%,,版主请测试,,标注,,说了只输出少数1.。2个正常,,只要一多就出错。。版主也可以在加几个测试,例如再加输出,,DD1,,DD2,,DE1,,DE2
DC2:IF(DATATYPE=14,"KDJ,K#MIN15",IF(DATATYPE=1,"KDJ,K#MIN60",IF(DATATYPE=2,"KDJ,K#DAY",IF(DATATYPE=3,"KDJ,K#WEEK",IF((DATATYPE=5 OR DATATYPE=13),
"KDJ,K#MONTH",IF(DATATYPE=6,"KDJ,K#QUARTER",IF(DATATYPE=7,"KDJ,K#YEAR",0)))))));
DC1:IF(DATATYPE=14,"KDJ,D#MIN15",IF(DATATYPE=1,"KDJ,D#MIN60",IF(DATATYPE=2,"KDJ,D#DAY",IF(DATATYPE=3,"KDJ,D#WEEK",IF((DATATYPE=5 OR DATATYPE=13),
"KDJ,D#MONTH",IF(DATATYPE=6,"KDJ,D#QUARTER",IF(DATATYPE=7,"KDJ,D#YEAR",0)))))));
DB2:IF(DATATYPE=14,"KDJ,K#MIN5",IF(DATATYPE=1,"KDJ,K#MIN15",IF(DATATYPE=2,"KDJ,K#MIN60",IF(DATATYPE=3,"KDJ,K#DAY",IF((DATATYPE=5 OR DATATYPE=13),
"KDJ,K#WEEK",IF(DATATYPE=6,"KDJ,K#MONTH",IF(DATATYPE=7,"KDJ,K#QUARTER",IF(DATATYPE=8,"KDJ,K#YEAR",0))))))));
DB1:IF(DATATYPE=14,"KDJ,D#MIN5",IF(DATATYPE=1,"KDJ,D#MIN15",IF(DATATYPE=2,"KDJ,D#MIN60",IF(DATATYPE=3,"KDJ,D#DAY",IF((DATATYPE=5 OR DATATYPE=13),
"KDJ,D#WEEK",IF(DATATYPE=6,"KDJ,D#MONTH",IF(DATATYPE=7,"KDJ,D#QUARTER",IF(DATATYPE=8,"KDJ,D#YEAR",0))))))));
DA2:IF(DATATYPE=14,"KDJ,K#MIN1",IF(DATATYPE=1,"KDJ,K#MIN5",IF(DATATYPE=2,"KDJ,K#MIN15",IF(DATATYPE=3,"KDJ,K#MIN60",IF((DATATYPE=5 OR DATATYPE=13),
"KDJ,K#DAY",IF(DATATYPE=6,"KDJ,K#WEEK",IF(DATATYPE=7,"KDJ,K#MONTH",IF(DATATYPE=8,"KDJ,K#QUARTER",IF(DATATYPE=12,"KDJ,K#YEAR",0)))))))));
DA1:IF(DATATYPE=14,"KDJ,D#MIN1",IF(DATATYPE=1,"KDJ,D#MIN5",IF(DATATYPE=2,"KDJ,D#MIN15",IF(DATATYPE=3,"KDJ,D#MIN60",IF((DATATYPE=5 OR DATATYPE=13),
"KDJ,D#DAY",IF(DATATYPE=6,"KDJ,D#WEEK",IF(DATATYPE=7,"KDJ,D#MONTH",IF(DATATYPE=8,"KDJ,D#QUARTER",IF(DATATYPE=12,"KDJ,D#YEAR",0)))))))));
此主题相关图片如下:111111111111111.jpg
