date:20120720


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) are a total waste of time.



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Chart Office compatibility issue


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? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: [List Threading] was: Re: Correct Syntax to address a table or form field in Base's Basic


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 from a web page is (IMO) like someone trying to use a spreadsheet


The OP used whichever wrong tool for the job. The original message does 
not appear on gmane. I use any tool availlable.

What I do not use:
- pocket devices for internet access (smart phones, tablets)
- user profiles in clouds

Mailing lists are still perfect the colaboration tools but inadequate 
for end user support unless end users are a closed group of people.



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Chart Office compatibility issue

2012-07-20 Thread Gordon Burgess-Parker


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 unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Chart Office compatibility issue

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

From: Gordon Burgess-Parker gbpli...@gmail.com
Subject: Re: [libreoffice-users] Re: Chart Office compatibility issue
To: users@global.libreoffice.org
Date: Friday, 20 July, 2012, 9:25

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 unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Locking a single cell in a Calc sheet using a macro

2012-07-20 Thread Graham Luffrum

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
 single
  cell in a Calc sheet.  I can easily test to see if the cell is locked,
  using CellProtection.IsLocked, but I don't see how to change the value.
 
  Any ideas?
 
  Graham

 I tried to just set IsLocked to False and True, but I guess you tried
 that too, because nothing happened:


 ThisComponent.getSheets().getByIndex(0).getCellByPosition(0,0).cellProtection.IsLocked=False
 ' Nothing happens

 I found this thread in a forum, however:
 http://user.services.openoffice.org/en/forum/viewtopic.php?f=9t=34393

 They also suggest to manipulate IsLocked, which obviously doesn't
 work, at least not with LibreOffice Calc 3.5.5. However, they also
 suggest using two different cell styles, one unlocked and one locked,
 and apply them with a macro. I didn't test that, but take a look
 yourself.

 Still, I wonder why IsLocked didn't work. On the other hand, if it
 worked, I suppose there would be a method for it, like
 CellProtection.Lock() or something like that.


 Kind regards

 Johnny Rosenberg
 ジョニー・ローゼンバーグ

 --
 For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
 Problems?
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Chart Office compatibility issue

2012-07-20 Thread Regina Henschel


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 nature of the file,  I cannot upload it to here and will
delete it soon).

The file displays properly in MS Excel viewer.


The chart is based on a constant matrix. That is not possible in LO. LO 
needs a reference to a range or an embedded table.


Kind regards
Regina


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Chart Office compatibility issue

2012-07-20 Thread davews


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
 http://www.btinternet.com/~dsergeant/cadismay.xls here

 (because of the nature of the file,  I cannot upload it to here and will
 delete it soon).

 The file displays properly in MS Excel viewer.
 
 The chart is based on a constant matrix. That is not possible in LO. LO 
 needs a reference to a range or an embedded table.
 
 Kind regards
 Regina
 
 

Many thanks, at least we now know why it doesn't display. Are there any
plans to add this functionality to LO?
I have downloaded  Gnumeric so I now have another method of viewing it.  I
see it also opens .ods spreadsheets...






--
View this message in context: 
http://nabble.documentfoundation.org/Chart-Office-compatibility-issue-tp3996558p3996589.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Searching for ”empty” cell (LibreOffice BASIC macro)

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 mean what's found when setting ”search all”?


 the SearchString has a different meaning , depending on the .SearchType
 = 1 then the SearchString is the is the result of the formula or the value
 content

Okay, that's not very well designed… at least not in my opinion.

 = 0 then the SearchString is the formula string

Meaning what if a cell contains only a value?

 hope it helps

I don't know, will do some tests later, but it certainly feels
confusing at the moment, because when I use the Search/Replace
dialogue, it doesn't work like that at all. Selecting ”Values” in the
dialogue give me the result I want, it finds the first cell with an
empty value (in this case a cell with a formula that returns that
empty value – ). So one question that comes to my mind is why the
LibreOffice Basic Search doesn't work the same way as the dialogue.
Maybe it's just fun to confuse the users…

As I said, I will do some more tests and come back here later.


Thanks for replying.

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ


 Fernand

 Just can't figure it out. I have a column of 2000 formulas and values.
 Right now, A1:A1620 contains values, and A1621:A2000 contains
 formulas. The formulas in A1621:A2000, at the moment, return empty
 strings, all of them, so it looks like only the 1620 first rows
 contains data.
 So the formulas looks something like =IF(this and that;;something
 else) (but a bit more complicated). The point is that if I input
 something on a ”new” row in one of the other columns, the A column
 shall, in some cases, display something.

 Okay, that's what the spreadsheet looks like, roughly.

 Now I use a couple of macros to do things for me a lot faster than I
 could ever do myself. One small part of a new macro I'm trying to
 write needs to search for the first ”empty” row, which means the first
 row where the A column contains a formula that returns an empty
 string.

 Here's what I tried:
 Function FindCurrentRow(Sheet As Object) As Integer
 Dim SearchDescriptor As Object
 SearchDescriptor=Sheet.createSearchDescriptor()
 With SearchDescriptor
 .SearchByRow=False ' I want to search by column, starting
 at A.
 .SearchRegularExpression=False
 .SearchString=
 .SearchType=1 ' 0=Search in formulae, 1=Search values.
 End With

 Dim Found As Object
 Found=Sheet.findFirst(SearchDescriptor)
 FindCurrentRow=Found.getCellAddress().Row
 End Function

 In this example I expect the function to return 1620 (which is the row
 address for the cell A1621). Instead 2000 is returned, so for some
 reason, when my cell formula returns , that doesn't seem to be the
 same as .SearchString=.
 I also tried different values of .SearchValue, still with the same
 result: 2000 instead of 1620. So it only finds the first cell in the A
 column that is REALLY empty – no formula, no value.

 To me this seems like a bug, but for someone else, hopefully, it might
 seem like I'm just stupid, so feel free to call me stupid and, more
 important, tell me what I'm doing wrong and how I should do instead…



 Kind regards

 Johnny Rosenberg
 ジョニー・ローゼンバーグ



 --
 For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
 Problems?
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LibreOffice pause during startup

2012-07-20 Thread Jay Lozier


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 flash on router) every 2 seconds, 5 times in all. LO then 
completes startup.

This happens
- with the splash screen turned off in /etc/libreoffice/sofficerc (the pause 
and network requesting still happen)
- when launching LO by itself, or when opening a Writer or other LO document 
through a file manager
- with Java RE option on or off

With an LO document already open, there is no pause when opening a second LO 
document. The pause only occurs during startup.

How to stop LO from sending requests over the network on startup, so that it 
opens without the 10-second pause?

My guess is that LO is trying to connect to something on the network. 
Try checking TOOLS  OPTIONSLIBREOFFICEPATHS to see any are located 
on a remote machine.


I can not replicate you r problem.

--
Jay Lozier
jsloz...@gmail.com


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LibreOffice pause during startupThis has worked for me in allrecent versions of Ubuntu

2012-07-20 Thread Don Myers


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 localhost
127.0.1.1 galaxy
127.0.0.1 galaxy localhost galaxy.(none)
5) save
6) now LibreOffice.org Writer and Calc open fast when the network 
connection is attached.


For anyone new reading this. replace galaxy with whatever you have 
named your computer.



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 flash on router) every 2 seconds, 5 times in all. LO then 
completes startup.

This happens
- with the splash screen turned off in /etc/libreoffice/sofficerc (the pause 
and network requesting still happen)
- when launching LO by itself, or when opening a Writer or other LO document 
through a file manager
- with Java RE option on or off

With an LO document already open, there is no pause when opening a second LO 
document. The pause only occurs during startup.

How to stop LO from sending requests over the network on startup, so that it 
opens without the 10-second pause?



--


**


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)

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 from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Base fread-only

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 alex.thurg...@gmail.com
Subject: [libreoffice-users] Re: Base fread-only
To: users@global.libreoffice.org
Date: Friday, 20 July, 2012, 7:42

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 can read it but I cannot add a new record nor can I
 edit an existing record.  It seems to somehow be marked as read-only.
 
 I have been unable to find a way to make it read/write.  I got around
 the problem by exporting to a spreadsheet, creating a new database, and
 importing to that database.
 

It might be, and this is only a guess, that LO has found bits of your OOo user 
configuration and that the XCU/XCS files in that are being misinterpreted. This 
has been known to lead to the symptoms you describe, including being able to 
read/write to one ODB file and only read the other ODB file.

So, if you have done it already, I would suggest :
- shutting down LO if it is running;
- removing both the old OOo user configuration folder and the LO user 
configuration - note that the user configuration location changed between LO 
3.4 and LO 3.5, so it would be wise to check in both places ;
- restarting LO - the user configuration folder will be created anew.

I can't guarantee this will change anything, but it might.


Alex





-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LibreOffice pause during startupThis has worked for me in allrecent versions of Ubuntu


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:
127.0.0.1 localhost
127.0.1.1 galaxy
127.0.0.1 galaxy localhost galaxy.(none)
5) save
6) now LibreOffice.org Writer and Calc open fast when the network
connection is attached.

For anyone new reading this. replace galaxy with whatever you have
named your computer.


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 flash on router) every 2 seconds,
5 times in all. LO then completes startup.

This happens
- with the splash screen turned off in /etc/libreoffice/sofficerc (the
pause and network requesting still happen)
- when launching LO by itself, or when opening a Writer or other LO
document through a file manager
- with Java RE option on or off

