Ask Your Question
2

Partially protected Excel spreadsheets import completely protected [closed]

asked 2013-08-13 21:56:29 +0200

sarexpert gravatar image

updated 2014-03-19 22:39:10 +0200

manj_k gravatar image

I have been trying to import vendor supplied excel spreadsheets that have cell by cell protection. I am not supplied the password. When these spreadsheets are read by excel, the individual entry blocks and form devices work properly.

When these spreadsheets are imported into LibreOffice Calc, the entire sheet is protected, and the cells which are editable in excel are protected in Calc, along with all the cells that are intended to be protected.

This appears to be a sheet by sheet issue, because many of these have several sheets that can be edited, but other sheets are completely protected.

Is there a workaround, assuming that I cannot acquire the passwords?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-14 19:49:27.059125

Comments

I Have the same issue, using LO 4.1.2.3, and I am confident this was not an issue in the 4.0 series as I was using the same document previously. I can reproduce this with two different documents from two different suppliers. Do you still have this problem? Have you found a bug report? A work-around?

chtfn gravatar imagechtfn ( 2013-11-20 07:06:05 +0200 )edit

1 Answer

Sort by » oldest newest most voted
1

answered 2013-11-20 07:23:52 +0200

chtfn gravatar image

There is a bug report for this issue on the LibreOffice bug tracker:

Bug 70499 - FILEOPEN Cannot select unprotected cells in XSLX sheet with worksheet protection

I believe this corresponds to your problem. If so, could you mark it as affecting you too?

edit flag offensive delete link more

Comments

1

fdo#70499 Status: RESOLVED FIXED (LibreOffice 4.1.5 / 4.2.0)

manj_k gravatar imagemanj_k ( 2014-03-19 22:38:38 +0200 )edit

Question Tools

1 follower

Stats

Asked: 2013-08-13 21:56:29 +0200

Seen: 892 times

Last updated: Nov 20 '13