Re: OpenOffice problem
- From: Will Honea <whonea@xxxxxxxxx>
- Date: Tue, 26 Jan 2010 11:56:16 -0700
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@xxxxxxxxx wrote:
I'm having a problem with a spread sheet in oo. When I enter the path[snip]
to another spread sheet in a formula, Calc forces the entire path to
all lower case.
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
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
-> Optionen (Options?)
-> Spracheinstellungen (Language Settings?)
-> Linguistik (Linguistics?): Optionen (Options?)
Good luck searching.
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 practiceof 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
- Prev by Date: squid with login and password
- Next by Date: Re: Avoid while on line, apache & X as root?
- Previous by thread: Re: OpenOffice problem
- Next by thread: strange sound behavior