Avance Zone

Qtn: Unable to give the AutoFit

Ans: Chosse the rows that you want to autofit. and select height as “default” and  select “Optimal Row height” even you can wrap the Text/Values if needed in column properties.

Qtn: Directly can’t able to edit and update the files from any Web portal.

Ans: You can update the files by setting OpenOffice as the default application for those file types. Also you can use “Web-Wizard” in files menu to convert any document to web page.

Qtn: Unable to insert the row or column in merged cell

Ans: Download the package from http://extensions.services.openoffice.org/node/2092 .By installing the above macro package the problem of inserting/deleting of merged rows/columns would be solved .Goto Tools –> macro–> Run macho –> CalcEasyToolbar –> Insert row

Unable to insert the row or column in merged cell

Qtn: “Contains “ Option not available while Filter

Ans: This Feature can found in standard filter –> Regular expressions –> .*<Enter The Filter Word>.* (Even You can use Not Contains by suing <> instead of = )

`

Qtn: Unable to view the MS Object icon in the Open office

Ans: You will find Open Office Objects , Similar and Equivalent to MS Office Objects where you can insert any objects like (Chart, Drawing,Presentation, Text, Formula)

Qtn: Mouse Over option while inserting the Object is not working in Open Office

Ans: You can fine all the options you once inserted like (position,size,arrangement,edit etc). If you mean some additional actions when hovering , you can use macho in OpenOffice. Even You can Edit the objects live.