With an LO document already open, there is no pause when opening a
second LO document. The pause only occurs during startup.

How to stop LO from sending requests over the network on startup, so
that it opens without the 10-second pause?



 Tools  Options  LibreOffice  Online Update
If an update option of Daily is checked, would this account for the 
network connection? Or, might it be a bug in that every time LO is 
opened it checks for an update instead of once a day? If so, would 
unchecking Check for updates automatically stop this?


--Dan


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: 3.4

2012-07-20 Thread anne-ology

   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 interested in hearing more]

  are you perchance saying that all OO / LO files are archived
on-line?  [nice idea; now, the initial poster should be able to access]

  or did you mis-read, not noting I was commenting to the
requester?  [if so, all's forgiven  forgotten - and please have a
beautiful day]



On Thu, Jul 19, 2012 at 8:10 PM, webmaster-Kracked_P_P 
webmas...@krackedpress.com wrote:'


 There is an archive of LO's installs.

 But if you tell me what OS you have, I should be able to find it.



 On 07/19/2012 08:32 PM, anne-ology wrote:

 I have the original, complete version still on my machine -
  if there's some way to get it to you, I'd be happy to so do.

 [just need to know how  where to upload it]



 On Thu, Jul 19, 2012 at 2:39 PM, digisan digi...@sbcglobal.net wrote:

 Steve,

 I was using 3.4 and installed 3.5.5. Here is a portion of the screen
 shot.
 Does anyone know where to download 3.4, it looks like it is no longer
 available on the website.


 http://nabble.**documentfoundation.org/file/**
 n3996499/Screen_Shot_2012-07-**19_at_12.36.57_PM.pnghttp://nabble.documentfoundation.org/file/n3996499/Screen_Shot_2012-07-19_at_12.36.57_PM.png



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: 3.4



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


http://downloadarchive.documentfoundation.org/libreoffice/old/3.4.6.2/

This is the direct link for Windows, but you would need the help packs 
as well.

http://downloadarchive.documentfoundation.org/libreoffice/old/3.4.6.2/win/x86/LibO_3.4.6rc2_Win_x86_install_multi.exe


On 07/20/2012 09:22 AM, anne-ology wrote:

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 interested in hearing more]

   are you perchance saying that all OO / LO files are archived
on-line?  [nice idea; now, the initial poster should be able to access]

   or did you mis-read, not noting I was commenting to the
requester?  [if so, all's forgiven  forgotten - and please have a
beautiful day]



On Thu, Jul 19, 2012 at 8:10 PM, webmaster-Kracked_P_P 
webmas...@krackedpress.com wrote:'



There is an archive of LO's installs.

But if you tell me what OS you have, I should be able to find it.



On 07/19/2012 08:32 PM, anne-ology wrote:


 I have the original, complete version still on my machine -
  if there's some way to get it to you, I'd be happy to so do.

 [just need to know how  where to upload it]



On Thu, Jul 19, 2012 at 2:39 PM, digisan digi...@sbcglobal.net wrote:

Steve,


I was using 3.4 and installed 3.5.5. Here is a portion of the screen
shot.
Does anyone know where to download 3.4, it looks like it is no longer
available on the website.


http://nabble.**documentfoundation.org/file/**
n3996499/Screen_Shot_2012-07-**19_at_12.36.57_PM.pnghttp://nabble.documentfoundation.org/file/n3996499/Screen_Shot_2012-07-19_at_12.36.57_PM.png





--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Searching for ”empty” cell (LibreOffice BASIC macro)

2012-07-20 Thread Andrew Douglas Pitonyak



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 type search rather than a sequential search.


In AndrewMacro.odt I have a section on searching Calc comparing three 
different methods. It might be useful.


On 07/20/2012 03:31 AM, Fernand Vanrie wrote:

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

= 0 then the SearchString is the formula string

hope it helps

Fernand

Just can't figure it out. I have a column of 2000 formulas and values.
Right now, A1:A1620 contains values, and A1621:A2000 contains
formulas. The formulas in A1621:A2000, at the moment, return empty
strings, all of them, so it looks like only the 1620 first rows
contains data.
So the formulas looks something like =IF(this and that;;something
else) (but a bit more complicated). The point is that if I input
something on a ”new” row in one of the other columns, the A column
shall, in some cases, display something.

Okay, that's what the spreadsheet looks like, roughly.

Now I use a couple of macros to do things for me a lot faster than I
could ever do myself. One small part of a new macro I'm trying to
write needs to search for the first ”empty” row, which means the first
row where the A column contains a formula that returns an empty
string.

Here's what I tried:
Function FindCurrentRow(Sheet As Object) As Integer
Dim SearchDescriptor As Object
SearchDescriptor=Sheet.createSearchDescriptor()
With SearchDescriptor
.SearchByRow=False ' I want to search by column, starting at A.
.SearchRegularExpression=False
.SearchString=
.SearchType=1 ' 0=Search in formulae, 1=Search values.
End With

Dim Found As Object
Found=Sheet.findFirst(SearchDescriptor)
FindCurrentRow=Found.getCellAddress().Row
End Function

In this example I expect the function to return 1620 (which is the row
address for the cell A1621). Instead 2000 is returned, so for some
reason, when my cell formula returns , that doesn't seem to be the
same as .SearchString=.
I also tried different values of .SearchValue, still with the same
result: 2000 instead of 1620. So it only finds the first cell in the A
column that is REALLY empty – no formula, no value.

To me this seems like a bug, but for someone else, hopefully, it might
seem like I'm just stupid, so feel free to call me stupid and, more
important, tell me what I'm doing wrong and how I should do instead…



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ






--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info:  http://www.pitonyak.org/oo.php




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: 3.4

2012-07-20 Thread Tom

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

If you want to share files about LibreOffice with people on this
mailing-list then it's probably easiest to create an account at Nabble and
reply to any of the posts in the appropriate thread here.  When you click on
Reply here you are given a message-box with a few buttons above it.  The
More button allows you to upload a file.  It works by pasting a link into
the message part of your reply so that even non-Nabble users can see it.  


Tim was talking about something else completely, i think.  I think he was
saying that if you tell him your OS he can find the appropriate installer
files that are hidden away somewhere on the TDF/LO hosting-servers.  

Regards from
Tom :)  



--
View this message in context: 
http://nabble.documentfoundation.org/Re-3-4-tp3996529p3996632.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Base and SQL statement


 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 Persons LEFT OUTER JOIN Orders ON Persons.P_ID = 
Orders.P_ID }


 Braces and OJ were added. This is using LO 3.5.5.3. I got a 
similar result when using SQL to create a RIGHT OUTER JOIN. Does anyone 
know where this is documented? It appears Base is adding this for 
clarity. Should this be included this in the documentation?


--Dan

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: 3.4



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 Vista and XP [both 32 bit], but my main systems run Ubuntu 
10.04 and 12.04 [both 64-bit].


I am slowly installing 3.5.5 on my systems.  I realized that on my Vista 
laptop I still had 3.4.6 on it, but the others have/had 3.5.4 until the 
upgrading.


Here is the link to all of the older version of LibreOffice.
http://downloadarchive.documentfoundation.org/libreoffice/old/
If you go to the box version, you get the older version of the DVD.



On 07/20/2012 09:47 AM, Tom wrote:

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

If you want to share files about LibreOffice with people on this
mailing-list then it's probably easiest to create an account at Nabble and
reply to any of the posts in the appropriate thread here.  When you click on
Reply here you are given a message-box with a few buttons above it.  The
More button allows you to upload a file.  It works by pasting a link into
the message part of your reply so that even non-Nabble users can see it.


Tim was talking about something else completely, i think.  I think he was
saying that if you tell him your OS he can find the appropriate installer
files that are hidden away somewhere on the TDF/LO hosting-servers.

Regards from
Tom :)



--
View this message in context: 
http://nabble.documentfoundation.org/Re-3-4-tp3996529p3996632.html
Sent from the Users mailing list archive at Nabble.com.




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Base and SQL statement

2012-07-20 Thread Jay Lozier


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 view I saw


FROM { OJ Persons LEFT OUTER JOIN Orders ON Persons.P_ID = 
Orders.P_ID }


Braces and OJ were added. This is using LO 3.5.5.3. I got a similar 
result when using SQL to create a RIGHT OUTER JOIN. Does anyone know 
where this is documented? It appears Base is adding this for clarity. 
Should this be included this in the documentation?


--Dan


Dan,

I see similar behavior with MSSQL Server and other db's. It probably 
should be mentioned that FROM and WHERE clauses will be parsed to show 
the best guess of what query should be and that text strings may be 
highlighted. It is somewhat useful for debugging a query but it could 
confuse a beginner who has not seen this before.


--
Jay Lozier
jsloz...@gmail.com


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Base and SQL statement

2012-07-20 Thread drew jensen

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 
 edited the query in SQL view I saw
 
 FROM { OJ Persons LEFT OUTER JOIN Orders ON Persons.P_ID = 
 Orders.P_ID }
 
   Braces and OJ were added. This is using LO 3.5.5.3. I got a 
 similar result when using SQL to create a RIGHT OUTER JOIN. Does anyone 
 know where this is documented? It appears Base is adding this for 
 clarity. Should this be included this in the documentation?
 

Hi Dan

