Zoom size for a sheet in calc

[Manikandan]

Dear all,

I am developing a VB Application to export data into a calc file. Here, I need to set the zoom size for a sheet. I have written the following code.

Code: Select all

        Dim oController As Object
        Set oController = oDoc.getCurrentController().viewsettings
        oController.ZoomType = 3
        oController.ZoomValue = 75

It does not set the size for a sheet . it set for the whole doucment.

Any help would be appreciated.

Mani



Please don't double-post the same question in different areas of the forum. I have locked this thread. Please continue the conversation in your previous thread. See: The Survival guide (TheGurkha, Moderator)