OpenOffice problem
in [Suse]
|
Prev: Nedit in kde4
Next: strange sound behavior
From: Baron on 25 Jan 2010 14:37 Will Honea Inscribed thus: > Baron wrote: > >> Will Honea Inscribed thus: >> >>> 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. That's a real PITA when openSUSE creates the default user >>> folder >>> "Documents" and/or the linked file name is upper/mixed case. I've >>> used this spread sheet for several years but it only gets dusted off >>> about once a year when the wife needs grade stats for all her >>> classes (she teaches elementary music so that maps to 25 classes >>> with some 700 students - no fun to work >>> piecemeal!) so I just now caught the error. I've got oo versions >>> back to 3.0.0.9 loaded around here so this has to have crept in at >>> or before that since I've used Calc with this for at least 6 years. >>> Has anyone else seen >>> this? If so, any ideas on how to beat it? Short of a work around, >>> I'm going to have to revert one of these boxes to something like >>> 2.4.3 just to save myself lots of grief - or see if I can make it >>> work in Excel. >>> >> >> Create a link to the required file and then call the link. >> > > I thought of that. It gets messy even that way since the entire path > to the link pasted into the spread sheet has to be all lower case The full path will be in the link, I agree, but the link should be placed where OO can see it without having to use the full path. Have you tried creating the link in the Documents folder. > but on further thought that does suggest a change to the spread sheet > that addresses another aspect. In practice, the data source files > change names every year as teachers shuffle in and out or change > assignments and some submit data files in .xls (Excel format) while > others have seen the light and use oo and submit .ods files. The link > idea (if it works) would take care of having to change the spread > sheet in multiple places - which means you always miss a > few - every time a data source changed file name/location/format. > Change the link in a single place and not the spread sheet in multiple > places - that I like! > Anything that makes the job easier. ;-) -- Best Regards: Baron.
From: Will Honea on 25 Jan 2010 15: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. For the time being, I found a work-around. If I use the Edit -> Links function to change the bogus name that direct entry inserts I get the right result. I have to get the original link entered, change capitalization on the page names - which I can do globally in short order - then Edit -> Links to correct the file name. Apparently, links are global to the spread sheet so this gets SWMBO off my back for now. I'll look at my options settings anyway - it would be nice to skip all the fiddling around in the future. I'll post back if that clears the issue - maybe it will keep someone else from fighting the same battle. -- Will Honea
From: Will Honea on 25 Jan 2010 16:44 watnne(a)googlemail.com wrote: > Use Excel! > > On Mon, 25 Jan 2010 14:22:03 -0500, Lew Pitcher > <lpitcher(a)teksavvy.com> 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 >>-- >>Lew Pitcher >>Master Codewright & JOAT-in-training | Registered Linux User #112576 >>Me: http://pitcher.digitalfreehold.ca/ | Just Linux: http://justlinux.ca/ >>---------- Slackware - Because I know what I'm doing. ------ >> >> > > > HELP! I CAN'T STOP TYPING IN CAPITAL LETTERS UNDER WINDOWS! Wayne, Excel just became a non-player although I used it interchangeably for years. This spread sheet started several years back as a favor for the wife and worked under Excel (2000) as well as first Star Office then OpenOffice. The school has more than doubled in both student enrollment and faculty, to the point that this spread sheet now blows Excel 2000 or 2003 out of the water - too many formulas and too much memory required. Office 2007 or 2010 may handle it but I'm not about to shell out the bucks for something like this. -- Will Honea
From: John Bowling on 25 Jan 2010 22:54 Will Honea wrote: > watnne(a)googlemail.com wrote: > >> Use Excel! >> >> On Mon, 25 Jan 2010 14:22:03 -0500, Lew Pitcher >> <lpitcher(a)teksavvy.com> 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 >>>-- >>>Lew Pitcher >>>Master Codewright & JOAT-in-training | Registered Linux User #112576 >>>Me: http://pitcher.digitalfreehold.ca/ | Just Linux: http://justlinux.ca/ >>>---------- Slackware - Because I know what I'm doing. ------ >>> >>> >> >> >> HELP! I CAN'T STOP TYPING IN CAPITAL LETTERS UNDER WINDOWS! > > Wayne, Excel just became a non-player although I used it interchangeably > for years. This spread sheet started several years back as a favor for the > wife and worked under Excel (2000) as well as first Star Office then > OpenOffice. The school has more than doubled in both student enrollment > and faculty, to the point that this spread sheet now blows Excel 2000 or > 2003 out of the > water - too many formulas and too much memory required. Office 2007 or > 2010 may handle it but I'm not about to shell out the bucks for something > like this. > Ask everyone to install OpenOffice and that problem should go away.
From: Volker Lenhardt on 26 Jan 2010 02:05
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 |