The use of ODBC conventions, '{ OF' for example, is controlled with an
option on the ODB file.

Open the ODB.
Open the dialog for options:
EditDatabaseAdvanced Options

//drew




-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)

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 your file, Tools → Extension → Add…,
the extension is now in the list. Now what…? How do I use it? Can't
find it. Can I see the code?
Sorry for these idiot questions…

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

--
View this message in context:
http://nabble.documentfoundation.org/Searching-for-empty-cell-LibreOffice-BASIC-macro-tp3996513p3996615.html
Sent from the Users mailing list archive at Nabble.com.

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] now can Purchase a NA-DVD



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 shipping, and that will give TDF/LO a donation of the 
profit.


Finally, you can now buy a professionally made DVD at a good price.

Drew has stated that he wants to get the purchase into an Amazon account 
so it can be purchased through them.  There are people who would rather 
buy things through Amazon.com than direct from the producers.  I buy 
many things there even though I can buy them at other sites.


SO
Now people can buy a NA-DVD instead of downloading the ISO file.

THIS will help those who use dial-up since they would not want to spend 
the time downloading a 200 MB Windows install file.




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Searching for ”empty” cell (LibreOffice BASIC macro)

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 filled sequentially because then you can use a binary type search
 rather than a sequential search.

Yes, that's a nice workaround and it's probably what I'm going to do. Thanks.

 In AndrewMacro.odt I have a section on searching Calc comparing three
 different methods. It might be useful.

Yes, I've read it many times; it's been around for a couple of years
now in different versions, I'm not sure I have the latest one though,
but it seems relevant enough. You wrote about three cases, first going
cell by cell, which takes like forever (was it a bit over 1800 system
ticks?), then by storing into an array, took 54 ticks, as far as I
remember, and at last using the built in search function, which took
34 ticks or so.

Although my problem is probably solved by this, I still want to know
if that behaviour I experienced with the .SearchType thing, is it a
bug? Because manually using the dialogue that pops up at Ctrl+h
(Ctrl+f in earlier versions) gives the result I want, but I can't
implement it into a macro using the ”createSearchDescriptor()” thing,
as it seems.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ



 On 07/20/2012 03:31 AM, Fernand Vanrie wrote:

  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 value
 content
 = 0 then the SearchString is the formula string

 hope it helps

 Fernand

 Just can't figure it out. I have a column of 2000 formulas and values.
 Right now, A1:A1620 contains values, and A1621:A2000 contains
 formulas. The formulas in A1621:A2000, at the moment, return empty
 strings, all of them, so it looks like only the 1620 first rows
 contains data.
 So the formulas looks something like =IF(this and that;;something
 else) (but a bit more complicated). The point is that if I input
 something on a ”new” row in one of the other columns, the A column
 shall, in some cases, display something.

 Okay, that's what the spreadsheet looks like, roughly.

 Now I use a couple of macros to do things for me a lot faster than I
 could ever do myself. One small part of a new macro I'm trying to
 write needs to search for the first ”empty” row, which means the first
 row where the A column contains a formula that returns an empty
 string.

 Here's what I tried:
 Function FindCurrentRow(Sheet As Object) As Integer
 Dim SearchDescriptor As Object
 SearchDescriptor=Sheet.createSearchDescriptor()
 With SearchDescriptor
 .SearchByRow=False ' I want to search by column, starting at A.
 .SearchRegularExpression=False
 .SearchString=
 .SearchType=1 ' 0=Search in formulae, 1=Search values.
 End With

 Dim Found As Object
 Found=Sheet.findFirst(SearchDescriptor)
 FindCurrentRow=Found.getCellAddress().Row
 End Function

 In this example I expect the function to return 1620 (which is the row
 address for the cell A1621). Instead 2000 is returned, so for some
 reason, when my cell formula returns , that doesn't seem to be the
 same as .SearchString=.
 I also tried different values of .SearchValue, still with the same
 result: 2000 instead of 1620. So it only finds the first cell in the A
 column that is REALLY empty – no formula, no value.

 To me this seems like a bug, but for someone else, hopefully, it might
 seem like I'm just stupid, so feel free to call me stupid and, more
 important, tell me what I'm doing wrong and how I should do instead…



 Kind regards

 Johnny Rosenberg
 ジョニー・ローゼンバーグ




 --
 Andrew Pitonyak
 My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
 Info:  http://www.pitonyak.org/oo.php





 --
 For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
 Problems?
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)

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, got it. I needed to restart LibreOffice, then I found it easily.

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ

--
View this message in context:
http://nabble.documentfoundation.org/Searching-for-empty-cell-LibreOffice-BASIC-macro-tp3996513p3996615.html
Sent from the Users mailing list archive at Nabble.com.

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LibreOffice pause during startupThis has worked for me in allrecent versions of Ubuntu

2012-07-20 Thread Don C. Myers



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) and add a line so it looks like this:
127.0.0.1 localhost
127.0.1.1 galaxy
127.0.0.1 galaxy localhost galaxy.(none)
5) save
6) now LibreOffice.org Writer and Calc open fast when the network
connection is attached.

For anyone new reading this. replace galaxy with whatever you have
named your computer.


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 flash on router) every 2 seconds,
5 times in all. LO then completes startup.

This happens
- with the splash screen turned off in /etc/libreoffice/sofficerc (the
pause and network requesting still happen)
- when launching LO by itself, or when opening a Writer or other LO
document through a file manager
- with Java RE option on or off

With an LO document already open, there is no pause when opening a
second LO document. The pause only occurs during startup.

How to stop LO from sending requests over the network on startup, so
that it opens without the 10-second pause?



 Tools  Options  LibreOffice  Online Update
If an update option of Daily is checked, would this account for the 
network connection? Or, might it be a bug in that every time LO is 
opened it checks for an update instead of once a day? If so, would 
unchecking Check for updates automatically stop this?


--Dan



Hi Dan,

I don't know. These instructions go back to the first release of 
LibreOffice when it opened initially really slowly for me. If I recall 
correctly, they were originally for open office. I found them on the 
Internet. It was essential for LibreOffice 3.3x and 3.4x for me. I've 
seen less difference in 3.5x. I've only updated LibreOffice when a new 
version is out, such as 3.5.4.2 to 3.5.5.3.


Don


--

*~~*
Don C. Myers
e-PRO Certified by the National Association of Realtors
Manager, Farm and Rural Property Division
*Coldwell Banker University Realty
*126 East Foster Avenue, State College, PA 16801
Office Phone: 814-237-6543 Fax: 814-237-6502
Home Phone: 814-422-8111 Cell Phone: 814-571-9518
Visit the Farm and Rural Property Division Web Site at 
_www.cbur-ruralproperty.com http://www.cbur-ruralproperty.com/

_View Don's Farm Web Site at www.myersfarm.com http://www.myersfarm.com/
*~~*


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Base and SQL statement


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, today when I
edited the query in SQL view I saw

FROM { OJ Persons LEFT OUTER JOIN Orders ON Persons.P_ID =
Orders.P_ID }

   Braces and OJ were added. This is using LO 3.5.5.3. I got a
similar result when using SQL to create a RIGHT OUTER JOIN. Does anyone
know where this is documented? It appears Base is adding this for
clarity. Should this be included this in the documentation?



Hi Dan

The use of ODBC conventions, '{ OF' for example, is controlled with an
option on the ODB file.

Open the ODB.
Open the dialog for options:
EditDatabaseAdvanced Options

//drew

 Thanks!

 Is it a good idea to have the three conventions checked that are 
listed there? Why or why not?


--Dan

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] LO for a Mac Powerbook G4

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? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: 3.4

2012-07-20 Thread James Knott


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 DropBox for sharing files 
with others.



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: LO for a Mac Powerbook G4

2012-07-20 Thread Alexander Thurgood

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 meaning where
something like LO is concerned - it might well be that this version
satisfies you completely, and then again, depending on what you are
doing with it, you might feel it is completely worthless.

Personally, I currently have 3 versions on my MB Pro (now running Lion,
but previously with SL) :

- LO 3.3.4 : IMO pretty stable, and reliable, for my usage, but contains
known unpatched security holes ;

- LO 3.5.5 : hmmm, I still have issues with this, particularly with
moving/disappearing images in ODT files, and some fairly painful
database problems (but to be fair, some were already in 3.3.4) ;

- LO home build from master branch (currently tagged as 3.7 alpha)

I use the dev build for testing files and bugs that I've encountered in
previous versions.

I use 3.3.4 for mostly everything, but 3.5.x is gaining in usage as bugs
get ironed out.


Alex




-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LO for a Mac Powerbook G4


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 
System, Version or Language. Then select PowerPC. Then select your 
language. Then select 3.5.5 (which is recommended). Finally, click the 
green Main installer box.


--Dan

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Confluence Word doc export

2012-07-20 Thread Paul Keir


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. Here is the start of the file (the entire file is attached):


The contents start as:

Message-ID: 2145210638.3.1342621542525.javamail.r...@..com
Subject: Exported From Confluence
MIME-Version: 1.0
Content-Type: multipart/related;
  boundary==_Part_2_97107473.1342621542514

--=_Part_2_97107473.1342621542514
...

It reminds me of an email. Does anyone know whatkind of file this is? 
Can it be opened as a Word doc. in LibreOffice?


Cheers,
Paul




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Base and SQL statement

