Simple clear advice in plain English

Microsoft dismisses OpenOffice password removal

Cell protection 'not a security issue' says Microsoft

Microsoft has played down a feature in open source rival OpenOffice.org that removes some password protection on Office applications.

When users open someone else's Excel file in OpenOffice.org's Calc (the OpenOffice equivalent of Excel) it removes any password protection applied to cells and worksheets by the author, so that hidden information can be read, edited and saved.

It is still possible to protect an entire Excel document with passwords. But removing cell and sheet protection could lead to accidental changes being saved by others sharing an Excel document in OpenOffice.org.

The same is true for any password protection applied to elements of a Word document opened using OpenOffice.org's Writer application.

Darren Strange, Office product manager at Microsoft, said that although the open source community had "not respected" the feature and that it could could present "a bit of a problem" to Office users, it was not "security feature".

"It works well for us but it is not a feature other vendors with different functionality would neccesarily have to implement. OpenOffice is not circumventing any security in Office here," said Strange.

He pointed out that the next version of Office, 2007 will include a beefed-up set of Information Rights Management tools, which will offer a higher level of security. Microsoft claims it will prevent screengrabs from being taken of sensitive documents.

John McCreesh, marketing project co-lead for OpenOffice.org, said that the removal of protection passwords from Excel files was a feature of Calc, not a bug.

He argued that OpenOffice users are warned that saving in the Excel format will remove the password. But he could not say how Excel users who create a file that will be used by others can protect hidden information from OpenOffice users.

Anyone that wants to protect passwords that will be opened in different spreadsheet applications should instead use the Oasis OpenDocument file format, which includes password protection, argued McCreesh.

"The user has already been warned that saving in Excel format will not be password protected; they then have to choose OpenDocument Format, where the 'Save with password' option is clearly visible," he said.

The Excel file format, he added, is a "dying legacy".

More information on protecting Excel files can be found on the Microsoft KnowledgeBase.

Reader Comments

   

Add your comment

All fields must be completed. Your email address will not be displayed or used to send marketing messages.

All messages will be checked by moderators before appearing on the site.

See our Privacy Policy for more information.

Related articles

Maintain a monthly budget illustration

Keep a firm grip on your finances

With everyone feeling the financial pinch, free software can help you create a monthly budget planner so that you know exactly where your money is going

libre-office

Libre Office – complete office suite

An alternative version of Open Office is released that doesn't cost a penny

337-f3-lp

How to sort lists easily in Word, Excel and Open Office columns

Microsoft Office and Open Office word processing and spreadsheet programs have simple ways of sorting lists of data in tables and spreadsheets

Question & Answer

Q.Why can't my browser find the website address I typed...

> Read the answer

Q.All updates have been downloaded, so why won't Windows...

> Read the answer

Q.How do I stop Windows 7 search?

> Read the answer

Best deals on the web

img

Apple iMac 21.5" (MC309)

£929.00- Buy it now

img

Dell Inspiron 620 ST Intel Core i3-2100 3.10GHz / 3GB / 500GB / DVDRW / Win 7 Home Premium

£299.00- Buy it now

img

Apple iMac 27" (MC813)

£1353.99- Buy it now

Great benefits for subscribers!

Most popular articles

Poll

Which is your preferred web browser

Jargon Buster

Computing terms explained in plain English

CAD

Computer Aided Design. Software used to create 3D models.

Great shopping deals from Computeractive