Re: OpenOffice problem

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
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

.

Relevant Pages

  • Re: knitters graph paper
    ... I use Excel to create intarsia patterns and to rewrite patterns that ... I have also used Excel to take a part of a chart ... was the cells were never the correct ... I am very familiar with spread sheets and have used them ...
    (rec.crafts.textiles.yarn)
  • Help in Excel
    ... I am trying to extract data from some ... excel spread sheets created from 2004 to 2009 on a monthly basis. ... The requirement is to find out how much i have spent on medical expenses ...
    (microsoft.public.excel.programming)
  • Excell and use of resources
    ... run on windows XP professional PC's and Windows 200 ... The Spread sheets themselves are stored on ... Excel 2002, users are getting the message "Excel cannot ... less data or close other applications". ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Excel MS Office 2003
    ... works as a excel ss file and then open it under Microsoft office excel. ... "Chip Pearson" wrote: ... >> can run to convert the spread sheets? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: if youve accidentally saved a huge spreadsheet as a web doc...
    ... There should be a file named *.htm in the folder that holds the *_files folder. ... You should be able to open that *.htm file directly (let excel worry about all ... mom is an accountant and works with lots of spread sheets - one of the ... project managers, who is not very computer savvy at all, accidentally saved a ...
    (microsoft.public.excel.misc)