John Gregson wrote:
>
> Terry
> ----- Original Message -----
> From: "TerryJ" <[EMAIL PROTECTED]>
> To: <users@openoffice.org>
> Sent: Friday, March 30, 2007 5:56 PM
> Subject: Re: [users] Calc problem
>
>>
>> John Gregson wrote:
>>>
>>> <snip>
>>>
>>> I imported a spreadsheet from MS Excel 2003 into Calc without any
>>> problems.
>>> This spreadsheet contains mostly text, with no formula.
>>>
>>> When checking the imported spreadsheet I noticed a very minor spelling
>>> error; this error was also in the Excel spreadsheet.
>>> This error was in a 'window' (my term) that is part of the Excel
>>> Spreadsheet. This window does not contain any lines for rows or columns;
>>> it
>>> only contains text that I have manually typed in.
>>> This is a NOTE window containing comments on the data in other parts of
>>> the
>>> spreadsheet.
>>>
>>> In Excel I can easily edit this text, but in Calc I cannot.
>>>
>>> When I select this 'Note window', in Calc, I get 8 green squares, and an
>>> Anchor icon at the upper left corner.
>>> The size of this 'Window' is 7 col x 8 rows
>>>
>>> The cursor changes to one with 4 tiny arrows.
>>>
>>> How do I edit my text in this window?
>>>
>>> The fact that I can import this 'window' from Excel into Calc implies,
>>> to
>>> me, that Calc recognizes this 'window'; but I just do not know how to
>>> work
>>> with it.
>>>
>>> I went through the chapter on Calc but could not find anything that
>>> helps
>>> me.
>>> <snip>
>>>
>>> I have since learned from the support forum that the above problem is a
>>> 'bug' in Calc ??
>>>
>>> If so, then please forgive this posting, but I do want to see if I can
>>> indeed post to the List.
>>>
>>> John Gregson
>>> Dawson Creek, BC Canada
>>> [EMAIL PROTECTED]
>>>
>>>
>>
>> Welcome. I'm using an older version of the software but I doubt that
>> this
>> much has changed.
>>
>> You probably need to get the "window" into what is called "Design Mode".
>> <snip>
>
> Thanks for your feed-back; but that did not solve the problem.
>
>
> John.
>
>
It's hard to know without seeing the file. I've just inserted a plain text
document into my test spreadsheet using Insert >Object >OLE object. When I
right-click on that I get a context menu which includes "Edit". If I select
"edit", I can amend the inserted object. Do you by any chance see anything
like that?
My suggestion is that you copy as much of the document as necessary to a new
document (i.e. omitting all sensitive information) and upload it for others
to examine. This host is often used for such a purpose:
http://www.mytempdir.com/
--
View this message in context:
http://www.nabble.com/Calc-problem-tf3494922.html#a9764126
Sent from the openoffice - users mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
