You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Karl-Heinz Zengerle <ka...@sawag.com> on 2004/03/23 18:33:44 UTC
Is it possible ...?
Hi world.
Is it possible to
- get and set sheltering mechanisms of Excel (e.g. for the
sheet; not allowing users to change something)? If yes what classes
would have to be used?
- Do so something with macros e.g. getting them. If yes what
classes would have to be used?
Regards,
Karl-Heinz Zengerle.
AW: Is it possible ...?
Posted by Karl-Heinz Zengerle <ka...@sawag.com>.
Thanks Avik.
We didn't want to parse them. So it's obviously that we can see them
(and possibly also write them back with modified code).
Regards, Karl-Heinz.
-----Ursprüngliche Nachricht-----
Von: Avik Sengupta [mailto:avik.sengupta@itellix.com]
Gesendet: Donnerstag, 25. März 2004 17:13
An: POI Users List
Betreff: Re: Is it possible ...?
AFAIK, you can protect a sheet. You cant protect individual cells or
ranges with POI.
Macros are are different OLE stream, it does not get into HSSF at all
(only the workbook stream does). POIFS will give you a handle to the raw
stream, but we currently dont have anything that will parse it. I dont
know how difficult that is.
Regards
-
Avik
On Tue, 2004-03-23 at 23:03, Karl-Heinz Zengerle wrote:
> Hi world.
>
> Is it possible to
>
> - get and set sheltering mechanisms of Excel (e.g. for the
> sheet; not allowing users to change something)? If yes what classes
> would have to be used?
> - Do so something with macros e.g. getting them. If yes what
> classes would have to be used?
>
> Regards,
> Karl-Heinz Zengerle.
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org
Re: Is it possible ...?
Posted by Avik Sengupta <av...@itellix.com>.
AFAIK, you can protect a sheet. You cant protect individual cells or
ranges with POI.
Macros are are different OLE stream, it does not get into HSSF at all
(only the workbook stream does). POIFS will give you a handle to the raw
stream, but we currently dont have anything that will parse it. I dont
know how difficult that is.
Regards
-
Avik
On Tue, 2004-03-23 at 23:03, Karl-Heinz Zengerle wrote:
> Hi world.
>
> Is it possible to
>
> - get and set sheltering mechanisms of Excel (e.g. for the
> sheet; not allowing users to change something)? If yes what classes
> would have to be used?
> - Do so something with macros e.g. getting them. If yes what
> classes would have to be used?
>
> Regards,
> Karl-Heinz Zengerle.
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
For additional commands, e-mail: poi-user-help@jakarta.apache.org