2012-07-20 Thread Alexander Thurgood

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 into date/datetime strings, causing problems for some server
backends (postgres, most notably, from memory).


Alex




-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Confluence Word doc export

2012-07-20 Thread Jay Lozier


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 the document as if it were a raw 
ASCII text file. Here is the start of the file (the entire file is 
attached):


Please post the file on Nabble or somewhere public and post link to 
the list. Attachments are stripped from the list.


The contents start as:

Message-ID: 2145210638.3.1342621542525.javamail.r...@..com
Subject: Exported From Confluence
MIME-Version: 1.0
Content-Type: multipart/related;
  boundary==_Part_2_97107473.1342621542514

--=_Part_2_97107473.1342621542514
...

It reminds me of an email. Does anyone know whatkind of file this is? 
Can it be opened as a Word doc. in LibreOffice?


Cheers,
Paul







--
Jay Lozier
jsloz...@gmail.com


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Searching for ”empty” cell (LibreOffice BASIC macro)

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 very fast, especially if you know that the
 cells are filled sequentially because then you can use a binary type search
 rather than a sequential search.

 Yes, that's a nice workaround and it's probably what I'm going to do. Thanks.

 In AndrewMacro.odt I have a section on searching Calc comparing three
 different methods. It might be useful.

 Yes, I've read it many times; it's been around for a couple of years
 now in different versions, I'm not sure I have the latest one though,
 but it seems relevant enough. You wrote about three cases, first going
 cell by cell, which takes like forever (was it a bit over 1800 system
 ticks?), then by storing into an array, took 54 ticks, as far as I
 remember, and at last using the built in search function, which took
 34 ticks or so.

 Although my problem is probably solved by this, I still want to know
 if that behaviour I experienced with the .SearchType thing, is it a
 bug? Because manually using the dialogue that pops up at Ctrl+h
 (Ctrl+f in earlier versions) gives the result I want, but I can't
 implement it into a macro using the ”createSearchDescriptor()” thing,
 as it seems.

Correction: When using the Ctrl+h dialogue (Search/Replace), I can't
search for an empty string at all, since the Search button is disabled
until I type something into the ”Search for” field. Using regular
expressions, searching for ^$, finds nothing at all.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ



 Kind regards

 Johnny Rosenberg
 ジョニー・ローゼンバーグ



 On 07/20/2012 03:31 AM, Fernand Vanrie wrote:

  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 value
 content
 = 0 then the SearchString is the formula string

 hope it helps

 Fernand

 Just can't figure it out. I have a column of 2000 formulas and values.
 Right now, A1:A1620 contains values, and A1621:A2000 contains
 formulas. The formulas in A1621:A2000, at the moment, return empty
 strings, all of them, so it looks like only the 1620 first rows
 contains data.
 So the formulas looks something like =IF(this and that;;something
 else) (but a bit more complicated). The point is that if I input
 something on a ”new” row in one of the other columns, the A column
 shall, in some cases, display something.

 Okay, that's what the spreadsheet looks like, roughly.

 Now I use a couple of macros to do things for me a lot faster than I
 could ever do myself. One small part of a new macro I'm trying to
 write needs to search for the first ”empty” row, which means the first
 row where the A column contains a formula that returns an empty
 string.

 Here's what I tried:
 Function FindCurrentRow(Sheet As Object) As Integer
 Dim SearchDescriptor As Object
 SearchDescriptor=Sheet.createSearchDescriptor()
 With SearchDescriptor
 .SearchByRow=False ' I want to search by column, starting at A.
 .SearchRegularExpression=False
 .SearchString=
 .SearchType=1 ' 0=Search in formulae, 1=Search values.
 End With

 Dim Found As Object
 Found=Sheet.findFirst(SearchDescriptor)
 FindCurrentRow=Found.getCellAddress().Row
 End Function

 In this example I expect the function to return 1620 (which is the row
 address for the cell A1621). Instead 2000 is returned, so for some
 reason, when my cell formula returns , that doesn't seem to be the
 same as .SearchString=.
 I also tried different values of .SearchValue, still with the same
 result: 2000 instead of 1620. So it only finds the first cell in the A
 column that is REALLY empty – no formula, no value.

 To me this seems like a bug, but for someone else, hopefully, it might
 seem like I'm just stupid, so feel free to call me stupid and, more
 important, tell me what I'm doing wrong and how I should do instead…



 Kind regards

 Johnny Rosenberg
 ジョニー・ローゼンバーグ




 --
 Andrew Pitonyak
 My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
 Info:  http://www.pitonyak.org/oo.php





 --
 For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
 Problems?
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems?

Re: [libreoffice-users] Searching for ”empty” cell (LibreOffice BASIC macro)

2012-07-20 Thread Fernand Vanrie


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?

yep looking for not empty you need regular expressions

then SearchType 1 on the found area

Area? You mean what's found when setting ”search all”?
no you can define the erea (cells) you want to searched so when you 
found that 1 cell has a formula, you need to check only this cell on a value

the SearchString has a different meaning , depending on the .SearchType
= 1 then the SearchString is the is the result of the formula or the value
content

Okay, that's not very well designed… at least not in my opinion.


= 0 then the SearchString is the formula string

Meaning what if a cell contains only a value?

hope it helps

I don't know, will do some tests later, but it certainly feels
confusing at the moment, because when I use the Search/Replace
dialogue, it doesn't work like that at all. Selecting ”Values” in the
dialogue give me the result I want, it finds the first cell with an
empty value (in this case a cell with a formula that returns that
empty value – ). So one question that comes to my mind is why the
LibreOffice Basic Search doesn't work the same way as the dialogue.
Maybe it's just fun to confuse the users…

As I said, I will do some more tests and come back here later.


Thanks for replying.

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ


Fernand


Just can't figure it out. I have a column of 2000 formulas and values.
Right now, A1:A1620 contains values, and A1621:A2000 contains
formulas. The formulas in A1621:A2000, at the moment, return empty
strings, all of them, so it looks like only the 1620 first rows
contains data.
So the formulas looks something like =IF(this and that;;something
else) (but a bit more complicated). The point is that if I input
something on a ”new” row in one of the other columns, the A column
shall, in some cases, display something.

Okay, that's what the spreadsheet looks like, roughly.

Now I use a couple of macros to do things for me a lot faster than I
could ever do myself. One small part of a new macro I'm trying to
write needs to search for the first ”empty” row, which means the first
row where the A column contains a formula that returns an empty
string.

Here's what I tried:
Function FindCurrentRow(Sheet As Object) As Integer
 Dim SearchDescriptor As Object
 SearchDescriptor=Sheet.createSearchDescriptor()
 With SearchDescriptor
 .SearchByRow=False ' I want to search by column, starting
at A.
 .SearchRegularExpression=False
 .SearchString=
 .SearchType=1 ' 0=Search in formulae, 1=Search values.
 End With

 Dim Found As Object
 Found=Sheet.findFirst(SearchDescriptor)
 FindCurrentRow=Found.getCellAddress().Row
End Function

In this example I expect the function to return 1620 (which is the row
address for the cell A1621). Instead 2000 is returned, so for some
reason, when my cell formula returns , that doesn't seem to be the
same as .SearchString=.
I also tried different values of .SearchValue, still with the same
result: 2000 instead of 1620. So it only finds the first cell in the A
column that is REALLY empty – no formula, no value.

To me this seems like a bug, but for someone else, hopefully, it might
seem like I'm just stupid, so feel free to call me stupid and, more
important, tell me what I'm doing wrong and how I should do instead…



Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems?
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be
deleted



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LO for a Mac Powerbook G4

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 least more predictable 
than a 3.(x+1).0  

The trade-off is that tons of new features and far greater compatibility with 
MS formats tends to be added with an 3.(x+1).0 so you (errr, and me) miss out 
on all that by aiming for stability.  

Ok, generalities don't always work but it gives a rough idea of what to expect, 
i think, and getting away from the general confusion helps a lot.  
Regards from
Tom :)  


--- On Fri, 20/7/12, Ken Springer snowsh...@q.com wrote:

From: Ken Springer snowsh...@q.com
Subject: [libreoffice-users] LO for a Mac Powerbook G4
To: users@global.libreoffice.org
Date: Friday, 20 July, 2012, 16:23

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? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)

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: 
http://nabble.documentfoundation.org/Searching-for-empty-cell-LibreOffice-BASIC-macro-tp3996513p3996716.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: 3.4


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 can use services such as Google Drive or DropBox for sharing files 
with others.



Never used those services, since I have a domain server account to host 
several domains on.


Maybe I should start thinking about one of them, for some ideas I have 
in the future.




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)

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 macro? How?


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ




 --
 View this message in context: 
 http://nabble.documentfoundation.org/Searching-for-empty-cell-LibreOffice-BASIC-macro-tp3996513p3996716.html
 Sent from the Users mailing list archive at Nabble.com.

 --
 For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
 Problems? 
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Confluence Word doc export



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


To be honest, I never heard of Atlassian Confluence.  What are you using 
it for?


On 07/20/2012 12:00 PM, Jay Lozier wrote:

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 the document as if it 
were a raw ASCII text file. Here is the start of the file (the entire 
file is attached):


Please post the file on Nabble or somewhere public and post link to 
the list. Attachments are stripped from the list.


The contents start as:

