Re: PEAR Spreadsheet_Excel_Writer setLocked method

Thodoris wrote:

I've used it for some time but never needed to lock a cell. Here is a piece of code that shows how to apply a format to a cell: Hope it helps. I think that by doing something like this: $format_bold->setLocked(); while creating the format could do the trick but it is not tested.

No, this didn't do it. I already have some formats I've created for dollar amounts, right align, etc, and applying the setLocked() method to them had no affect. Skip -- ==================================== Skip Evans Big Sky Penguin, LLC 503 S Baldwin St, #1 Madison WI 53703 608.250.2720 http://bigskypenguin.com ------------------------------------ Those of you who believe in telekinesis, raise my hand. -- Kurt Vonnegut