SpreadsheetAddFreezePane() odd issue

Question

Hello, all,I've got a weird glitch using SpreadsheetAddFreezePane() that I've never seen before.  I'm attaching two screencaps.I am attempting to freeze the top two rows, and columns A through M.The first issue is to the right of column M you can see the content of columns C and D.  If I scroll to the right, it disappears.The second issue is that if I scroll down then up, then the row numbers and the first two rows partially disappear.The code is for a second sheet that is added, after the Excel object has been created and the first sheet populated.SpreadsheetAddFreezePane(sObj,13,2);I'm really confuzzed on this one.  Any thoughts?(BTW.. small family emergency just popped up, and I will be leaving work in about an hour to go check on things, so I probably won't be able to answer any questions until tomorrow.)V/r,^ _ ^

WolfShade · Accepted Answer

I fixed it. I saw an online example of someone else's code, and they used "0" for the second argument (number of columns to freeze). I tried it, and both issues have since disappeared.

Just in case anyone else has this same issue, set your second argument to zero.

SpreadsheetAddFreezePane(sObj,0,2); //Freeze top two rows.

HTH,

^ _ ^

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded