Figure 1, figure 2. PB10.0 calls OLE controls to generate EXCEL, with SUMPRODUCT function inside the

C17 can normal execution=SUMPRODUCT ((MOD (ROW (C3: C16), 2)=1) * C3: C16)
C18 cannot normal execution=SUMPRODUCT ((MOD (ROW (C3: C16), 2)=0) * C3: C16)

By clicking on the embedded can Export Excel normal execution after the Export button, as shown in figure 3

Excuse me, how to make the C18 normal display, thank you.

CodePudding user response:

CodePudding user response:

https://blog.csdn.net/iko2008/article/details/5342512
See if there was help
I think this kind of situation is considered several possible
1. The control is not normal initialization
2. Call the EXCEL file itself can't calculate, or version,
2. The control without this feature, or need to pb, control itself later,