I'm running LibreOffice 3.4.6 OOO340m1 (Build:602) on Debian Squeeze.
The progress bar on the splash screen stops part-way during startup for about
10 seconds. During this time LO sends a request of some sort over the network
connection (lights flash on router) every 2 seconds, 5 times in all.
On 07/18/2012 09:22 PM, Larry Blanchard wrote:
Hi Larry,
I purged OO and installed LO. Still using Ubuntu 10.04.
Did you also purge (or otherwise rename) your OOo user configuration
folder ?
If I open one of my databases in LibreOffice 3.5.4.2 it works fine. If
I open the other, I
Original Message
From: rhubarbpie...@gmail.com
To: users@global.libreoffice.org
Date: Thu, 19 Jul 2012 16:48:53 -0500
I'd like to create a macro for a user-defined date format (H:MMa/p). As
examples, 7:00 AM would display as 7:00a and 3:33 PM as 3:33p. I can
create the
I have received an xls spreadsheet created in Office which contains charts.
But the charts appear blank - there are bars/columns on sheet 2 and
graphs/lines on sheet 3. You can find the spreadsheet
http://www.btinternet.com/~dsergeant/cadismay.xls here
(because of the nature of the file, I
Johnny,
I suppose you have to run the check 2 Times, first SearchType = 0 here
we find if there is a formula use .
then SearchType 1 on the found area
the SearchString has a different meaning , depending on the .SearchType
= 1 then the SearchString is the is the result of the formula or the
Am 19.07.2012 23:48, rhubarbpie...@gmail.com wrote:
but I understand the LibreOffice format
can't save user-defined formats.
The entire suite is about customization rather than programming.
Templates and styles provide most of the productivity features. Macros
(particularly recorded ones)
Am 20.07.2012 09:28, davews wrote:
The file displays properly in MS Excel viewer.
Use the Excel viewer or http://gnumeric.org which lets you view and edit
the file.
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems?
Am 19.07.2012 07:02, NoOp wrote:
On 07/18/2012 11:12 AM, Andreas Säger wrote:
I did not reply to your bloody mailing list. I used a server named
nabble.documentfoundation.org which shows the whole topic on a web-page.
Ah, a web-pager... wrong tool for the job eh? Using nabble, gmane.org,
etc
On 20/07/12 08:53, Andreas Säger wrote:
Am 20.07.2012 09:28, davews wrote:
The file displays properly in MS Excel viewer.
http://gnumeric.org which lets you view and edit the file.
Interesting - I wonder why Gnumeric would render the document correctly
when LO doesn't
--
For
Hi :)
Gnumeric is pretty awesome but it's only the spreadsheet so the whole project
can focus on purely that type of functionality. LibreOffice has a lot of
distractions away from just spreadsheeting. :)
Regards from
Tom :)
--- On Fri, 20/7/12, Gordon Burgess-Parker gbpli...@gmail.com
Using styles I get it to work. It's a pity though that one can't simply
set isLocked.
Graham
On 19 July 2012 13:35, Johnny Rosenberg gurus.knu...@gmail.com wrote:
2012/7/19 Graham Luffrum grhmlf...@gmail.com:
Hi,
I am trying to write a macro that will, amongst other things, lock a
Hi,
davews schrieb:
I have received an xls spreadsheet created in Office which contains charts.
But the charts appear blank - there are bars/columns on sheet 2 and
graphs/lines on sheet 3. You can find the spreadsheet
http://www.btinternet.com/~dsergeant/cadismay.xls here
(because of the
Regina Henschel wrote
Hi,
davews schrieb:
I have received an xls spreadsheet created in Office which contains
charts.
But the charts appear blank - there are bars/columns on sheet 2 and
graphs/lines on sheet 3. You can find the spreadsheet
2012/7/20 Fernand Vanrie s...@pmgroup.be:
Johnny,
I suppose you have to run the check 2 Times, first SearchType = 0 here we
find if there is a formula use .
What do you mean? Use . as the search string? Regular expressions
set to what? True?
then SearchType 1 on the found area
Area? You
On 07/20/2012 02:44 AM, Robert Mesibov wrote:
I'm running LibreOffice 3.4.6 OOO340m1 (Build:602) on Debian Squeeze.
The progress bar on the splash screen stops part-way during startup for about
10 seconds. During this time LO sends a request of some sort over the network
connection (lights
Hi Robert,
This has worked for me in all recent versions of Ubuntu:
In terminal, do gksudo gedit /etc/hosts
Add line as shown below for, for instance, 127.0.0.1 galaxy localhost
galaxy.(none) below
127.0.0.1 localhost
127.0.1.1 galaxy
4) and add a line so it looks like this:
127.0.0.1
Try my SpecialCells extension which selects combinations of cell types:
http://user.services.openoffice.org/en/forum/download/file.php?id=11048
--
View this message in context:
http://nabble.documentfoundation.org/Searching-for-empty-cell-LibreOffice-BASIC-macro-tp3996513p3996615.html
Sent
Hi :)
This guide might help with the User Profile and getting things back to factory
defaults
http://wiki.documentfoundation.org/Documentation/UserProfile
Good luck and regards from
Tom :)
--- On Fri, 20/7/12, Alex Thurgood alex.thurg...@gmail.com wrote:
From: Alex Thurgood
Don Myers wrote:
Hi Robert,
This has worked for me in all recent versions of Ubuntu:
In terminal, do gksudo gedit /etc/hosts
Add line as shown below for, for instance, 127.0.0.1 galaxy localhost
galaxy.(none) below
127.0.0.1 localhost
127.0.1.1 galaxy
4) and add a line so it looks like this:
Please explain further ...
are you perchance saying that knowing my OS, you could access my
computer for any file on it? [surely, I'm missing something here]
are you perchance saying the OSs hold the OO/LO files from the
past to the present? [interesting concept; I'm
I have the 3.4.6 install files, so if I was to make them available, I
would need to know which OS you use [Windows, Linux, Mac] so I do not
need to upload all of them to a place where you can download them.
BUT, I remembered there the LO Archive pages is located, so I do not
need to do
You may also try using the cell range and calling GetDataArray() to get
all of the data including numbers and strings. If you are simply running
through about 2000 cells, this should be very fast, especially if you
know that the cells are filled sequentially because then you can use a
binary
Hi :)
Lol, blimey!
Xp is not the world's most secure OS but even so it's still pretty difficult
for most people to gain access to your machine. It's still best not to give
out your ip address to everyone if you can avoid it jic though, especially
in on-line forums or mailing-lists.
It's
The outline for the FROM clause for a LEFT OUTER JOIN is
FROM “table1 name” LEFT OUTER JOIN “table2 name” ON “table1
name”.”foreign key” = “table2 name”.”primary key”
This is what I entered into a query yesterday. Yet, today when I
edited the query in SQL view I saw
FROM { OJ
If you have the proper software firewall installed, I use Comodo [free
version] for my Windows machines, then it is very hard even for the
experts to get access to your computer.
I did not see the start of the thread, so I did not know if you used
Windows or something else.
I use Windows
On 07/20/2012 09:51 AM, Dan wrote:
The outline for the FROM clause for a LEFT OUTER JOIN is
FROM “table1 name” LEFT OUTER JOIN “table2 name” ON “table1
name”.”foreign key” = “table2 name”.”primary key”
This is what I entered into a query yesterday. Yet, today when I
edited the query in SQL
On Fri, 2012-07-20 at 09:51 -0400, Dan wrote:
The outline for the FROM clause for a LEFT OUTER JOIN is
FROM “table1 name” LEFT OUTER JOIN “table2 name” ON “table1
name”.”foreign key” = “table2 name”.”primary key”
This is what I entered into a query yesterday. Yet, today when I
2012/7/20 Andreas Säger ville...@t-online.de:
Try my SpecialCells extension which selects combinations of cell types:
http://user.services.openoffice.org/en/forum/download/file.php?id=11048
Okay, I didn't install any extensions before, at least not since quite
a along time ago. So I grabbed
Thanks to Drew, we now have a service that will print-on-demand a copy
of the LibreOffice North American Community DVD - version 3.5.5.
Here is a link for a direct retail page:
http://kunaki.com/sales.asp?PID=PX00B1FF2L
Kunaki handles all the payment collection.
The DVD is $5 plus
2012/7/20 Andrew Douglas Pitonyak and...@pitonyak.org:
You may also try using the cell range and calling GetDataArray() to get all
of the data including numbers and strings. If you are simply running through
about 2000 cells, this should be very fast, especially if you know that the
cells are
2012/7/20 Johnny Rosenberg gurus.knu...@gmail.com:
2012/7/20 Andreas Säger ville...@t-online.de:
Try my SpecialCells extension which selects combinations of cell types:
http://user.services.openoffice.org/en/forum/download/file.php?id=11048
Okay, I didn't install any extensions before, at
On 07/20/2012 09:06 AM, Dan wrote:
Don Myers wrote:
Hi Robert,
This has worked for me in all recent versions of Ubuntu:
In terminal, do gksudo gedit /etc/hosts
Add line as shown below for, for instance, 127.0.0.1 galaxy localhost
galaxy.(none) below
127.0.0.1 localhost
127.0.1.1 galaxy
4)
drew jensen wrote:
On Fri, 2012-07-20 at 09:51 -0400, Dan wrote:
The outline for the FROM clause for a LEFT OUTER JOIN is
FROM “table1 name” LEFT OUTER JOIN “table2 name” ON “table1
name”.”foreign key” = “table2 name”.”primary key”
This is what I entered into a query yesterday. Yet,
Which version of LO is the latest and/or most bug free that will run on
the Powerbook G4?
--
Ken
Mac OS X 10.6.8
Firefox 14.0.1
Thunderbird 14.0
LibreOffice 3.5.2.2
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems?
Tom wrote:
It's usually possible to set-up some special area that can be shared with
other computers on your house or work-place network but even that can be
quite tricky. Trying to get your machine to act like a server is quite
challenging.
You can use services such as Google Drive or
Le 20/07/12 17:23, Ken Springer a écrit :
Which version of LO is the latest and/or most bug free that will run on
the Powerbook G4?
Apparently, this one :
http://www.libreoffice.org/download/?type=mac-ppclang=en-USversion=3.5.5
However, the term bug free is too relative to be of any
Ken Springer wrote:
Which version of LO is the latest and/or most bug free that will run on
the Powerbook G4?
LO 3.5.5 seems to be as bug free as any of them.
Start with this web page: http://www.libreoffice.org/download/
If it does not recognize you have a Powerbook G4, click on Change
Hi,
I am trying out Atlassian Confluence, which allows the pages it manages
to be exported in Word format (.doc). If I load such a file in Word, it
works, but LibreOffice will instead first provide a ASCII Filter
Options popup, and then opens the document as if it were a raw ASCII
text file.
Le 20/07/12 16:41, Dan a écrit :
Hi Dan, Is it a good idea to have the three conventions checked
that are
listed there? Why or why not?
I generally uncheck the ODBC convention option when working with dates,
as otherwise LO and OOo Base do things like injecting additional
characters
Paul
On 07/20/2012 11:51 AM, Paul Keir wrote:
Hi,
I am trying out Atlassian Confluence, which allows the pages it
manages to be exported in Word format (.doc). If I load such a file in
Word, it works, but LibreOffice will instead first provide a ASCII
Filter Options popup, and then opens
2012/7/20 Johnny Rosenberg gurus.knu...@gmail.com:
2012/7/20 Andrew Douglas Pitonyak and...@pitonyak.org:
You may also try using the cell range and calling GetDataArray() to get all
of the data including numbers and strings. If you are simply running through
about 2000 cells, this should be
Op 20/07/2012 13:31, Johnny Rosenberg schreef:
2012/7/20 Fernand Vanries...@pmgroup.be:
Johnny,
I suppose you have to run the check 2 Times, first SearchType = 0 here we
find if there is a formula use .
What do you mean? Use . as the search string? Regular expressions
set to what? True?
Hi :)
Usually the most stable version is the latest one in a branch that has had time
to mature. So a fresh new 3.x.5 is usually more stable than an old 3.x.3 which
is usually a lot more stable than a 3.x.0. The 3.x.4+ are usually very
stable. Also a 3.x.4+ is usually far more stable or at
As far as I know, the find/replace tool can not find empty strings nor
blanks.
The standard filter can. It has an -- empty -- option for the blanks and
one empty entry at the end of the combo box for the empty strings (if any).
--
View this message in context:
On 07/20/2012 11:34 AM, James Knott wrote:
Tom wrote:
It's usually possible to set-up some special area that can be shared
with
other computers on your house or work-place network but even that can be
quite tricky. Trying to get your machine to act like a server is quite
challenging.
You
2012/7/20 Andreas Säger ville...@t-online.de:
As far as I know, the find/replace tool can not find empty strings nor
blanks.
The standard filter can. It has an -- empty -- option for the blanks and
one empty entry at the end of the combo box for the empty strings (if any).
Can I use that in a
Which version of .doc is the file being exported as? There are several
of them, based on the different version of Office that they came from.
I wonder if the file is exported properly.
Yes, please use the other system, Nabble, to get the file to people,
since this list strips attached
HI :)
The side-question that arose was from a person who was suddenly worried that
everyone could read all the files on their computer.
I was just making the point that deliberately trying to share files is tricky
and that very few people have skills to crack into a system remotely, even a
I know that there are big issues fixed in the 3.4 line that the 3.3 line
had, and the same with the 3.5 line. The 3.6 line will come out in a
few months, while the 3.5 line will go to either 3.5.6 or 3.5.7.
I would try 3.5.5 for your MacOSX -PPC system. It may surprise you on
how well it
Even with setting up a shared system, it can be tricky to get it
working properly.
Matching workgroups and other options can get people confused. Then
getting some setting to be able to share read-only or fully shared.
Then getting different OSs to share with each other on a private
Please unsubscribe me.
On 7/20/2012 11:56 AM, Johnny Rosenberg wrote:
2012/7/20 Andreas Säger ville...@t-online.de:
As far as I know, the find/replace tool can not find empty strings nor
blanks.
The standard filter can. It has an -- empty -- option for the blanks and
one empty entry at the end
Hi :)
Pleas follow the guide at
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
We can't randomly unsubscribe people from this end but you can unsubscribe
yourself just by following the instructions
Apols and regards from
Tom :)
--- On Fri, 20/7/12, Jon Morgan
2012/7/20 Fernand Vanrie s...@pmgroup.be:
Op 20/07/2012 13:31, Johnny Rosenberg schreef:
2012/7/20 Fernand Vanries...@pmgroup.be:
Johnny,
I suppose you have to run the check 2 Times, first SearchType = 0 here
we
find if there is a formula use .
What do you mean? Use . as the search
We are using Windows XP, and LibreOffice 3.5.5.3
I'm trying to set up a document that has multiple page styles on the same
page. For example: The top of the page has margins set at: left 1.2,
right .5, top .3 and bottom 1.0. Our company name and address would be
shown there. No problem doing
On 07/20/2012 07:06 PM, webmaster-Kracked_P_P wrote:
Now we need to build up the numbers in the Windows and Mac office
market. LO does have the advantage of more [so I have heard] language
support than MSO does, and you do not need to buy a new version to get
these 100+ supported languages
Karen DInse wrote:
We are using Windows XP, and LibreOffice 3.5.5.3
I'm trying to set up a document that has multiple page styles on the same
page. For example: The top of the page has margins set at: left 1.2,
right .5, top .3 and bottom 1.0. Our company name and address would be
shown
Am 20.07.2012 18:56, Johnny Rosenberg wrote:
2012/7/20 Andreas Sägerville...@t-online.de:
As far as I know, the find/replace tool can not find empty strings nor
blanks.
The standard filter can. It has an -- empty -- option for the blanks and
one empty entry at the end of the combo box for the
On 7/20/12 11:06 AM, webmaster-Kracked_P_P wrote:
snip
I would try 3.5.5 for your MacOSX -PPC system. It may surprise you on
how well it works. I do not have a Mac, but I use it for several
Windows systems and for my main systems that are Ubuntu based systems.
The laptop isn't for me. It
On 7/20/12 11:45 AM, Alex Thurgood wrote:
On 07/20/2012 07:06 PM, webmaster-Kracked_P_P wrote:
Now we need to build up the numbers in the Windows and Mac office
market. LO does have the advantage of more [so I have heard] language
support than MSO does, and you do not need to buy a new
On 07/20/2012 08:05 PM, Ken Springer wrote:
Apple doesn't include things similar to Wordpad and the like with their OS.
It does come with TextEdit, a RTF capable editor/word processor,
although I would use that last term lightly.
So I'm collecting some software that can be installed by
Thanks Dan. I got the sections to work. However, now I'm trying to create
this in a macro. But, the macro doesn't appear to recognize the section or
page size. Any other ideas?
--
View this message in context:
On 20/07/2012 at 19:35, Karen DInse kdi...@rrwrd.dst.il.us wrote:
We are using Windows XP, and LibreOffice 3.5.5.3
I'm trying to set up a document that has multiple page styles on the same
page. For example: The top of the page has margins set at: left 1.2,
right .5, top .3 and bottom
2012/7/20 Johnny Rosenberg gurus.knu...@gmail.com:
2012/7/20 Fernand Vanrie s...@pmgroup.be:
Op 20/07/2012 13:31, Johnny Rosenberg schreef:
2012/7/20 Fernand Vanries...@pmgroup.be:
Johnny,
I suppose you have to run the check 2 Times, first SearchType = 0 here
we
find if there is a
Am 20.07.2012 14:19, Andreas Säger wrote:
Try my SpecialCells extension which selects combinations of cell types:
http://user.services.openoffice.org/en/forum/download/file.php?id=11048
Done. Snippet recorded by the MRI inspector:
Sub Snippet(Optional oInitialTarget As Object)
Dim
2012/7/20 Andreas Säger ville...@t-online.de:
Am 20.07.2012 14:19, Andreas Säger wrote:
Try my SpecialCells extension which selects combinations of cell types:
http://user.services.openoffice.org/en/forum/download/file.php?id=11048
Done. Snippet recorded by the MRI inspector:
Sub
Hi :)
I think they want the front page to look different from the rest and for that
1st page to have smaller margins? Also i agree there seems to be a bit of
confusion about the header but that is probably due to the weird way Word
handles headers.
I think the chapter on Styles and
El 20/07/12 21:33, Johnny Rosenberg escribió:
2012/7/20 Johnny Rosenberg gurus.knu...@gmail.com:
2012/7/20 Fernand Vanrie s...@pmgroup.be:
Op 20/07/2012 13:31, Johnny Rosenberg schreef:
2012/7/20 Fernand Vanries...@pmgroup.be:
Johnny,
I suppose you have to run the check 2 Times, first
Using Calc, I need a way to specify that a group of rows all belong
together/have the same title.
For example. Say I have a bank that has multiple branches. Each branch
has it's own name like southwest branch, but they're all part of the
same bank - Bank of America perhaps. Each branch has
Hi :)
Good work from Drew there. Glad he had all your hardwork to build up off.
Cheers Tim Drew :)
Regards from
Tom :)
--- On Fri, 20/7/12, webmaster-Kracked_P_P webmas...@krackedpress.com wrote:
From: webmaster-Kracked_P_P webmas...@krackedpress.com
Subject: [libreoffice-users] now can
2012/7/20 MiguelAngel mari...@miguelangel.mobi:
El 20/07/12 21:33, Johnny Rosenberg escribió:
2012/7/20 Johnny Rosenberg gurus.knu...@gmail.com:
2012/7/20 Fernand Vanrie s...@pmgroup.be:
Op 20/07/2012 13:31, Johnny Rosenberg schreef:
2012/7/20 Fernand Vanries...@pmgroup.be:
Johnny,
Drew found the place. That was the key. We needed to find a place that
could make the DVDs as a print-on-demand service, like the LO books
for Lulu.com, but do it at a price that people can afford.
With shipping [USA], it is about $10 +/- per DVD, Thin Movie DVD case,
and printed insert.
Nevermind, I figured it out.
In case anyone else has a similar desire and wants to know... I simply
select all the rows I want to belong to a group, add a border around it
all, and insert a row above the box I just made. The inserted box
contains the label I want; I make sure to turn off
On 7/20/12 12:49 PM, Alex Thurgood wrote:
On 07/20/2012 08:05 PM, Ken Springer wrote:
Apple doesn't include things similar to Wordpad and the like with their OS.
It does come with TextEdit, a RTF capable editor/word processor,
although I would use that last term lightly.
It's basically a
On 07/20/12 02:16, Dave Barton wrote:
Original Message
From: rhubarbpie...@gmail.com
To: users@global.libreoffice.org
Date: Thu, 19 Jul 2012 16:48:53 -0500
I'd like to create a macro for a user-defined date format (H:MMa/p). As
examples, 7:00 AM would display as 7:00a and
rhubarbpieguy wrote
I'd like to create a macro for a user-defined date format (H:MMa/p). As
examples, 7:00 AM would display as 7:00a and 3:33 PM as 3:33p. I can
create the format manually, but I understand the LibreOffice format
can't save user-defined formats. So my thought is to create
If you're referring to it getting hung-up, then this has happened to
me a few times -
my solution is to shut it down - clear out the caches [CCleaner
is good] - re-start the computer;
when it re-starts, OO/LO works great again.
One of the problems with
Original Message
From: rhubarbpie...@gmail.com
To: users@global.libreoffice.org
Date: Fri, 20 Jul 2012 20:33:27 -0500
On 07/20/12 02:16, Dave Barton wrote:
Original Message
From: rhubarbpie...@gmail.com
To: users@global.libreoffice.org
Date: Thu, 19 Jul
77 matches
Mail list logo