Re: Finding text strings in spreadsheets

[Brian Barker]

At 19:52 01/08/2014 +0100, David Eccles wrote:
In Excel it was easy. I simply specified =COUNTIF(G8:X8;"*c*") and I 
got the number of cells that contained the letter c. I discovered in 
LibreOffice it was =COUNTIF(G8:X8;".*c.*") but in Openoffice 
whatever combination I try doesn't work.


That should work in OpenOffice. Go to Tools | Options... | OpenOffice 
Calc | Calculate and ensure that "Enable regular expressions in 
formulae" is ticked. (That's in Preferences under Mac OS.)


I trust this helps.

Brian Barker


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Issue: Opening and saving files is slow

[Julian Thomas]

On Aug 1, 2014, at 12:49, Hélio Figueiredo  wrote:

> Long story short, saving any file, regardless of size, takes several (5-10)
> seconds. This is quite annoying, as I save very often (I write a lot, and I
> don't want to risk losing any of my work).

Have you emptied your trash and defragged your hard drive[s]?

-- -- --
jt   http://jt-mj.net

You will always be lucky if you know how to make friends with strange cats.  
-Colonial American proverb









-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Finding text strings in spreadsheets

[David Eccles]

In Excel it was easy. I simply specified
=COUNTIF(G8:X8;"*c*") and I got the number of cells that contained the
letter c

I discovered in LibreOffice it was
=COUNTIF(G8:X8;".*c.*")

but in Openoffice whatever combination I try doesn't work.

Can anyone help???

Many thanks
David Eccles

Re: Issue: Opening and saving files is slow

[Rory O'Farrell]

On Fri, 1 Aug 2014 17:49:35 +0100
Hélio Figueiredo  wrote:

> Hello. My name is Hélio. I am a long-time user of OpenOffice and love the
> software. I wish to continue using it, but, unfortunately, I've been having
> this problem for a while (over 8 months), and it's really getting on my
> nerves.
> 
> 
> Long story short, saving any file, regardless of size, takes several (5-10)
> seconds. This is quite annoying, as I save very often (I write a lot, and I
> don't want to risk losing any of my work).
> 
> I'm using Apache OpenOffice 4.0.1, as I couldn't even get the 4.1.0 to run
> (after opening anything, it would crash and never open anything ever again
> unless I reinstalled it, restarting the cycle all over again).
> I believe this started when I switched from Windows 7 to Windows 8.1.
> 
> This is not an antivirus issue. I have disabled my antivirus, and the issue
> remains. I have tried disconnecting from the Internet (I searched for a
> solution and this was one of them). I have tried changing the "My
> Documents" folder path on OpenOffice. I have tried resetting my profile (in
> fact, I deleted the whole thing back when I couldn't get the 4.1.0 to run a
> couple of days ago). I tried disabling hardware acceleration (I recalled
> some programs that had an issue with this and decided to try it just for
> the sake of it). My computer is custom-built, with 8 GB DDR3 of RAM, an
> internal 500GB HDD, another, external, 1TB HDD's, i7-4770 CPU @ 3.4 GHz,
> and (not that I think it matters, but I'm no software savvy) an NVIDIA
> GeForce GTX 770 graphics card.
> Short of getting a new OS, I think I've tried just about everything, or at
> least everything I could find. Nothing works. The files are tiny. My
> largest file is 55KB.
> 
> If you could find a solution for this problem, I'd be very grateful.
> 
> 
> To summarize, so that you don't have to go through my email several times
> and write everything down, here are my specs and the version of OpenOffice
> writer I'm using, as well as things I've tried, and some additional
> information:
> OS: Windows 8.1
> RAM: 8 GB DDR3
> Internal HDD: 500GB
> External HDD: 1TB
> CPU: i7-4770 @ 3.4 GHz
> Graphics card: NVIDIA GeForce GTX 770
> Program I'm having trouble with: Apache OpenOffice 4.0.1
> 
> Things I have tried:
> Disabling antivirus
> Resetting OpenOffice profile
> Disabling hardware acceleration on OpenOffice
> Changing the path to "My Documents" on OpenOffice
> Disconnecting my computer from the Internet
> 
> Additional information:
> File size is irrelevant; largest file is 55KB. All files take about the
> same time to save: 5-10 seconds
> 
> 
> Thank you in advance for your time.
> 
> 
> PS: In case anyone has any problems with something that also prevented me,
> at first, from making the upgrade from OpenOffice 3.4.1, I believe, to
> 4.0.1, here's some info about that: although I ran the unpacker as an
> administrator, for some reason, the unpacker could not write there. I don't
> know whether it was because the unpacker was on the external HDD or not.
> The solution was to change the unpacking directory to one on the external
> HDD (which, by default, doesn't require administrator access for anything).

270KB file (text) in 3 seconds on a middle specification machine.
-- 
Rory O'Farrell 

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Issue: Opening and saving files is slow

[Hélio Figueiredo]

Hello. My name is Hélio. I am a long-time user of OpenOffice and love the
software. I wish to continue using it, but, unfortunately, I've been having
this problem for a while (over 8 months), and it's really getting on my
nerves.


Long story short, saving any file, regardless of size, takes several (5-10)
seconds. This is quite annoying, as I save very often (I write a lot, and I
don't want to risk losing any of my work).

I'm using Apache OpenOffice 4.0.1, as I couldn't even get the 4.1.0 to run
(after opening anything, it would crash and never open anything ever again
unless I reinstalled it, restarting the cycle all over again).
I believe this started when I switched from Windows 7 to Windows 8.1.

This is not an antivirus issue. I have disabled my antivirus, and the issue
remains. I have tried disconnecting from the Internet (I searched for a
solution and this was one of them). I have tried changing the "My
Documents" folder path on OpenOffice. I have tried resetting my profile (in
fact, I deleted the whole thing back when I couldn't get the 4.1.0 to run a
couple of days ago). I tried disabling hardware acceleration (I recalled
some programs that had an issue with this and decided to try it just for
the sake of it). My computer is custom-built, with 8 GB DDR3 of RAM, an
internal 500GB HDD, another, external, 1TB HDD's, i7-4770 CPU @ 3.4 GHz,
and (not that I think it matters, but I'm no software savvy) an NVIDIA
GeForce GTX 770 graphics card.
Short of getting a new OS, I think I've tried just about everything, or at
least everything I could find. Nothing works. The files are tiny. My
largest file is 55KB.

If you could find a solution for this problem, I'd be very grateful.


To summarize, so that you don't have to go through my email several times
and write everything down, here are my specs and the version of OpenOffice
writer I'm using, as well as things I've tried, and some additional
information:
OS: Windows 8.1
RAM: 8 GB DDR3
Internal HDD: 500GB
External HDD: 1TB
CPU: i7-4770 @ 3.4 GHz
Graphics card: NVIDIA GeForce GTX 770
Program I'm having trouble with: Apache OpenOffice 4.0.1

Things I have tried:
Disabling antivirus
Resetting OpenOffice profile
Disabling hardware acceleration on OpenOffice
Changing the path to "My Documents" on OpenOffice
Disconnecting my computer from the Internet

Additional information:
File size is irrelevant; largest file is 55KB. All files take about the
same time to save: 5-10 seconds


Thank you in advance for your time.


PS: In case anyone has any problems with something that also prevented me,
at first, from making the upgrade from OpenOffice 3.4.1, I believe, to
4.0.1, here's some info about that: although I ran the unpacker as an
administrator, for some reason, the unpacker could not write there. I don't
know whether it was because the unpacker was on the external HDD or not.
The solution was to change the unpacking directory to one on the external
HDD (which, by default, doesn't require administrator access for anything).

Re: Languages within a document

[jonathon]

On 7/31/2014 11:51 PM, Dale Erwin wrote:
> I realize that Spanish and Catalan are very similar languages, but I don't 
> have Catalan installed and I do have Spanish installed.

My guess is that the language detection scheme does not recognize
"Spanish" as a language. Rather, it recognizes the four or five
languages that comprise Spanish. (That issue erupted around the time the
language detection code was inserted into OOo.)

Unless you either a professional translator, or use write for an Western
Hemisphere (Canada, USA, Mexico, Caribbean, Central America, South
America) audience, it doesn't matter. If you are writing for a Western
Hemisphere audience, then switch language packs so that the Catalan
Effect is less pronounced.

jonathon

-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Languages within a document

[Brian Barker]

At 01:26 01/08/2014 -0500, Dale Erwin wrote:
OK, just now, to test what you are telling me, I opened a new 
document and entered some text in Spanish (nothing else in the 
document) then I highlighted it, clicked on Tools -> Language -> 
Selection and the only two languages offered are English (which is 
checked I presume because English is set as the default language) 
and Catalan.  So I clicked on More, as you suggest, and I get a 
dialog box named "character" with tabs for Font, Font Effects, 
Position, Hyperlink and Background.


Exactly. And on the Font tab you see the Language drop-down menu of 
all the languages. The previous menu is just a quick way - if one of 
the offered languages happens to be appropriate - of making the same 
character setting as is available here.


Brian Barker 



-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Question about openoffice.org

[Станислав Кудрин]

Hi, OpenOffice team

I was searching for some Mac tips today and I came across your awesome
article about download manager for Mac OS X.

Anyway, I couldn't help but notice that you mentioned Speed Download for
Mac on the page.

As you may have heard Yazsoft (Speed download developer team) recently went
out of business and shut down their entire

site (http://www.yazsoft.com/)

You may want to remove their URL from your acticle (
http://www.openoffice.org/download/common/downloadtools.html).

Here's a screenshot of where the link is located:

http://screencast.com/t/rKzVVpZRe

I also used Speed Download, but when they shut it down I tried Folx (
http://www.mac-downloader.com/)

I think this manager can be an awesome replacement for Speed Download

Might be a nice addition to the page :D

Either way, keep doing your awesome work

Cheers

Stan Kudrin

armp...@gmail.com

Re: Languages within a document

[Ariel Constenla-Haile]

Hello Dale,

On Fri, Aug 01, 2014 at 01:51:45AM -0500, Dale Erwin wrote:
> On 8/1/2014 1:26 AM, Dale Erwin wrote:
> >
> >>It really doesn't matter what languages happen to be offered here,
> >>as you can easily select More... at the bottom of the list,
> >>whereupon you can choose from the full set of languages. Spelling
> >>checking will be available in only those languages for which you
> >>have spelling dictionaries installed.
> >>
> >>This method of selecting language sets the local character property.
> >>Remember that you may prefer to do this through character styles or
> >>paragraph styles.
> >
> >
> >OK, just now, to test what you are telling me, I opened a new
> >document and entered some text in Spanish (nothing else in the
> >document) then I highlighted it, clicked on Tools -> Language ->
> >Selection and the only two languages offered are English (which is
> >checked I presume because English is set as the default language) and
> >Catalan.  So I clicked on More, as you suggest, and I get a dialog
> >box named "character" with tabs for Font, Font Effects, Position,
> >Hyperlink and Background.
> 
> That's probably all moot, because I just found a web page:
>  and it says: "A
> Language pack is a type of add-on for OpenOffice.org to get more
> languages integrated without to install more than one Office set. It
> contains only files to display, e.g., menus and dialogs in a specific
> language incl. the spell checking libraries (since OOo 3.2). If
> available the help content is also translated."
> 
> So evidently you are mistaken about the language packs not including
> the spell checking LIBRARIES (not dictionaries), and now I am back at
> square one.  I realize that Spanish and Catalan are very similar
> languages, but I don't have Catalan installed and I do have Spanish
> installed.

Language packs do not include dictionaries, only the full install sets
include them; this is a known issue tracked under
https://issues.apache.org/ooo/show_bug.cgi?id=124473

Dictionaries are extensions, so you have to search for a dictionary in
the extension's site: http://extensions.openoffice.org/

Concerning the list of languages offered on the "Tools"
- "Language"-"For Selection|Paragraph|all text" (you can access
a similar menu from the status bar control that displays the current
language), this list is built from a feature called "language guessing",
and does not depend on the installed dictionaries. "Language guessing"
is just a guess, as its name says, so don't expect it to be 100%
reliable.

Concerning the "Character" dialog that you can open from the menu
"Tools" - "Language" - "For Selection" - "More..." (or from the context
menu: right-click on the selected text and select "Character..."), the
"Language" is an attribute of the "Font", so you will find it on the
"Font" tab, in a list box. This location of the "Language" attribute is
rather misleading, ideally there should be a toolbar item to set the
language - something like
http://aoo-ui-extras.apache-extras.org.codespot.com/git.wiki/LanguageBox_dropdown.png

Also note the original suggestion made by Brian: instead of this way of
settings the language attribute (known as "hard formatting"), it is
better to use styles.


Regards
-- 
Ariel Constenla-Haile
La Plata, Argentina


signature.asc
Description: Digital signature