CopyTo, InsertRows & Conditional formatting

Aug 10, 2011 at 2:37 PM

Thanks again for fixing the issue I raised yesterday, works perfectly!

I had a few more questions to throw your way...

- I read in an earlier post that conditional formatting isn't supported by your API, does this mean cells with conditional formatting already applied (in a template say) can't be touched / moved?  Now that the insert rows is fixed I noticed that conditional formatting isn't being pushed down after an insert either.

- I'm trying to clone rows in a sheet, at this stage I'm inserting a row below and copying the source row onto the new row.  I assume that conditional formatting on any source cell wont be copied over to the new row?

Thanks for addressing my first issue so quickly, do you sleep?




Aug 10, 2011 at 3:14 PM

Sleep is overrated.

Any feature not supported is left alone. That means any conditional formatting won't be moved/copied until it's implemented.


Aug 11, 2011 at 12:40 PM

I thought that might be the answer.  Thanks for getting back to me mate.