Message-ID: 2145210638.3.1342621542525.javamail.r...@..com
Subject: Exported From Confluence
MIME-Version: 1.0
Content-Type: multipart/related;
  boundary==_Part_2_97107473.1342621542514

--=_Part_2_97107473.1342621542514
...

It reminds me of an email. Does anyone know whatkind of file this is? 
Can it be opened as a Word doc. in LibreOffice?


Cheers,
Paul










--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: 3.4

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 
Windows system.  
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: Re: [libreoffice-users] Re: 3.4
To: users@global.libreoffice.org
Date: Friday, 20 July, 2012, 17:51

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 can use services such as Google Drive or DropBox for sharing files with 
 others.
 
 
Never used those services, since I have a domain server account to host several 
domains on.

Maybe I should start thinking about one of them, for some ideas I have in the 
future.



-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] LO for a Mac Powerbook G4



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


For my preference, I do not switch over to the new line till it goes to 
.3 or .4.  I will stick with 3.5.x till 3.6 goes to one of those later 
version.  The only .0 version I used was when LO came out with 3.3.0.  I 
have not used OOo since then.  I stopped using MSO as soon as OOo worked 
well with .doc files, with the last MSO being 2003.


Let us know how it works out for you.  We are looking for more Mac 
users, as well as Windows ones.  LO being the default Office package for 
most Linux distros tends to help with that market.


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 for the menu and help systems.




On 07/20/2012 12:38 PM, Tom Davies wrote:

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 least more predictable than a 
3.(x+1).0

The trade-off is that tons of new features and far greater compatibility with 
MS formats tends to be added with an 3.(x+1).0 so you (errr, and me) miss out 
on all that by aiming for stability.

Ok, generalities don't always work but it gives a rough idea of what to expect, 
i think, and getting away from the general confusion helps a lot.
Regards from
Tom :)


--- On Fri, 20/7/12, Ken Springer snowsh...@q.com wrote:

From: Ken Springer snowsh...@q.com
Subject: [libreoffice-users] LO for a Mac Powerbook G4
To: users@global.libreoffice.org
Date: Friday, 20 July, 2012, 16:23

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? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: 3.4



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


With a router involved, it can make life safer, but software firewalls 
are a must.


I have a private network involving 3 routers, a switch and an old 
rack-mounter 24-port hub.  I need to share 4 printers with all my 
systems while I allow friends in my building wireless access to my Net 
connection while not giving them any ability to even see my printers and 
computers.  Talk about doing some weird network setups.




On 07/20/2012 01:03 PM, Tom Davies wrote:

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 
Windows system.
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: Re: [libreoffice-users] Re: 3.4
To: users@global.libreoffice.org
Date: Friday, 20 July, 2012, 17:51

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 can use services such as Google Drive or DropBox for sharing files with 
others.



Never used those services, since I have a domain server account to host several 
domains on.

Maybe I should start thinking about one of them, for some ideas I have in the 
future.







--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)

2012-07-20 Thread Jon Morgan


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 of the combo box for the empty strings (if any).

Can I use that in a macro? How?


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ




--
View this message in context: 
http://nabble.documentfoundation.org/Searching-for-empty-cell-LibreOffice-BASIC-macro-tp3996513p3996716.html
Sent from the Users mailing list archive at Nabble.com.

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted




--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: [libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)

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 fire...@wintersolace.com wrote:

From: Jon Morgan fire...@wintersolace.com
Subject: Re: [libreoffice-users] Re: Searching for ”empty” cell (LibreOffice 
BASIC macro)
To: users@global.libreoffice.org, users+h...@global.libreoffice.org
Date: Friday, 20 July, 2012, 18:28

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 of the combo box for the empty strings (if any).
 Can I use that in a macro? How?


 Kind regards

 Johnny Rosenberg
 ジョニー・ローゼンバーグ



 --
 View this message in context: 
 http://nabble.documentfoundation.org/Searching-for-empty-cell-LibreOffice-BASIC-macro-tp3996513p3996716.html
 Sent from the Users mailing list archive at Nabble.com.

 --
 For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
 Problems? 
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be 
 deleted



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Searching for ”empty” cell (LibreOffice BASIC macro)

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 string? Regular expressions
 set to what? True?

 yep looking for not empty you need regular expressions

I did some brutal experimenting and after hundreds of swearwords (the
damned crap freeze all the time) I actually found something. Have a
look at this descriptor:

With SearchDescriptor
.SearchByRow=False
.SearchRegularExpression=True
.SearchString=^[^.]$
.SearchType=1 ' Search values.
End With

First it didn't work as I expected, but it found another cell in
another column. That cell has a semi complicated formula with nested
IF's and in this case it returns F2+STYLE(Hide). F2 in this case is
an empty cell, so now I changed the formula in the cell I wanted to
find, by just replacing the two quotes () with F2, and now it finds
the cell!

So  is not good enough for making a cell empty, but I can reference
to a cell that actually is empty!

So what I need to do now, is to change all the formulas in one column,
and the search descriptor above will work, as it seems!


At least I'll try that.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ


 then SearchType 1 on the found area

 Area? You mean what's found when setting ”search all”?

 no you can define the erea (cells) you want to searched so when you found
 that 1 cell has a formula, you need to check only this cell on a value

 the SearchString has a different meaning , depending on the .SearchType
 = 1 then the SearchString is the is the result of the formula or the
 value
 content

 Okay, that's not very well designed… at least not in my opinion.

 = 0 then the SearchString is the formula string

 Meaning what if a cell contains only a value?

 hope it helps

 I don't know, will do some tests later, but it certainly feels
 confusing at the moment, because when I use the Search/Replace
 dialogue, it doesn't work like that at all. Selecting ”Values” in the
 dialogue give me the result I want, it finds the first cell with an
 empty value (in this case a cell with a formula that returns that
 empty value – ). So one question that comes to my mind is why the
 LibreOffice Basic Search doesn't work the same way as the dialogue.
 Maybe it's just fun to confuse the users…

 As I said, I will do some more tests and come back here later.


 Thanks for replying.

 Kind regards

 Johnny Rosenberg
 ジョニー・ローゼンバーグ

 Fernand

 Just can't figure it out. I have a column of 2000 formulas and values.
 Right now, A1:A1620 contains values, and A1621:A2000 contains
 formulas. The formulas in A1621:A2000, at the moment, return empty
 strings, all of them, so it looks like only the 1620 first rows
 contains data.
 So the formulas looks something like =IF(this and that;;something
 else) (but a bit more complicated). The point is that if I input
 something on a ”new” row in one of the other columns, the A column
 shall, in some cases, display something.

 Okay, that's what the spreadsheet looks like, roughly.

 Now I use a couple of macros to do things for me a lot faster than I
 could ever do myself. One small part of a new macro I'm trying to
 write needs to search for the first ”empty” row, which means the first
 row where the A column contains a formula that returns an empty
 string.

 Here's what I tried:
 Function FindCurrentRow(Sheet As Object) As Integer
  Dim SearchDescriptor As Object
  SearchDescriptor=Sheet.createSearchDescriptor()
  With SearchDescriptor
  .SearchByRow=False ' I want to search by column,
 starting
 at A.
  .SearchRegularExpression=False
  .SearchString=
  .SearchType=1 ' 0=Search in formulae, 1=Search values.
  End With

  Dim Found As Object
  Found=Sheet.findFirst(SearchDescriptor)
  FindCurrentRow=Found.getCellAddress().Row
 End Function

 In this example I expect the function to return 1620 (which is the row
 address for the cell A1621). Instead 2000 is returned, so for some
 reason, when my cell formula returns , that doesn't seem to be the
 same as .SearchString=.
 I also tried different values of .SearchValue, still with the same
 result: 2000 instead of 1620. So it only finds the first cell in the A
 column that is REALLY empty – no formula, no value.

 To me this seems like a bug, but for someone else, hopefully, it might
 seem like I'm just stupid, so feel free to call me stupid and, more
 important, tell me what I'm doing wrong and how I should do instead…



 Kind regards

 Johnny Rosenberg
 ジョニー・ローゼンバーグ


 --
 For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
 Problems?

[libreoffice-users] Multiple page styles on one page?

2012-07-20 Thread Karen DInse

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 that, but then, I need to change the margins
to all be set at 1.  

I've tried using styles and/or headers, but I can't get it to work.  Is this
possible?

Thanks for any input.



--
View this message in context: 
http://nabble.documentfoundation.org/Multiple-page-styles-on-one-page-tp3996740.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: LO for a Mac Powerbook G4

2012-07-20 Thread Alex Thurgood


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 for the menu and help systems.



Bear in mind that there are 2 comparative open source competitors on 
Mac apart from LO :


- AOOo, the follow on from the legacy OpenOffice.org, with some 
functionality missing (compared to LO), due to licensing issues 
preventing that functionality from being included in the binary release;


- NeoOffice : a stable, longstanding and Mac environment integrated 
product, yes, behind a bit in version functionality, compared to LO, but 
nonetheless representative of a more Mac-like experience.


LO still has a long way to go when it comes to Mac OS integration, 
and that is without even considering the numerous accessibility problems 
that LO causes - quite simply, it is unusable for anyone with a 
disability that relies on the accessibility functions provided by Mac OSX.


These issues represent major obstacles for users on Mac OSX against the 
adoption of LO. It doesn't look like a Mac app, and it doesn't behave 
like one either. We still Mac users, of course, but their one and only 
initial experience is often fatal to the reputation of our product on 
that OS.


