Prev: Nedit in kde4
Next: strange sound behavior
From: Will Honea on 26 Jan 2010 13:56
Volker Lenhardt wrote:

> Will Honea schrieb am 25.01.2010 21:52:
>> Lew Pitcher wrote:
>>
>>> On January 25, 2010 02:44, in alt.os.linux.suse, whonea(a)yahoo.com wrote:
>>>
>>>> I'm having a problem with a spread sheet in oo. When I enter the path
>>>> to another spread sheet in a formula, Calc forces the entire path to
>>>> all lower case.
>>> [snip]
>>>
>>> I can't recreate your problem in my OpenOffice Calc. But, then again,
>>> I've fiddled with the default settings to get it to work the way I want.
>>> Perhaps one of the default settings is fouling your spreadsheet up.
>>>
>>> Check the values in Tools -> Options -> Language Settings -> Writing
>>> Aids Uncheck the options that have to do with capitalization, and see if
>>> that makes a difference.
>>>
>>> FWIW, I have
>>> Check spelling as you type,
>>> Check uppercase words,
>>> Check words with numbers, and
>>> Check capitalization
>>> all unchecked.
>>>
>>> HTH
>>
>> That sounds like what I probably need but for some reason I missed that
>> particular set of options.
>
> Maybe it's placed at a slightly different location. With me (German
> local) it's
> Extras (Tools?)
> -> Optionen (Options?)
> -> Spracheinstellungen (Language Settings?)
> -> Linguistik (Linguistics?): Optionen (Options?)
>
> Good luck searching.
>
> Volker

Found it. Also found the root problem.

I do a lot of work mixing both Excel and oo formatted spread sheets, often
with a mix of formats among a bunch of different files. I can't pin down the
exact sequence but it appears that the tools -> options -> OpenOffice.calc -
> formulas setting for formula syntax is getting mixed up by this practice
of multiple spread sheets in multiple formats can confuse this setting. All
the machine I have problems with have had this setting changed to Excel A1
from the default (and expected) Calc A1. Simple experiments show that the
Excel A1 setting forces lower case on the file path string. This has to be
an effect of the loaded spread sheets - I don't recall EVER looking at that
setting; didn't even realize it existed - and the system is getting lost in
the shuffle. In the one system, even manually changing the setting would
not stick (or have any effect). I can force the problem by loading a bunch
of Excel spread sheets from Excel 2000 intermixed with a bunch of oo spread
sheets, each with a lot of formulas.

Looks like the answer is to avoid the problem is to work with one type
spread sheet at a time, especially when a lot of complex formulas are
involved.

--
Will Honea

First  |  Prev  | 
Pages: 1 2 3
Prev: Nedit in kde4
Next: strange sound behavior