Apparently both may be a problem? I did see a properties window in Calc that
reported a read only status once, but Calc now has the format cells choice
greyed out, even if opened from a hard drive folder (with read only
attribute cleared).
I read Sandy's explanation (after I had already replied to her first
response). She said that Calc opens files with protection enabled by default
(for all cells!).
It seems to me that opening an Excel spreadsheet (without changing cell
protection status) like it would be opened by MS Office, is the right way
for open office Calc to work? And it seems likely that Calc might lose Excel
formatting information when saving?
All cells should not be protected by default, because even if cell protect
status could be changed back by selecting the right range of input cells,
this is too much work for non computer types to do.
I guess it would be more difficult for open office Calc to look at the Excel
file to see what cell ranges are protected, and what ranges are not
protected?
----- Original Message -----
From: "Kirill S. Palagin" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, November 16, 2006 4:29 PM
Subject: RE: [users] Excel spreadsheets should not open with cells protected
So the problem is that Calc does not allow modifications to file with
"read-only" attribute set in file-system? Or the file misbehaves in Calc
even if opened from harddrive (with readonly attribute cleared)?
-----Original Message-----
From: Hubert Fitch [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 16, 2006 4:28 PM
To: [email protected]
Subject: Re: [users] Excel spreadsheets should not open with
cells protected
Thanks for the reply Sandy!
Perhaps I am giving too much information, but I hope that it
is interesting to everyone who reads it?
I want to provide my CD book customer with a way to use
spreadsheets if he/she does not have Execl(r), and want to
include an install open office option on my book CD.
I have written a book on CD using web style pages with many
hyperlinks.
Hyperlinks open a copy of an application file in a temporary
folder. This is ok for html pages. However, I want to call
spreadsheets from hyperlinks, so I must link to a batch file
which will call the spreadsheet file, so that it can have its
full pathname, and open there. This allows a spreadsheet to
be saved to its correct folder and with the same filename.
If I did not do this, the normal web browser operation will
cause the customer changed spreadsheet file to be saved to
the correct filename the first time (but not to the original
file, only to a copy, in a temporary folder). For any
additional save, it will be assigned a new random file name
(to prevent two files from having the same filename).
So, if I use a command window batch file that forces the
spreadsheet to open in its original folder, and write to the
original application filename, the customer's modified
spreadsheet will be saved properly.
Installation of my book CD is by an autorun.inf file, which
copies all the html, png, xls files to the customer's
computer. Now whenever a spreadsheet file is opened, it must
have the columns of data cells to be in the same unprotected
state as when the spreadsheet file was originally created.
If the Excel(r) file is opened by open office as write
protected (read only), or with input data cells protected, it
is unusable.
In a previous version of open office 1.1.5 this worked
properly, and my spreadsheets open ready for input data. But
in verison 2.0.4, I have seen two problems. Files open with
cells protected. I tried unprotecting cells, and once I was
able to do it with some extra work (which my customer would
not appreciate!).
The next time I opened a spreadsheet file in open office, the
format cells option was greyed out, and I could not find a
way to change to unprotected cells.
While searching for a way to do this, a window said that the
file was read only (box checked). But when checking the file
in Windows Explorer, the file is NOT read only (box unchecked).
I am about ready to give up on open office as an option for
my book customers.
If this is a bug that can be easily fixed, then I do still
want to include an open office install option. But to do so,
I must create new book CD's including open office install option.
Thanks for any Help!!!
Hubert Fitch
----- Original Message -----
From: "Sandy" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, November 16, 2006 1:03 AM
Subject: Re: [users] Excel spreadsheets should not open with
cells protected
> Hubert Fitch wrote:
>> My Excel spreadsheets must open like they were created,
with desired
>> columns of input cells unprotected.
>>
>> How can I change the behaviour of open office which adds
protection when
>> spreadsheets are opened, so that my customers can
immediately use their
>> spreadsheets as they have always been able to do in the past?
>>
>> Hubert Fitch
>
> Perhaps you could clarify what is happening.
>
> You use OpenOffice Calc to create an .xls spreadsheet.
When someone uses
> Excel to open the spreadsheet, cells have somehow become
protected. Is
> that it? (I cannot test it myself but others who have both
software
> applications may do so.)
>
> --
>
> If you're seeking, check out http://www.rci.org.au
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