What the project desperately needs are programmers who can code to 
Apple's do as I say or else coding standards. This is particularly 
true of the user interface, which is fairly far from Apple's HMI guidelines.


Alex


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Multiple page styles on one page?


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 there.  No problem doing that, but then, I need to change the margins
to all be set at 1.

I've tried using styles and/or headers, but I can't get it to work.  Is this
possible?

Thanks for any input.


 I'm thinking that what you need to use is sections for the page 
rather than attempting to use multiple page styles. A page style defines 
the characteristics of the page not part of a page.


--Dan


--
View this message in context: 
http://nabble.documentfoundation.org/Multiple-page-styles-on-one-page-tp3996740.html
Sent from the Users mailing list archive at Nabble.com.


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)


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 empty strings (if any).


Can I use that in a macro? How?



Apply such filter manually and inspect the filter descriptor with its 
filter fields.



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: LO for a Mac Powerbook G4


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 was given to me at my last Mac User Group 
meeting, and has OS X Leopard installed.  I'll be donating it to a local 
social agency to be given away to someone who needs a computer but can't 
afford it.


Apple doesn't include things similar to Wordpad and the like with their OS.

So I'm collecting some software that can be installed by the new owner. 
 I would install it if this was a Windows machine, but OS X requires 
the new owner to create the equivalent of an Administrator account with 
name and password right out of the box.  The Leopard install is brand 
new, so there's no way I can install the software as I don't know what 
the eventual username and password will be.


Technically, that name and password can be changed at a later date, but 
apparently that is something that often causes problems in OS X, so I'm 
going to avoid it.


snip


Let us know how it works out for you.  We are looking for more Mac
users, as well as Windows ones.  LO being the default Office package for
most Linux distros tends to help with that market.


If I should get any feedback from the eventual owners, I'll post it. 
But, don't hold your breath.   LOL



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 for the menu and help systems.


I think my time with LO is about to expire.  I've filed two bugs which 
no one seems interested in even dealing with.  They still exist.  And 
there are others that I've not double checked on for 3.5.x.  I've posted 
about this non-attentiveness before, but if fixing the bugs that are 
important to me isn't important to the developers, I'm not interested in 
lending any assistance.  It's a two way street, and I'm not the only one 
to post about bugs not being fixed prior to adding new features.  I'll 
find a program that doesn't cause me problems.  I already know which 
program I'll check out first, but will wait until the newest version is 
out this fall.


And is won't be MSO.   grin  If Corel hadn't dropped Mac support with 
WordPerfect, I'd fork over the money for it.  I used to use it, thought 
it was far superior to MSO.


I have Apple's iWork 09 package, which I consider to be Apple's 
equivalent to MS Works.  But, there's no database component.  I may go 
back and work some more with Pages (the word processor) and see if I can 
get used to it.



--
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? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: LO for a Mac Powerbook G4


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 version to get
these 100+ supported languages for the menu and help systems.



Bear in mind that there are 2 comparative open source competitors on
Mac apart from LO :

- AOOo, the follow on from the legacy OpenOffice.org, with some
functionality missing (compared to LO), due to licensing issues
preventing that functionality from being included in the binary release;


Played with it briefly in Windows years ago, but kind of waiting for the 
Apache dust to settle before considering it.



- NeoOffice : a stable, longstanding and Mac environment integrated
product, yes, behind a bit in version functionality, compared to LO, but
nonetheless representative of a more Mac-like experience.


This was the first office package I checked out after deciding I wasn't 
particularly happy with Pages, but when I found out I had to pay to post 
problems and bugs in the Neo forums, that was it for me.  I'm not sure 
Neo is even supporting any new versions for PPC any more.


Don't forget the current Lotus Symphony, it's based on Open Office now.


LO still has a long way to go when it comes to Mac OS integration,
and that is without even considering the numerous accessibility problems
that LO causes - quite simply, it is unusable for anyone with a
disability that relies on the accessibility functions provided by Mac OSX.


I've been a computer user since the 8-bit days, and I would have stopped 
with LO still has a long way to go.   :-)



These issues represent major obstacles for users on Mac OSX against the
adoption of LO. It doesn't look like a Mac app, and it doesn't behave
like one either. We still Mac users, of course, but their one and only
initial experience is often fatal to the reputation of our product on
that OS.


The non-Mac interface really doesn't bother me too much, having gone 
from Atari 8-bit to the ST/TT line, Win 98 then XP, and now OS X.  But 
that consistency in user interface is what makes Macs much easier for 
some people to learn.  Apple terminology really threw me at first, took 
me 2 weeks to finally figure out that Airport meant wireless.  But a 
friend who could never fathom Windows knew right away what it meant.   LOL



What the project desperately needs are programmers who can code to
Apple's do as I say or else coding standards. This is particularly
true of the user interface, which is fairly far from Apple's HMI guidelines.

Alex




--
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? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: LO for a Mac Powerbook G4

2012-07-20 Thread Alex Thurgood


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 the new owner.
  I would install it if this was a Windows machine, but OS X requires
the new owner to create the equivalent of an Administrator account with
name and password right out of the box.  The Leopard install is brand
new, so there's no way I can install the software as I don't know what
the eventual username and password will be.


You can actually create several users with admin rights (or at least you 
could, perhaps that has changed ??), then just delete the one that you 
don't want to keep, that way you could install the software you want.




I think my time with LO is about to expire.  I've filed two bugs which
no one seems interested in even dealing with.  They still exist.  And
there are others that I've not double checked on for 3.5.x.  I've posted
about this non-attentiveness before, but if fixing the bugs that are
important to me isn't important to the developers, I'm not interested in
lending any assistance.  It's a two way street, and I'm not the only one
to post about bugs not being fixed prior to adding new features.  I'll


Such is the way with open source, community run projects, especially if 
your reports are OS specific. The plain fact of the matter is that the 
vast majority of the developers of this project are actually coding on 
Linux. As far as I know, there are 3 or 4 developers who regularly use 
Mac OSX, but that's about it. There are no specialist Mac user interface 
coders, nor anyone particularly specialised in the underlying Mac APIs.



Feature development is what makes life interesting for developers on a 
project like this - bug fixing for them is generally not so much fun, 
hence the prioritisation. I can understand your point of view though, 
having looked at alternatives and remained as yet undecided. I'm 
ultimately not prepared to fork out for something that doesn't cater to 
my needs, so I can stick with LO, and try and help it improve in my own 
small way.





I have Apple's iWork 09 package, which I consider to be Apple's
equivalent to MS Works.  But, there's no database component.  I may go
back and work some more with Pages (the word processor) and see if I can
get used to it.


Not tried that, or Pages/Sheets/etc, and when I looked at database 
implementations, only found FMPro, which is well out of what my purse 
strings are prepared to pay, even for a small business like mine.


Alex





--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: Multiple page styles on one page?

2012-07-20 Thread Karen DInse

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: 
http://nabble.documentfoundation.org/Multiple-page-styles-on-one-page-tp3996740p3996768.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Multiple page styles on one page?

2012-07-20 Thread Mirosław Zalewski

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 1.0.  Our company name and address would be
 shown there.  No problem doing that, but then, I need to change the margins
 to all be set at 1.
 
 I've tried using styles and/or headers, but I can't get it to work.  Is
 this possible?

I don't understand. 

You need to have page with all margins set to 1 and company data at header? 
So you need one page style.

Or maybe you want one page with different margins, and another with margins set 
to 1, both displaying company data in header (having different margins in one 
document isn't the best idea, though)? Then you need two page styles. You must 
copy company data from header of one style to header of second style. If you 
ever change that data in one header, you must do so for second.

Please post detailed explanation of what are expected results of your work, 
what are you trying to achieve.
-- 
Best regards
Mirosław Zalewski

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Searching for ”empty” cell (LibreOffice BASIC macro)

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 formula use  .

 What do you mean? Use . as the search string? Regular expressions
 set to what? True?

 yep looking for not empty you need regular expressions

 I did some brutal experimenting and after hundreds of swearwords (the
 damned crap freeze all the time) I actually found something. Have a
 look at this descriptor:

 With SearchDescriptor
 .SearchByRow=False
 .SearchRegularExpression=True
 .SearchString=^[^.]$
 .SearchType=1 ' Search values.
 End With

 First it didn't work as I expected, but it found another cell in
 another column. That cell has a semi complicated formula with nested
 IF's and in this case it returns F2+STYLE(Hide). F2 in this case is
 an empty cell, so now I changed the formula in the cell I wanted to
 find, by just replacing the two quotes () with F2, and now it finds
 the cell!

 So  is not good enough for making a cell empty, but I can reference
 to a cell that actually is empty!

 So what I need to do now, is to change all the formulas in one column,
 and the search descriptor above will work, as it seems!


 At least I'll try that.

Ok, I'd just better give up, I guess. LibreOffice seems to be way too
slow for the things I do (I am surprised that I seem to be the only
one who actually do something with spreadsheets, except simple tables
of a few rows and columns, doing close to nothing, more or less). Many
years ago I did similar things in Excel. It crashed now and then, but
it was fast, at least. Things that took maybe one second to execute in
Excel seems to take hours in LibreOffice these days. I don't know
exactly how long they take, since I can never wait for more than a
couple of minutes before I restart it. It's very frustrating, when
testing new stuff. Simple developing a spreadsheet (something that you
shouldn't do, obviously) takes days instead of minutes.

I am not sure where things go slow. My current spreadsheet isn't
particularly big. There are currently about 2000 rows in 5 columns
containing formulas and there is one column with about 3300 rows of
formulas. Not that complicated formulas, mostly nested IF's. One of
the 2000 row columns use a custom formula (written in LibreOffice
BASIC), not very complicated: It reads the values from two cells and
returns a string value depending on the input values. A few IF's,
that's all.
I also use conditional formatting in all of the cells, approximately
3300+6×2000=15300 cells. It's not like millions of cells or something.

What is likely the most time consuming part in this case? My own cell
formula in a couple of hundred cells? The conditional formatted cells?
All those longer formulas with nested IF's?

Anyway, back to the subject… The thing I wrote about that regular
expression above was not quite accurate. I am not sure what to think
any more, it all feels like a mess, kind of. It seems like cells
containing a number also is found with the search descriptor above. I
am not sure why this is considered a proper behaviour, but maybe it
is.

Well, I am not sure what more to say, feel quite confused, to say the least…

What are you other guys using a spreadsheet for? It seems like
whatever I try to do, it all turns out as an extremely slow confusing
mess.


Sorry for being such a jerk.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ



 Kind regards

 Johnny Rosenberg
 ジョニー・ローゼンバーグ


 then SearchType 1 on the found area

 Area? You mean what's found when setting ”search all”?

 no you can define the erea (cells) you want to searched so when you found
 that 1 cell has a formula, you need to check only this cell on a value

 the SearchString has a different meaning , depending on the .SearchType
 = 1 then the SearchString is the is the result of the formula or the
 value
 content

 Okay, that's not very well designed… at least not in my opinion.

 = 0 then the SearchString is the formula string

 Meaning what if a cell contains only a value?

 hope it helps

 I don't know, will do some tests later, but it certainly feels
 confusing at the moment, because when I use the Search/Replace
 dialogue, it doesn't work like that at all. Selecting ”Values” in the
 dialogue give me the result I want, it finds the first cell with an
 empty value (in this case a cell with a formula that returns that
 empty value – ). So one question that comes to my mind is why the
 LibreOffice Basic Search doesn't work the same way as the dialogue.
 Maybe it's just fun to confuse the users…

 As I said, I will do some more tests and come back here later.


 Thanks for replying.

 Kind regards

 Johnny Rosenberg
 ジョニー・ローゼンバーグ

 Fernand

 Just can't figure it out. I have a column of

[libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)


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 oDatabaseRanges As Object
  Dim oObj_1 As Object
  Dim oFilterDescriptor As Object
  Dim oFilterFields As Object

  oDatabaseRanges = oInitialTarget.DatabaseRanges
  oObj_1 = oDatabaseRanges.getByIndex(0)
  oFilterDescriptor = oObj_1.getFilterDescriptor()

  oFilterFields = oFilterDescriptor.getFilterFields()
End Sub



And this is the output for oFilterFields:


(Name)(Value Type) (Value)  (AccessMode)
(0)
Connection.sheet.FilterConnection  AND  [ReadWrite]
Field long 0[ReadWrite]
Operator  .sheet.FilterOperatorEMPTY[ReadWrite]
IsNumeric boolean  True [ReadWrite]
NumericValue  double   0.0  [ReadWrite]
StringValue   string[ReadWrite]
(1)
Connection.sheet.FilterConnection  OR   [ReadWrite]
Field long 0[ReadWrite]
Operator  .sheet.FilterOperatorEQUAL[ReadWrite]
IsNumeric boolean  False[ReadWrite]
NumericValue  double   0.0  [ReadWrite]
StringValue   string[ReadWrite]


The blank field (0) uses c.s.s.sheet.FilterOperator.EMPTY with any content.
The empty string field (1) uses c.s.s.sheet.FilterOperator.EQUAL with 
string content .



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: Searching for ”empty” cell (LibreOffice BASIC macro)

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 Snippet(Optional oInitialTarget As Object)
   Dim oDatabaseRanges As Object
   Dim oObj_1 As Object
   Dim oFilterDescriptor As Object
   Dim oFilterFields As Object

   oDatabaseRanges = oInitialTarget.DatabaseRanges
   oObj_1 = oDatabaseRanges.getByIndex(0)
   oFilterDescriptor = oObj_1.getFilterDescriptor()

   oFilterFields = oFilterDescriptor.getFilterFields()
 End Sub



 And this is the output for oFilterFields:

 (Name)(Value Type) (Value)  (AccessMode)
 (0)
 Connection.sheet.FilterConnection  AND  [ReadWrite]
 Field long 0[ReadWrite]
 Operator  .sheet.FilterOperatorEMPTY[ReadWrite]
 IsNumeric boolean  True [ReadWrite]
 NumericValue  double   0.0  [ReadWrite]
 StringValue   string  [ReadWrite]
 (1)
 Connection.sheet.FilterConnection  OR   [ReadWrite]
 Field long 0[ReadWrite]
 Operator  .sheet.FilterOperatorEQUAL[ReadWrite]
 IsNumeric boolean  False[ReadWrite]
 NumericValue  double   0.0  [ReadWrite]
 StringValue   string  [ReadWrite]


 The blank field (0) uses c.s.s.sheet.FilterOperator.EMPTY with any content.
 The empty string field (1) uses c.s.s.sheet.FilterOperator.EQUAL with string
 content .

Thanks. I'll take a closer look at it tomorrow. Too tired and confused
right now.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ




 --
 For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
 Problems?
 http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
 Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
 List archive: http://listarchives.libreoffice.org/global/users/
 All messages sent to this list will be publicly archived and cannot be
 deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Multiple page styles on one page?

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 Templates might help?
http://wiki.documentfoundation.org/Documentation/Publications

Regards from
Tom :)  


--- On Fri, 20/7/12, Mirosław Zalewski mini...@poczta.onet.pl wrote:

From: Mirosław Zalewski mini...@poczta.onet.pl
Subject: Re: [libreoffice-users] Multiple page styles on one page?
To: users@global.libreoffice.org
Date: Friday, 20 July, 2012, 20:15

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 1.0.  Our company name and address would be
 shown there.  No problem doing that, but then, I need to change the margins
 to all be set at 1.
 
 I've tried using styles and/or headers, but I can't get it to work.  Is
 this possible?

I don't understand. 

You need to have page with all margins set to 1 and company data at header? 
So you need one page style.

Or maybe you want one page with different margins, and another with margins set 
to 1, both displaying company data in header (having different margins in one 
document isn't the best idea, though)? Then you need two page styles. You must 
copy company data from header of one style to header of second style. If you 
ever change that data in one header, you must do so for second.

Please post detailed explanation of what are expected results of your work, 
what are you trying to achieve.
-- 
Best regards
Mirosław Zalewski

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Searching for ”empty” cell (LibreOffice BASIC macro)

2012-07-20 Thread MiguelAngel


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


yep looking for not empty you need regular expressions


I did some brutal experimenting and after hundreds of swearwords (the
damned crap freeze all the time) I actually found something. Have a
look at this descriptor:

 With SearchDescriptor
 .SearchByRow=False
 .SearchRegularExpression=True
 .SearchString=^[^.]$
 .SearchType=1 ' Search values.
 End With

First it didn't work as I expected, but it found another cell in
another column. That cell has a semi complicated formula with nested
IF's and in this case it returns F2+STYLE(Hide). F2 in this case is
an empty cell, so now I changed the formula in the cell I wanted to
find, by just replacing the two quotes () with F2, and now it finds
the cell!

So  is not good enough for making a cell empty, but I can reference
to a cell that actually is empty!

So what I need to do now, is to change all the formulas in one column,
and the search descriptor above will work, as it seems!


At least I'll try that.


Ok, I'd just better give up, I guess. LibreOffice seems to be way too
slow for the things I do (I am surprised that I seem to be the only
one who actually do something with spreadsheets, except simple tables
of a few rows and columns, doing close to nothing, more or less). Many
years ago I did similar things in Excel. It crashed now and then, but
it was fast, at least. Things that took maybe one second to execute in
Excel seems to take hours in LibreOffice these days. I don't know
exactly how long they take, since I can never wait for more than a
couple of minutes before I restart it. It's very frustrating, when
testing new stuff. Simple developing a spreadsheet (something that you
shouldn't do, obviously) takes days instead of minutes.

I am not sure where things go slow. My current spreadsheet isn't
particularly big. There are currently about 2000 rows in 5 columns
containing formulas and there is one column with about 3300 rows of
formulas. Not that complicated formulas, mostly nested IF's. One of
the 2000 row columns use a custom formula (written in LibreOffice
BASIC), not very complicated: It reads the values from two cells and
returns a string value depending on the input values. A few IF's,
that's all.
I also use conditional formatting in all of the cells, approximately
3300+6×2000=15300 cells. It's not like millions of cells or something.

What is likely the most time consuming part in this case? My own cell
formula in a couple of hundred cells? The conditional formatted cells?
All those longer formulas with nested IF's?

Anyway, back to the subject… The thing I wrote about that regular
expression above was not quite accurate. I am not sure what to think
any more, it all feels like a mess, kind of. It seems like cells
containing a number also is found with the search descriptor above. I
am not sure why this is considered a proper behaviour, but maybe it
is.

Well, I am not sure what more to say, feel quite confused, to say the least…

What are you other guys using a spreadsheet for? It seems like
whatever I try to do, it all turns out as an extremely slow confusing
mess.


Sorry for being such a jerk.


Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ




Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ




then SearchType 1 on the found area


Area? You mean what's found when setting ”search all”?


no you can define the erea (cells) you want to searched so when you found
that 1 cell has a formula, you need to check only this cell on a value


the SearchString has a different meaning , depending on the .SearchType
= 1 then the SearchString is the is the result of the formula or the
value
content


Okay, that's not very well designed… at least not in my opinion.


= 0 then the SearchString is the formula string


Meaning what if a cell contains only a value?


hope it helps


I don't know, will do some tests later, but it certainly feels
confusing at the moment, because when I use the Search/Replace
dialogue, it doesn't work like that at all. Selecting ”Values” in the
dialogue give me the result I want, it finds the first cell with an
empty value (in this case a cell with a formula that returns that
empty value – ). So one question that comes to my mind is why the
LibreOffice Basic Search doesn't work the same way as the dialogue.
Maybe it's just fun to confuse the users…

As I said, I will do some more tests and come back here later.


Thanks for replying.

Kind regards

Johnny Rosenberg
ジョニー・ローゼンバーグ


Fernand


Just can't figure it out. I have

[libreoffice-users] Labeling in Calc

2012-07-20 Thread Andrew Brager

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 it's own row 
containing branch name, address, phone, etc. but I need a way to tie 
them all together as being Bank of America, ideally without creating a 
column that is repeated for all rows.


That way, as I'm scanning down the page, I can choose a particular bank 
and then select a specific branch of that bank.


I've tried using the Group function which I kind of like, however 
there's no way I can find to label the group itself with the bank name.  
I have to open each group and _still _don't necessarily know which bank 
it is.


I've got a picture in my head that looks like a box which contains all 
the rows, and the box itself has a caption with the bank name. I'm open 
to any solution especially a better one.


Using a database is not an option.

Thank you in advance

--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] now can Purchase a NA-DVD

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 Purchase a NA-DVD
To: LibreO - Marketing US market...@us.libreoffice.org, LibreO - Users 
Global users@global.libreoffice.org
Cc: er...@libreofficebox.org er...@libreofficebox.org, m...@marcpare.com, 
Tom Davies tomdavie...@yahoo.co.uk
Date: Friday, 20 July, 2012, 15:08


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 shipping, and that will give TDF/LO a donation of the profit.

Finally, you can now buy a professionally made DVD at a good price.

Drew has stated that he wants to get the purchase into an Amazon account so it 
can be purchased through them.  There are people who would rather buy things 
through Amazon.com than direct from the producers.  I buy many things there 
even though I can buy them at other sites.

SO
Now people can buy a NA-DVD instead of downloading the ISO file.

THIS will help those who use dial-up since they would not want to spend the 
time downloading a 200 MB Windows install file.



-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Searching for ”empty” cell (LibreOffice BASIC macro)

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


 yep looking for not empty you need regular expressions


 I did some brutal experimenting and after hundreds of swearwords (the
 damned crap freeze all the time) I actually found something. Have a
 look at this descriptor:

  With SearchDescriptor
  .SearchByRow=False
  .SearchRegularExpression=True
  .SearchString=^[^.]$
  .SearchType=1 ' Search values.
  End With

 First it didn't work as I expected, but it found another cell in
 another column. That cell has a semi complicated formula with nested
 IF's and in this case it returns F2+STYLE(Hide). F2 in this case is
 an empty cell, so now I changed the formula in the cell I wanted to
 find, by just replacing the two quotes () with F2, and now it finds
 the cell!

 So  is not good enough for making a cell empty, but I can reference
 to a cell that actually is empty!

 So what I need to do now, is to change all the formulas in one column,
 and the search descriptor above will work, as it seems!


 At least I'll try that.


 Ok, I'd just better give up, I guess. LibreOffice seems to be way too
 slow for the things I do (I am surprised that I seem to be the only
 one who actually do something with spreadsheets, except simple tables
 of a few rows and columns, doing close to nothing, more or less). Many
 years ago I did similar things in Excel. It crashed now and then, but
 it was fast, at least. Things that took maybe one second to execute in
 Excel seems to take hours in LibreOffice these days. I don't know
 exactly how long they take, since I can never wait for more than a
 couple of minutes before I restart it. It's very frustrating, when
 testing new stuff. Simple developing a spreadsheet (something that you
 shouldn't do, obviously) takes days instead of minutes.

 I am not sure where things go slow. My current spreadsheet isn't
 particularly big. There are currently about 2000 rows in 5 columns
 containing formulas and there is one column with about 3300 rows of
 formulas. Not that complicated formulas, mostly nested IF's. One of
 the 2000 row columns use a custom formula (written in LibreOffice
 BASIC), not very complicated: It reads the values from two cells and
 returns a string value depending on the input values. A few IF's,
 that's all.
 I also use conditional formatting in all of the cells, approximately
 3300+6×2000=15300 cells. It's not like millions of cells or something.

 What is likely the most time consuming part in this case? My own cell
 formula in a couple of hundred cells? The conditional formatted cells?
 All those longer formulas with nested IF's?

 Anyway, back to the subject… The thing I wrote about that regular
 expression above was not quite accurate. I am not sure what to think
 any more, it all feels like a mess, kind of. It seems like cells
 containing a number also is found with the search descriptor above. I
 am not sure why this is considered a proper behaviour, but maybe it
 is.

 Well, I am not sure what more to say, feel quite confused, to say the
 least…

 What are you other guys using a spreadsheet for? It seems like
 whatever I try to do, it all turns out as an extremely slow confusing
 mess.


 Sorry for being such a jerk.


 Kind regards

 Johnny Rosenberg
 ジョニー・ローゼンバーグ



 Kind regards

 Johnny Rosenberg
 ジョニー・ローゼンバーグ


 then SearchType 1 on the found area


 Area? You mean what's found when setting ”search all”?


 no you can define the erea (cells) you want to searched so when you
 found
 that 1 cell has a formula, you need to check only this cell on a value

 the SearchString has a different meaning , depending on the
 .SearchType
 = 1 then the SearchString is the is the result of the formula or the
 value
 content


 Okay, that's not very well designed… at least not in my opinion.

 = 0 then the SearchString is the formula string


 Meaning what if a cell contains only a value?


 hope it helps


 I don't know, will do some tests later, but it certainly feels
 confusing at the moment, because when I use the Search/Replace
 dialogue, it doesn't work like that at all. Selecting ”Values” in the
 dialogue give me the result I want, it finds the first cell with an
 empty value (in this case a cell with a formula that returns that
 empty value – ). So one question that comes to my mind is why the
 LibreOffice Basic Search doesn't work the same way as the dialogue.
 Maybe it's just fun to confuse the users…

 As I said, I will do some more tests

Re: [libreoffice-users] now can Purchase a NA-DVD



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.


That is a good pricing, since have that is shipping and 75%+ of the rest 
is profit for TDF/LibreOffice.


Now we can finally have a place where dial-up users can get the file 
they want/need on a DVD instead of trying to use their dial-up account 
to download even the 200 MB Windows install file, plus the help pack.


I may buy one myself as a show-piece so I can have one on hand to show 
people what they get with their order, and where to order.


After a year working on the DVDs, 3.3 line, 3.4 line, and now 3.5 line 
[3.5.5], it all is getting in place for what the NA-DVD was created for.



On 07/20/2012 03:57 PM, Tom Davies wrote:

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 Purchase a NA-DVD
To: LibreO - Marketing US market...@us.libreoffice.org, LibreO - Users Global 
users@global.libreoffice.org
Cc: er...@libreofficebox.org er...@libreofficebox.org, m...@marcpare.com, Tom 
Davies tomdavie...@yahoo.co.uk
Date: Friday, 20 July, 2012, 15:08


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 shipping, and that will give TDF/LO a donation of the profit.

Finally, you can now buy a professionally made DVD at a good price.

Drew has stated that he wants to get the purchase into an Amazon account so it 
can be purchased through them.  There are people who would rather buy things 
through Amazon.com than direct from the producers.  I buy many things there 
even though I can buy them at other sites.

SO
Now people can buy a NA-DVD instead of downloading the ISO file.

THIS will help those who use dial-up since they would not want to spend the 
time downloading a 200 MB Windows install file.



-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted





--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Labeling in Calc

2012-07-20 Thread Andrew Brager


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 word wrapping for 
that one cell.



On 7/20/2012 12:57 PM, Andrew Brager wrote:
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 it's own 
row containing branch name, address, phone, etc. but I need a way to 
tie them all together as being Bank of America, ideally without 
creating a column that is repeated for all rows.


That way, as I'm scanning down the page, I can choose a particular 
bank and then select a specific branch of that bank.


I've tried using the Group function which I kind of like, however 
there's no way I can find to label the group itself with the bank 
name.  I have to open each group and _still _don't necessarily know 
which bank it is.


I've got a picture in my head that looks like a box which contains all 
the rows, and the box itself has a caption with the bank name. I'm 
open to any solution especially a better one.


Using a database is not an option.

Thank you in advance




--
Andrew Brager
Green Gold Real Estate
1331 Cottonwood Rd
Bakersfield, CA 93307
661 412 3304


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: LO for a Mac Powerbook G4