[libreoffice-users] Calc function

2012-04-18 Thread Mike Phelan
I am trying to automatically remove a number from a range of cells, if it 
appears in a different range.

I am creating a spreadsheet where once a number appears in B4:G11 4 times, it 
changes color to Red...got that part.

Then I want to manually enter that number somewhere into J4:N21. once entered 
into J4:N21, i want that number to erase from B4:G11.

ideally at that point i would also like all remaining numbers in B4:G11 to 
shift up, leaving no empty cells above cells with values in them (keeping them 
in the order entered within columns).




-- 
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: Browser plugin gives blank page

2012-04-18 Thread Marc Paré

Hi Tim,

Le 2012-04-17 15:10, webmaster-Kracked_P_P a écrit :

Marc, I have not kept up with this thread.

If you mean opening a .odt file from an online source in Firefox,
[instead of saving to the disk] like it use to do a few months back, I
remember the last 2 or 3 times with Firefox 10 and 11, I got a blank
page myself.

This was Ubuntu 10.04's FF repository versions. I do remember it use to
work fine, but not since the repository went from 3 or 4 straight to 10
and then 11 a week later.

I also was running 3.4.5 then, but now 3.4.6. I wonder if there is a
browser issue and not the LO issue.




Then, if this is the case, it should be reviewed by the LibreOffice devs 
to see if they could make it work again with the newer versions of FF as 
this is an integrated plugin in LibreOffice and not an add-on.


I have to say this is a useful plugin and I hope it is made to work again.

It was reported as a bug in Dec 2011 here: 
https://bugs.freedesktop.org/show_bug.cgi?id=44232


Marc


--
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: Calc function

2012-04-18 Thread Andreas Säger

Am 17.04.2012 19:35, Mike Phelan wrote:

I am trying to automatically remove a number from a range of cells, if it
appears in a different range.

I am creating a spreadsheet where once a number appears in B4:G11 4 times, it
changes color to Red...got that part.

Then I want to manually enter that number somewhere into J4:N21. once entered
into J4:N21, i want that number to erase from B4:G11.

ideally at that point i would also like all remaining numbers in B4:G11 to
shift up, leaving no empty cells above cells with values in them (keeping them
in the order entered within columns).






Only a small set of features adds data to your spreadsheet and nothing 
in Calc will ever remove any data automatically. You have to do that by 
hand or by means of a macro program.
It seems to be another inventory task which should be done in a database 
program of your choice. Later you may connect your database to this 
office suite (this is what the Base component does) and use Calc or 
Writer as output medium for pretty printing and further calculations.



--
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: Problems importing an OO database into LO

2012-04-18 Thread Alexander Thurgood
Le 17/04/12 18:14, Andreas Säger a écrit :

Hi all,

 
 The easiest improvements in my honest opinion:
 - Wipe out the .odb container all together and get back to the
 configuration of database access in OOo 1. Back to external databases
 with configuration data in configuration files, forms and reports in
 stand-alone office documents. More speed more safety, security,
 accessibility and transparency. People who do not understand how to
 connect separated software tools do not understand the .odb container
 neither (as we can read in all the mail merge topics).
 - Remove all the half done wizards. Do not improve them. Remove! No
 database developer nor interface designer needs all this stinky rubbish.
 There are graphical tools to compose forms and reports within office
 documents. There is SQL for all the rest, including all the things we
 can not do in the current graphical interface. There are plenty of SQL
 editors to produce valid SQL for various databases. SQL text can be
 pasted into any database configuration.
 - Add native database queries, so the current direct SQL mode returns
 editable row sets and the (useless or even harmful) graphical query
 designer can be removed as well.
 - Having removed all the wizards (they are Java components) without
 losing any functionality at all, extensions could substitute .odb
 packages. When you open the extension, the database gets installed
 _permanently_ (rather than _temporarily_ like the .odb) into the
 configuration tree together with the forms and reports documents. The
 database will be registered and all the tables, queries, forms and
 reports are accessible form the data source window, hyperlinks and
 desktop links just like it used to be in OOo 1.
 
 

Ah, nostalgia those were halcyon days ;-)

+1 (not that that means anything in our user land.

Unfortunately, as I was told quite a while ago either on the dev-list or
IRC dev channel, or bugzilla,  no-one wants to go back to 10 year old
technology, i.e. the LO devs are not interested in undoing what Sun it
its infinite wisdom thought would be a good idea when it re-invented
OOo-Base, so we are stuck with what we have until someone steps up and
decides to either unravel it all or improve it - a mammoth task by
anyone's standards.


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: Problems importing an OO database into LO

2012-04-18 Thread Alexander Thurgood
Le 17/04/12 20:13, ptoye a écrit :


 
 Is there any point in suggesting that LibO and OO should continue to
 diverge? I'd have thought convergence would be more productive, both in
 terms of the development which seems too thinly spread, and for users who
 might even see a serious contender emerging.
 

To my knowledge (which granted, may be limited), there is not a single
Base developer on the AOOo team. The integration of hsqldb2 had already
been prepared during Oracle's tenure, it was thereafter a matter of
integrating the child workspace of the relevant code. Moreover, AOOo
have dropped future bundling of the Oracle ReportBuilder extension
because of licensing problems with some of the Pentaho libraries, as
with the mysql native connector. In other words, the Base module in AOOo
is effectively at best stalled, at worst crippled with regard to OOo 3.3.x


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: Problems importing an OO database into LO

2012-04-18 Thread Alexander Thurgood
Le 17/04/12 11:28, Ian Whitfield a écrit :

Hi Ian,

While I might agree with your statements with regard to the integrated
use of HSQLDB, I would differ with regard to hooking up Base to various
server backends, which in my experience do work rather well on the
whole, albeit with tweaking, and are multi-OS compatible.

 LONG story short I have now moved my (re-built) Database on to
 Kexi - and what a difference It's like getting out of an old
 broken-down VW (or other make) of car and getting into a brand new
 Jaguar and driving down the highway at 100mph!! And I know what that
 feels like as I did just that last year in the UK!! Yes there is a lot
 to learn and work out but the overall effect is like Chalk and Cheese!!
 
 For anyone interested I can recommend this DB - some of the more fancy
 options are only due out in future releases but for a basic DB job it
 just works!!
 

Is it multi-OS ? Can you create a db/form/query in Kexi and give it to a
Windows, Mac or Solaris user  and then have that work ? If not, then it
is no better than Access, or Lotus Approach.



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] Re: Problems importing an OO database into LO

2012-04-18 Thread Tom Davies
Hi :)
I think Kexi and the rest of Calligra/KOffice has a Windows version just as 
LibreOffice does.  Calligra/KOffice uses ODF natively and presumably can use MS 
formats although i'm not sure quite how well.  
Regards from
Tom :)


--- On Wed, 18/4/12, Alexander Thurgood alex.thurg...@gmail.com wrote:

From: Alexander Thurgood alex.thurg...@gmail.com
Subject: [libreoffice-users] Re: Problems importing an OO database into LO
To: users@global.libreoffice.org
Date: Wednesday, 18 April, 2012, 10:17

Le 17/04/12 11:28, Ian Whitfield a écrit :

Hi Ian,

While I might agree with your statements with regard to the integrated
use of HSQLDB, I would differ with regard to hooking up Base to various
server backends, which in my experience do work rather well on the
whole, albeit with tweaking, and are multi-OS compatible.

 LONG story short I have now moved my (re-built) Database on to
 Kexi - and what a difference It's like getting out of an old
 broken-down VW (or other make) of car and getting into a brand new
 Jaguar and driving down the highway at 100mph!! And I know what that
 feels like as I did just that last year in the UK!! Yes there is a lot
 to learn and work out but the overall effect is like Chalk and Cheese!!
 
 For anyone interested I can recommend this DB - some of the more fancy
 options are only due out in future releases but for a basic DB job it
 just works!!
 

Is it multi-OS ? Can you create a db/form/query in Kexi and give it to a
Windows, Mac or Solaris user  and then have that work ? If not, then it
is no better than Access, or Lotus Approach.



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



[libreoffice-users] Re: Legacy Base reports won't open in LibreOffice 3.5

2012-04-18 Thread Alexander Thurgood
Le 17/04/12 06:26, frofa a écrit :

Hi,

 In LO 3.5 when I click on a particular legacy report to run it, the expected
 window saying Connecting to data source Importing data opens for a
 brief instant, then disappears, leaving just the window with the report
 template layout showing...but no report is ever generated. Note: All the
 queries my reports are based on run perfectly (in LO 3.5) so it doesn't seem
 to be a database connection problem.
 

This sounds like an import problem of the hidden field, and should be
reported as a bug against the Writer component. Or better still, check
to see whether there isn't already a bug report about failed opening of
Writer documents containing hidden fields.

Please also add the workaround you mention in your post.


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] Re: Problems importing an OO database into LO

2012-04-18 Thread Ian Whitfield

On 18/04/2012 11:17, Alexander Thurgood wrote:

Le 17/04/12 11:28, Ian Whitfield a écrit :

Hi Ian,

While I might agree with your statements with regard to the integrated
use of HSQLDB, I would differ with regard to hooking up Base to various
server backends, which in my experience do work rather well on the
whole, albeit with tweaking, and are multi-OS compatible.
Hi Alex - Yes I wanted to try this and everybody said it was easy but 
NOBODY gave me any instructions!! I did mess about with it a few times 
but got nowhere - so I never was able to try this out!!


Is it multi-OS ? Can you create a db/form/query in Kexi and give it to a
Windows, Mac or Solaris user  and then have that work ? If not, then it
is no better than Access, or Lotus Approach.


Kexi is a standard SQLlight format so the files should be movable 
between OpSys-es. I also see that Calligra 2.4 has just been released 
that includes the latest Kexi and this is available on Window$ and they 
are asking for Mac OS Devs also!!


But non of this was a major concern of mine. I run my own DB and used it 
EVERY day. I don't have to pass it on to others so as long as it works 
for me (well) in Linux - that's what I need!!! And so far Kexi is 
delivering, (for me anyway!!).


All the best
Ian W
Pretoria


--
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: Problems importing an OO database into LO

2012-04-18 Thread Tom Davies
Hi :)
The divergence has resulted in at least a doubling of the numbers of people 
working on the project(s).  The projects do have a lot of overlap and share a 
lot.  People that were colleagues working alongside each other may find 
themselves split into different projects but still chatting and helping each 
other.  

Taking just LibreOffice alone, it has famously already had a vast amount of 
devs join in.  The Easy hacks initiative has made it far easier to get devs 
that are familiar with other projects familiarised with programming for 
LibreOffice.  It's helped draw in students and other people that have never 
really done any programming before or left programming years ago and Google's 
Summer of Code has helped draw people into programming for LO too.  

Under Sun the infrastructure had all grown quite tangled so it was good to get 
a fresh start under TDF  maximising the usefulness of  modern technology that 
simply wasn't around when Sun's infrastructure was originally planned.  

The Apache Foundation is quite large and IBM can support their developments but 
would fidn it difficult to support a truly and fully OpenSource project such as 
LibreOffice.  Apparently Apache Licensing allows a mix of some fairly 
proprietary chunks of code alongside OpenSource ones.  

If OOo had just carried on under Sun then it wouldn't have had the resources of 
either Apache nor TDF let alone both!!  

Plus about half the community would have been unhappy about not being fully 
OpenSource and therefore never gaining the backing of the Free Software 
Foundation which has led to a greater range of distros being comfortable using 
LO.  The other half might have wanted to pull us more in the direction of 
corporate secrecy such as IBM seem to want.  This way both sides are happier 
and growing faster.  

Regards from
Tom :)


--- On Wed, 18/4/12, Alexander Thurgood alex.thurg...@gmail.com wrote:

From: Alexander Thurgood alex.thurg...@gmail.com
Subject: [libreoffice-users] Re: Problems importing an OO database into LO
To: users@global.libreoffice.org
Date: Wednesday, 18 April, 2012, 10:17

Le 17/04/12 11:28, Ian Whitfield a écrit :

Hi Ian,

While I might agree with your statements with regard to the integrated
use of HSQLDB, I would differ with regard to hooking up Base to various
server backends, which in my experience do work rather well on the
whole, albeit with tweaking, and are multi-OS compatible.

 LONG story short I have now moved my (re-built) Database on to
 Kexi - and what a difference It's like getting out of an old
 broken-down VW (or other make) of car and getting into a brand new
 Jaguar and driving down the highway at 100mph!! And I know what that
 feels like as I did just that last year in the UK!! Yes there is a lot
 to learn and work out but the overall effect is like Chalk and Cheese!!
 
 For anyone interested I can recommend this DB - some of the more fancy
 options are only due out in future releases but for a basic DB job it
 just works!!
 

Is it multi-OS ? Can you create a db/form/query in Kexi and give it to a
Windows, Mac or Solaris user  and then have that work ? If not, then it
is no better than Access, or Lotus Approach.



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] select en-dash and em-dash characters

2012-04-18 Thread Séamas Ó Brógáin
Tom wrote:

 How do you do that if your system (openSuSE 12.1) only allows two (2) key
 composition?

I didn’t think there was such a restriction. I have a custom compose
list (on Ubuntu), and I just created a three-key combination, and it
works.

Is this something unique to SUSE (which seems unlikely), or is there
something else wrong? Do your two-key combinations work?



-- 
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: Problems importing an OO database into LO

2012-04-18 Thread Tom Davies
Hi :)
That sounds much easier for data-input and normal look-up use for normal users 
that are barely familiar with Word/Writer and Calc/Excel.  

Most normal office workers seem scared of using databases for even low level 
tasks.  This style of use takes away the scary front-end and gives them 
something more familiar.  

It sounds like a slightly tougher challenge for the designers in some ways but 
saves them endless time fiddling around lining up boxes on Forms and Reports.  
If normal office workers can be allowed to do the fiddling then i think that 
suits everyone much better.  

Regards from
Tom :)


--- On Wed, 18/4/12, Fernand Vanrie s...@pmgroup.be wrote:

From: Fernand Vanrie s...@pmgroup.be
Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO
To: users@global.libreoffice.org
Date: Wednesday, 18 April, 2012, 10:55

On 17/04/2012 23:58, Andreas Säger wrote:
 Am 17.04.2012 19:23, Tom Davies wrote:
 Hi :)
 It looks like most of this can be done without touching Base itself?  Is LO 
 able to use databases in this way already?  Is it something that could be 
 passed to the devs list an/or the BoD discussion list?  Something like this 
 could be phrased to capture the imagination,  Saying it's the old way might 
 put them off.
 Regards from
 Tom :)
 
 
 I use to use Base like this. I connect a Base document to HSQL 2.8 databases 
 with forms and reports on the desktop (spreadsheet reports are sufficient for 
 us). The Base container is nothing but a configuration file storing the 
 connection URL, SQL query strings and the default log-in (and I left some 
 rarely used admin forms in it).
 My users do not know anything about the database document.
 The content of the database document could be some XML and query strings in 
 the configuration tree (just like it used to be in OOo 1).
 
 
We are using OO-LO as a front end to connect to MySQL, we no longer use  the 
LO-forms etc , but we usesDialogs and their controls (also Drids and the 
DataSourceBrowser)who are fed with the MySQL-data.
Reporting is done by feeding WriterDocs with the data, or Calc-spreadsheets for 
data oriented reports. Exporting to a spreadsheet is very slow when feeding the 
sheet cell by cell. But using the doimport on a cell range is lightning fast.
 For Connecting, we use the NativeConnector. We try to avoid using a OO-LO 
dbase doc(for safety reasons) and connect directly using the DriverManager. 
This method has a important drawback, The DataSourceBrowser  is not working 
without connecting with dbaseDoc.
when low volume selections (100 lines)using the GridControls is very use full 
but becomes to slow for big selections, here is the DataSource browser a 
possible workaround. GridControls however have the advantage that we can 
color every line, that makes it far more user friendly.
This system is used by 100 users , who can do all their  tasks with only using 
OO-LO

Greetz

Fernand


-- 
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: Problems importing an OO database into LO

2012-04-18 Thread Tom Davies
Hi :)
That is exactly why i wondered if Andreas' points could be worked on while 
leaving the existing package, Base, as it stands.  

That way the database functionality could be moved forwards while leaving the 
kludgy mess (ok, it might not be a kludge from a coders pov) to get sorted 
'later'.

The trees outside my window have been severely pruned back but i know that by 
the summer the leaves will be out in full force.  The trees look a lot 
healthier already as they are not groaning under their own weight.  
Regards from
Tom :)

--- On Wed, 18/4/12, Alexander Thurgood alex.thurg...@gmail.com wrote:

From: Alexander Thurgood alex.thurg...@gmail.com
Subject: [libreoffice-users] Re: Problems importing an OO database into LO
To: users@global.libreoffice.org
Date: Wednesday, 18 April, 2012, 10:05

Le 17/04/12 18:14, Andreas Säger a écrit :

Hi all,

 
 The easiest improvements in my honest opinion:
 - Wipe out the .odb container all together and get back to the
 configuration of database access in OOo 1. Back to external databases
 with configuration data in configuration files, forms and reports in
 stand-alone office documents. More speed more safety, security,
 accessibility and transparency. People who do not understand how to
 connect separated software tools do not understand the .odb container
 neither (as we can read in all the mail merge topics).
 - Remove all the half done wizards. Do not improve them. Remove! No
 database developer nor interface designer needs all this stinky rubbish.
 There are graphical tools to compose forms and reports within office
 documents. There is SQL for all the rest, including all the things we
 can not do in the current graphical interface. There are plenty of SQL
 editors to produce valid SQL for various databases. SQL text can be
 pasted into any database configuration.
 - Add native database queries, so the current direct SQL mode returns
 editable row sets and the (useless or even harmful) graphical query
 designer can be removed as well.
 - Having removed all the wizards (they are Java components) without
 losing any functionality at all, extensions could substitute .odb
 packages. When you open the extension, the database gets installed
 _permanently_ (rather than _temporarily_ like the .odb) into the
 configuration tree together with the forms and reports documents. The
 database will be registered and all the tables, queries, forms and
 reports are accessible form the data source window, hyperlinks and
 desktop links just like it used to be in OOo 1.
 
 

Ah, nostalgia those were halcyon days ;-)

+1 (not that that means anything in our user land.

Unfortunately, as I was told quite a while ago either on the dev-list or
IRC dev channel, or bugzilla,  no-one wants to go back to 10 year old
technology, i.e. the LO devs are not interested in undoing what Sun it
its infinite wisdom thought would be a good idea when it re-invented
OOo-Base, so we are stuck with what we have until someone steps up and
decides to either unravel it all or improve it - a mammoth task by
anyone's standards.


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] More crashes

2012-04-18 Thread Tom Davies
Hi :)
For bug-reporting these 2 guides end-up with roughly the same result.  Noobs to 
OpenSource might prefer the 2nd link but i suspect you might prefer the 1st one
http://wiki.documentfoundation.org/BugReport
https://www.libreoffice.org/get-help/bug/

I'm glad to hear most of your crashing is fixed by going back to the 3.4.6!  
Which version of java are you using now?
Tools - Options - Java
Regards from
Tom :)


--- On Wed, 18/4/12, Jonathan Schultz jonat...@imatix.com wrote:

From: Jonathan Schultz jonat...@imatix.com
Subject: [libreoffice-users] More crashes
To: users@global.libreoffice.org
Date: Wednesday, 18 April, 2012, 1:37

Although reverting to version 3.4.6 stopped some of the crashes I was 
experiencing, I find that I still get regular crashing on certain files.

One particular problem is that trying to copy-and-paste from a master document 
containing 8 sub-documents into a new document causes instant crashing.

And some other spurious files seem to provoke regular crashes.

So my questions are:

1. Any suggested work-arounds for the master document problem?
2. Is it worth my while getting a debug output for these other crashes? And 
where should I report it if I do?

Thanks,
Jonathan

-- 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] Rendering issue on Windows and Draw product

2012-04-18 Thread beldog
Hi people, 

First of all thanks a lot for the hard work you are carrying out.

Few weeks ago I found and issue using LibreOffice Draw product, basically
the issue is i don't see anything in the main window... looks like the
rendering is not working well on my computer. Details as follow:

Product version: 3.5.2 (it is also happening with 3.5.X)
SO: Windows 7 Professional - SP1
Java version: 1.6.0_26

http://nabble.documentfoundation.org/file/n3919611/LibreOffice_3_5_2_rendering_issue.png
 

Is someone experiencing same behaviour?

Thanks in advance,
Hector

--
View this message in context: 
http://nabble.documentfoundation.org/Rendering-issue-on-Windows-and-Draw-product-tp3919611p3919611.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] beware of the m$ subsidiary

2012-04-18 Thread Tom Davies
Hi :)
The question is a moving target and seems to be moving in our favour.  More 
people are using LO/OOo now even if it's often alongside MSO.  

Also it's about how much power and control you have.  There are many 
circumstances where you are totally at the mercy of other people and have to 
accept what they use.  A single job-seeker signing up with agencies, an office 
worker that has to comply with company policy, a company reliant on customers 
who could easily go elsewhere.  However there are many places where you can 
grab power and demand that people treat you with some consideration.  So grab 
when you can and just gently push the rest of the time and gracefully give-in 
but have another go a while later.  

Just my tuppence
Regards from
Tom :)

--- On Wed, 18/4/12, Jay Lozier jsloz...@gmail.com wrote:

From: Jay Lozier jsloz...@gmail.com
Subject: Re: [libreoffice-users] beware of the m$ subsidiary
To: users@global.libreoffice.org
Date: Wednesday, 18 April, 2012, 1:20

On 04/17/2012 06:56 PM, e-letter wrote:
 On 17/04/2012, webmaster-Kracked_P_Pwebmas...@krackedpress.com  wrote:
 Well, it is always good to promote ODF, but if you work in a business
 environment, you cannot get away from MSO's file formats.  I create the
 documents in LO and save my copy in ODF, but I still have to send
 editable files to some people who's business or agency has not or cannot
 switch to LO.  So for these people/businesses/agencies, I need to send
 them MSO file formatted documents.
 
 You could send in odf, which m$ is supposed to support. Growth in the
 quantity of odf documents, together with people complaining to m$
 (instead of complaining to LO!), the long term effect is to force m$
 to improve compatibility with odf, _not_ vice versa! The analogy is
 one of the worse technologies: flash. Thankfully, successful marketing
 of apple products increased the quantity of non-flash devices and
 therefore the demand for other technologies, e.g. html5.
 
 Promote LO and ODF, but you still have to deal with those who have not
 switched over to LO and/or ODF.  Most government agencies [USA] at all
 levels are not allowed to use any other office package but MSO AND are
 forbidden to install software on their computers, including
 screen-savers and such.  I know of one that will not allow the use of
 USB devices as well.  So, until everyone switches to ODF, we must
 continue to save some of our documents to MSO formates and send them off
 to others.
 
I wonder if someone in the USA could sue and win because the MSO format is a 
proprietary format thus requiring users to buy a proprietary product for best 
results. If an agency used only odf formats that are readable by any number of 
free and proprietary products then users are not forced to purchase specific 
product for best results.
 Such organisations were often forced to use m$ie6, whilst the world
 moved forward to using safari, opera, firefox, etc.. The world did not
 wait for m$ to improve their web browser! Therefore, the claim that
 everyone must simultaneously change to odf is a fallacy.
 


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


-- 
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: Browser plugin gives blank page

2012-04-18 Thread Tom Davies
Hi :)
My GnuLinux repos give me a 
mozilla-OpenOffice
plugin but the repos are set-up so that i would have to install OOo to be able 
to use it.  I think it should be grabbed, modified for LO and put on LO's 
Extensions website
Regards from
Tom :)


--- On Tue, 17/4/12, webmaster-Kracked_P_P webmas...@krackedpress.com wrote:

From: webmaster-Kracked_P_P webmas...@krackedpress.com
Subject: Re: [libreoffice-users] Re: Browser plugin gives blank page
To: users@global.libreoffice.org
Date: Tuesday, 17 April, 2012, 20:10

On 04/17/2012 02:46 PM, Marc Paré wrote:
 Hi Jay
 
 Le 2012-04-15 23:47, Jay Lozier a écrit :
 Same results here too; I get a blank page. I am running LO 3.5.2.2
 under Mageia Linux and Java 1.7.0_03 on FF 9.0.1.
 
 Marc
 
 
 Is the problem with the plugin?
 
 
 I think we would need more people to confirm, but, yes, I would say it's with 
 the plugin seeing as everything else on my browser works without any problems.
 
 Marc
 
 

Marc, I have not kept up with this thread.

If you mean opening a .odt file from an online source in Firefox, [instead of 
saving to the disk] like it use to do a few months back, I remember the last 2 
or 3 times with Firefox 10 and 11, I got a blank page myself.

This was Ubuntu 10.04's FF repository versions.  I do remember it use to work 
fine, but not since the repository went from 3 or 4 straight to 10 and then 11 
a week later.

I also was running 3.4.5 then, but now 3.4.6.  I wonder if there is a browser 
issue and not the LO issue.


-- 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: beware of the m$ subsidiary

2012-04-18 Thread Ken Springer

On 4/17/12 6:01 AM, webmaster-Kracked_P_P wrote:

Most government agencies [USA] at all
levels are not allowed to use any other office package but MSO AND are
forbidden to install software on their computers, including
screen-savers and such.


It can be misleading to say something like this (yes, it's true) without 
also saying *why* these policies are in place.


To keep the explanation simple, it's the ability to support the hardware 
and software out there, and ensure security of the system as a whole, 
and do so with diminishing resources.


Been there, done that.  :-)

--
Ken

Mac OS X 10.6.8
Firefox 11.0
Thunderbird 11.0.1
LibreOffice 3.5.1.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] Problems importing an OO database into LO

2012-04-18 Thread Mark Stanton
I think Andreas' approach for end users is a very good idea.
I think, furthermore, that it starts to redefine how databases can be 
used.  that's a good thing and going dowm that track will, I'm sure, 
lead to further developments.

As such, yes, I think it would be a great idea to push that approach.

I think that as an additional and separate approach, what is thought 
of as Base now *should* be made more accessible and useful so that 
the general populace *can* start to do things with data themselves.

Mark Stanton



-- 
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] Problems importing an OO database into LO

2012-04-18 Thread Mark Stanton
  I'm almost thinking of installing something like MySQL and writing my own
  front-end in Java.

I'm sorry if I'm being slow, or not following the conversation properly (lots 
going 
on here at the moment), but, if you're thinking like that, what's wrong with 
Base?
The things you'd need to do, Base does.
The things that approach won't get you, something to present your data, you'd
use Writer/Calc for.

The two problems I've registered (which have a multitude of subsidiaries, I 
know, 
I'm not trying to say Base is great yet, it's clearly not), is that the whole 
thing 
crashes, the answer is use a back end not the embedded system, and the wizards
are cr*p, building your own front end to (eg) MySQL won't help you there.

Andreas' approach of writing queries and setting up Writer documents to use them
does what you want, doesn't it?

Writing documentation for this approach would be a good idea to broadcase these
ideas.

Mark Stanton
One teeny-tiny step for mankind, apparently...



-- 
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] beware of the m$ subsidiary

2012-04-18 Thread Tanstaafl
On 2012-04-17 8:01 AM, webmaster-Kracked_P_P 
webmas...@krackedpress.com wrote:

Well, it is always good to promote ODF, but if you work in a business
environment, you cannot get away from MSO's file formats.  I create the
documents in LO and save my copy in ODF, but I still have to send
editable files to some people who's business or agency has not or cannot
switch to LO.  So for these people/businesses/agencies, I need to send
them MSO file formatted documents.


Sadly, we will soon be rolling out Microsoft Office to most of our 
employees due to the poor support for the new MS xml file formats (we 
get a ton of these from external clients/vendors, and complaining to 
them and begging for them to send the older file formats is simply not 
an option).


I am hoping that Microsofts licensing will allow me to set up a Terminal 
Server and provide 'shared' access to Office (ie, once the max number of 
sessions is in use, other users will get some kind of 'sorry, all 
instances of MSO are in use, please try again later), so we don't have 
to buy a license for everyone...


--
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] beware of the m$ subsidiary

2012-04-18 Thread Tanstaafl

On 2012-04-17 6:56 PM, e-letter inp...@gmail.com wrote:

You could send in odf, which m$ is supposed to support. Growth in the
quantity of odf documents, together with people complaining to m$
(instead of complaining to LO!), the long term effect is to force m$
to improve compatibility with odf,


No, the long term effect, for those doing business, is anyone doing this 
becomes a laughing stock to the clients/vendors they work with... it is 
the ODF format that will be deemed broken, NOT Microsofts poor support 
of it.


--
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: beware of the m$ subsidiary

2012-04-18 Thread Andreas Säger

Am 17.04.2012 13:50, e-letter wrote:

Readers,

M$ is allegedly seeking to invest in interoperability and open
source: 
http://www.infoworld.com/d/open-source-software/microsoft-forms-subsidiary-engage-open-source-communities-190790.

Perhaps more for 'Groklaw', but isn't this a potential trojan horse to
pollute GPLv3? We will see true interoperability only when odf and
openformula become the defaults within m$o. Until then, please avoid
creation of m$ formats using LO and continue to promote odf.



If MS publishes announcements like this one, this is the best indicator 
that nothing will actually happen. It's the usual appeasement blah blah 
towards the public sector.
They just have to wait for their users (and LibO) to spread more OOXML 
documents. Then they have pushed their new de-facto standard.



--
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] Lorem Ipsum is 'sticks' in full screen mode (LO v 3.5.2)

2012-04-18 Thread M Robinson
Hello,

I just installed the LO version 3.5.2, and Magenta's Lorem Ipsum
extension 'sticks' in full screen mode. (Windows 7 64-Bit)

I tried reinstalling the extension but it did not resolve the problem.

http://imagebin.org/208618 (installed)

http://imagebin.org/208619 (uninstalled)

-- 
GnuPG is Free Software (meaning that it respects your freedom).

Extensible, customizable text editor---GNU Emacs; Where's yours?


-- 
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: Spell checker breaks in Windows XP LO 3.5.2

2012-04-18 Thread cbkschroeder
Hi Manfred,

Thanks a lot for your quick response!!

So I've tried as best as I can to replicate what you've suggested.
Unfortunately, I can't seem to make the fat check mark appear anywhere.

For example, post-restart, I see under Tools  Options  Language Settings 
Languages:

http://nabble.documentfoundation.org/file/n3920136/picture_00.png 

Under Tools  Options  Language Settings  Writing Aids I see:

http://nabble.documentfoundation.org/file/n3920136/picture_01.png 

and

http://nabble.documentfoundation.org/file/n3920136/picture_02.png 

In no case can I make this fat check mark appear. Again, it's as though the
extension is broken.

If you have the time to forward some more ideas, I would be grateful!!

Thanks,

Christian




--
View this message in context: 
http://nabble.documentfoundation.org/Spell-checker-breaks-in-Windows-XP-LO-3-5-2-tp3919812p3920136.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] beware of the m$ subsidiary

2012-04-18 Thread Adam Tauno Williams
On Tue, 2012-04-17 at 12:50 +0100, e-letter wrote:
 Readers,
 M$ is allegedly seeking to invest in interoperability and open
 source: 
 http://www.infoworld.com/d/open-source-software/microsoft-forms-subsidiary-engage-open-source-communities-190790.

Oh, whatever.  And this sent from a gmail account.  Yea.


-- 
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: Spell checker breaks in Windows XP LO 3.5.2

2012-04-18 Thread Manfred J. Krause
Hi Christian,

On Wed, Apr 18, 2012 at 4:24 PM, cbkschroeder [via Document Foundation Mail
Archive] ml-node+s969070n3920136...@n3.nabble.com wrote:

 Hi Manfred,

 Thanks a lot for your quick response!!

 So I've tried as best as I can to replicate what you've suggested.
 Unfortunately, I can't seem to make the fat check mark appear anywhere.

 For example, post-restart, I see under Tools  Options  Language Settings
  Languages:

 [image: picture 00]

 Under Tools  Options  Language Settings  Writing Aids I see:

 [image: picture 01]

 and

 [image: picture 02]

 In no case can I make this fat check mark appear. Again, it's as though
 the extension is broken.

 If you have the time to forward some more ideas, I would be grateful!!



I'm pretty sure that something is broken in your LibreOffice user profile.
[1]

You might try to re-synchronize the 'bundled dictionaries':

- Close LibreOffice (+ Quickstarter, if enabled)
- Go to '...\Documents and Settings\user name\Application
Data\LibreOffice\3\user\extensions\bundled'
- Rename the folder 'bundled' to (e.g.) 'bundled_old'
- Restart LibO.

A new folder 'bundled' will be created in the user profile.
All bundled dictionaries should be available.

Hope this helps...

Addendum:
(1) Checking the program folder 'extensions'
[Path: ...\Program_Files\LibreOffice 3.5\share\extensions]
- Folder 'dict-en' is available (with the file 'en_US.dic' [among others])?

(2) Your LibreOffice 3.5.2 installation: default or customized installation?

(3) Does the problem occur--right from start--with
- a renamed LibreOffice user profile
- another / a new user (OS level)?

mjk


[1] https://wiki.documentfoundation.org/Documentation/UserProfile


--
View this message in context: 
http://nabble.documentfoundation.org/Spell-checker-breaks-in-Windows-XP-LO-3-5-2-tp3919812p3920385.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] beware of the m$ subsidiary

2012-04-18 Thread Paul D. Mirowsky

Intermediate free software required.

It appears to be time for an intermediate translation software be made 
available.

Similar to those that change image types between png, jpg and tiff.

The idea is a free translation software that sits in between the file 
and the program calling for the file.
When the file is called, the intermediate delivers to the program in the 
file type requested.


The intermediate software filter should be freely available for all 
operating systems.
The consumer installs once and is never bothered again with this issue.  
Updates are backgrounded.


This also isolates issues of files not correctly importing/exporting and 
removes it as an issue from the program the user wants.


Those who claim proprietary cannot claim foul, can remain isolated and 
cannot claim foul when not forthcoming with assistance.


Whaddayathink?

On 4/17/2012 7:50 AM, e-letter wrote:

Readers,

M$ is allegedly seeking to invest in interoperability and open
source: 
http://www.infoworld.com/d/open-source-software/microsoft-forms-subsidiary-engage-open-source-communities-190790.

Perhaps more for 'Groklaw', but isn't this a potential trojan horse to
pollute GPLv3? We will see true interoperability only when odf and
openformula become the defaults within m$o. Until then, please avoid
creation of m$ formats using LO and continue to promote odf.



--
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] beware of the m$ subsidiary

2012-04-18 Thread Tom Davies
Hi :)
+1
but if we keep gently pushing, where we can, things will keep making progress.  
It does help to have louder campaigners such as FSF and Richard Stallman.  It 
would be great if e-letter could join FSF if he/she hasn't already.  
Regards from
Tom :)


--- On Wed, 18/4/12, Tanstaafl tansta...@libertytrek.org wrote:

From: Tanstaafl tansta...@libertytrek.org
Subject: Re: [libreoffice-users] beware of the m$ subsidiary
To: users@global.libreoffice.org
Date: Wednesday, 18 April, 2012, 13:48

On 2012-04-17 6:56 PM, e-letter inp...@gmail.com wrote:
 You could send in odf, which m$ is supposed to support. Growth in the
 quantity of odf documents, together with people complaining to m$
 (instead of complaining to LO!), the long term effect is to force m$
 to improve compatibility with odf,

No, the long term effect, for those doing business, is anyone doing this 
becomes a laughing stock to the clients/vendors they work with... it is the ODF 
format that will be deemed broken, NOT Microsofts poor support of it.

-- 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: Calc function

2012-04-18 Thread Johnny Rosenberg
Den 18 april 2012 09:47 skrev Andreas Säger ville...@t-online.de:
 Am 17.04.2012 19:35, Mike Phelan wrote:

 I am trying to automatically remove a number from a range of cells, if it
 appears in a different range.

 I am creating a spreadsheet where once a number appears in B4:G11 4 times,
 it
 changes color to Red...got that part.

 Then I want to manually enter that number somewhere into J4:N21. once
 entered
 into J4:N21, i want that number to erase from B4:G11.

 ideally at that point i would also like all remaining numbers in B4:G11 to
 shift up, leaving no empty cells above cells with values in them (keeping
 them
 in the order entered within columns).





 Only a small set of features adds data to your spreadsheet and nothing in
 Calc will ever remove any data automatically. You have to do that by hand or
 by means of a macro program.
 It seems to be another inventory task which should be done in a database
 program of your choice. Later you may connect your database to this office
 suite (this is what the Base component does) and use Calc or Writer as
 output medium for pretty printing and further calculations.

I actually think it's possible with cell functions only, but I think
it would be quite complicated. Too complicated for me, anyway.

I did something else that I also thought was impossible first, but I
solved it eventually. It was not easy (for me) though… My task was to
create a list of things that is sorted automatically. The formulas
were quite long and hard to read…


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


Re: [libreoffice-users] Re: beware of the m$ subsidiary

2012-04-18 Thread Tom Davies
Hi :)
Interestingly apparently many US government agencies and departments use 
GnuLinux for most of their server-side and infra-structure but had to cave 
into users demands for MS on their desktops.  

An interesting quiet little press release appeared on the DistroWatch website a 
few days ago.  
http://distrowatch.com/
Scroll down to the note written 2012-04-13

A new version of Lightweight Portable Security (LPS),
 a Linux live CD with strong privacy protection features created by the 
United States Department of Defence, is out. Version 1.3.3 is a 
maintenance release, updating Firefox, Flash, Adobe Reader and OpenSSL, 
and adding Thunderbird and Pidgin to the deluxe edition. From the changelog: 
Changes
 in version 1.3.3: updated Firefox to 10.0.3 ESR; updated Flash to 
11.2.202.228; updated OpenSSL to 0.9.8u; updated Adobe Reader to 9.5.1; 
updated Encryption Wizard application to 3.3.2; added Thunderbird 3.1.20
 and DAVmail to LPS-Public Deluxe for S/MIME email support with MS 
Exchange OWA; added Pidgin 2.10.2 (with SameTime support); added VMware 
View 1.4; added option for OpenDNS DNSCrypt; added Firefox extension 
HTTPS Everywhere 2.0.1; added Firefox extension NoScript 2.3.7 (disabled
 by default). Download (SHA256) the live CD images from the project's download 
server: LPS-1.3.3_public.iso (176MB), LPS-1.3.3_public_deluxe.iso (377MB).

Shamelessly copypasted from the DW site.  See the original here
http://distrowatch.com/?newsid=07201
if it has scrolled off the bottom of the DW front page.  

Err, i bcc'd one of the main people, probably the top person at DW just to keep 
him in the loop
Regards from
Tom :)



--- On Wed, 18/4/12, Ken Springer snowsh...@q.com wrote:

From: Ken Springer snowsh...@q.com
Subject: [libreoffice-users] Re: beware of the m$ subsidiary
To: users@global.libreoffice.org
Date: Wednesday, 18 April, 2012, 12:14

On 4/17/12 6:01 AM, webmaster-Kracked_P_P wrote:
 Most government agencies [USA] at all
 levels are not allowed to use any other office package but MSO AND are
 forbidden to install software on their computers, including
 screen-savers and such.

It can be misleading to say something like this (yes, it's true) without also 
saying *why* these policies are in place.

To keep the explanation simple, it's the ability to support the hardware and 
software out there, and ensure security of the system as a whole, and do so 
with diminishing resources.

Been there, done that.  :-)

-- Ken

Mac OS X 10.6.8
Firefox 11.0
Thunderbird 11.0.1
LibreOffice 3.5.1.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



Re: [libreoffice-users] Spell checker breaks in Windows XP LO 3.5.2

2012-04-18 Thread webmaster-Kracked_P_P


Do me a favor, try using this Canadian English dictionary. [en-CA]

http://libreoffice-na.us/English-3.4-installs/add-on-dictionaries-large-list/kpp-canadian-english-dictionary-638K-word-list.oxt

See if it over-writes some of the default files for you enough for it 
to work for your needs.


There may be some part of the locked, default, dictionary that is 
causing you the issues.  I wonder if a different English dictionary 
would solve the problems, since with several dictionaries installed, I 
see the last one is checked first.  That is what happens when I look at 
the Thesaurus part of the dictionaries.  I seen my Thesaurus listing 
show up before the default installed version's listings.  So I hope the 
the English spelling part will be used first, or over write the previous 
versions in the file[s] that contain the used dictionary information.


It might help, or it may not.  I deal with en-US as my default 
language.  I tend to make sure a US version is installed instead of a 
generic all English version.  I think the default one includes many 
non-North American English localizations, like South African English.


This is the en-US version of the dictionary.
http://libreoffice-na.us/English-3.4-installs/add-on-dictionaries-large-list/kpp-american-english-dictionary-638k-word-list.oxt

Try the dictionary extensions.  See if that helps your issue.  Also, my 
versions have more words in its word lists than the default installed 
one and any other version I can find. 638,000+ words for the largest 
en-CA version, with 217K words in the smallest en-CA version.


On 04/18/2012 08:38 AM, cbkschroeder wrote:

Hi,

The spell checker in LibreOffice 3.5.2 seems to spontaneously break. This
happened to me on previous versions, too. I have spent too much time going
through various channels to try to solve the problem; lots of workarounds --
installing other dictionaries, for example -- can be found. These
workarounds don't, of course, solve the problem. I'm using US English, and
I'm in Canada. Before I waste somebody's time by submitting a bug report, I
thought I'd try here for input.

It seems that one day I will happily be using writer with the spell check
running 100%. Then, next day, the spell checker doesn't seem to work
anymore. Poof. I've got XP SP3. It seems as though the English dictionary
extension somehow breaks despite my doing nothing in regard to configuring
the software beyond default. I had entertained that running OS updates might
be breaking the software, so I tried the following, though I couldn't
replicate the issue. I know, this may seem like a lot to post for a negative
result, but I feel it might be useful to know what DOESN'T seem to cause the
problem.

- Reverted to 120401 OS backup image made via True Image; LibreOffice 3.5.1
was installed; spell check didn't work. Most recent round of XP updates had
not been applied.
- Uninstalled Libreoffice 3.5.1
- Deleted LibreOffice folder in Program Files
- Deleted LibreOffice folder in C:\Documents and
Settings\Administrator\Application Data
- Deleted LibreOffice shortcuts in Start menu
- Ran CCleaner
- Rebooted
- Installed LibreOffice 3.5.2 and helppack.
- Rebooted.
- Ran LibreOffice Writer. Touched nothing, just started typing gobbledegook.
US English spell check was active and lots of little red squiggly error
underlines indicated the spell check was working.
- Went to tools, options, language settings, languages, and under Default
Languages for Documents there was a nice fat check mark with ABC written
over top of it beside the Default - English (USA) setting. Several other
languages present here also had that thick check mark.
- User interface setting was Default - English (USA), Locale setting was
Default - English (USA). I took a snapshot of the window:

http://nabble.documentfoundation.org/file/n3919812/picture_00.png

- When I went to the extension manager, scrolled down to English Spelling
Dictionaries and left-clicked to highlight it, I saw that an Options
button appeared:

http://nabble.documentfoundation.org/file/n3919812/picture_01.png

Clicking it opened yet another window which said English Sentence Checking:

http://nabble.documentfoundation.org/file/n3919812/picture_02.png

- Ran CCleaner 3.17.1689, ran the cleaner function, ran the registry Scan
for Issues function, fixed all issues, and rebooted.
- Started writer again, discovered the state of the program was unchanged
from the above description. Everything worked fine. The last CCleaner
execution clearly did not adversely effect LO.
- Proceeded to run the windows updates one by one.
 - Cumulative Security Update for Internet Explorer 8 for Windows XP
(KB2675157). Rebooted. LO OK. Ran CCleaner. Rebooted. LO OK.
- Security Update for Windows XP (KB2653956). Rebooted. LO OK. Ran
CCleaner. Rebooted. LO OK.
- Windows Malicious Software Removal Tool - April 2012 (KB890830).
Rebooted. LO OK. Ran CCleaner. Rebooted. LO OK.
- Security Update for 

Re: [libreoffice-users] select en-dash and em-dash characters

2012-04-18 Thread Johnny Rosenberg
Den 17 april 2012 22:32 skrev Thomas Taylor li...@comcast.net:
 On Tue, 17 Apr 2012 18:09:31 +0200
 Johnny Rosenberg gurus.knu...@gmail.com wrote:

 Den 16 april 2012 22:36 skrev Séamas Ó Brógáin s...@iol.ie:
  Regina wrote:
 
  They are usually written via AutoCorrect. The simple hyphen is replaced
  with the en-dash or em-dash when the following word is finished . . .
 
  That is _not_ a good idea. The hyphen, en rule and em rule (dash) are
  distinct characters with distinct uses in conventional typography and
  typesetting. Their correct use cannot be predicted by context, nor are
  they interchangeable.
 
  You need to find out where these characters are in the character set you
  are using. This depends on your operating system, your language, and
  your keyboard layout.
 
  As Johnny pointed out, they can be entered with the compose key. If you
  use them so often that even this is too cumbersome you can customise
  your keyboard layout,

 That's actually what I did (called ”Sweden Johnny Rosenberg”,
 available on my computers only…), but I didn't mention it because I
 thought it could be a bit tricky…
 I have the en-dash at AltGr+- and the em-dash at AltGr+Shift+-. I also
 did a lot of other modification, like removed all my numbers from the
 first row (I already have them on the num pad to the right – why have
 them at more than one place?) and moved some Shift+number combinations
 so I don't need Shift for characters like ”!#%/” and so on. I even
 made labels to put on my keys, but most of them was worn out after a
 couple of weeks of typing…

 To change the layout (or rather add a new one in this case), you need
 to fiddle with three files (at least in Ubuntu):
 /usr/share/X11/xkb/rules/evdev.lst, /usr/share/X11/xkb/rules/evdev.xml
 and /usr/share/X11/xkb/symbols/the file representing your language,
 more on that another time…

 Ok, this was a bit off topic…


 Kind regards

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

 so that (for example) compose-hyphen gets you the
  en rule and shift-compose-hyphen gets you the dash (em rule). If you
  want to do this I will help you (but only if you use GNU/Linux!).
 
  You could, as Johnny suggests, create your own auto-correct sequences,
  but personally I would avoid all such contrivances. Auto-correct is
  _not_ your friend.
 
 
 
 
 
 
 
  --
  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


 Hi Johnny;
 Out of curiosity, what is AltGr+ ? Alt is of course the Alt key on the
 keyboard but which key is Gr?  My keyboard (an old IBM windows model) doesn't
 have such a key.

 Thanks, Tom

I saw that someone already answered, but I'll reply anyway.
The ”+” does only mean that the key is hold. So Alt+Shift+x means that
Alt, Shift and x is pressed simultaneously, or at least that no key is
released before the other keys is pressed.
The compose key doesn't work that way, therefore no ”+” sign: ”Compose
--.” means ”hit the Compose key, release it, then type --.”.

About the AltGr key, I don't think it exists on standard US keyboards,
for example. Many other languages though, use some characters that are
not on a regular US keyboard, like in my case, Swedish.
We have three extra letters in our alphabet: A-Z, then ÅÄÖ and the
same for lower case (a-z, åäö). That means that there are not enough
keys for everything, so characters like ”{[]}\|” are omitted, or at
least replaced by our Swedish characters. We need them sometimes
anyway though, so they are placed on other keys and we can type them
by using the AltGr key, for example AltGr+8 for ”[” and AltGr+9 for
”]”. On the other hand, at least with Swedish keyboards, they have no
right Alt key, only one to the left, so I guess AltGr is simply the
right Alt key. It's placed immediately to the right of the space key,
at least on my keyboard.


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


Re: [libreoffice-users] select en-dash and em-dash characters

2012-04-18 Thread Johnny Rosenberg
Den 18 april 2012 02:12 skrev Thomas Taylor li...@comcast.net:
 On Tue, 17 Apr 2012 10:48:22 +0100
 Séamas Ó Brógáin s...@iol.ie wrote:

 Doug:

 Using the compose key, the default settings are:

    dash (em rule)      ---
    en rule:            --.







 How do you do that if your system (openSuSE 12.1) only allows two (2) key
 composition?

 Thanks, Tom

I have had OpenSUSE some years back (I think it was 11.3 or
something), but unfortunately I didn't test this…
However, this page doesn't say anything about that the compose key
behaviour is depending on your GNU/Linux-distribution, so I thought
this was true for all of them.
Maybe it's a Gnome thing and you have the KDE version of OpenSUSE?
Well, I don't think so, but I use Gnome only, so I don't know.


Best 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


Re: [libreoffice-users] select en-dash and em-dash characters

2012-04-18 Thread Johnny Rosenberg
Den 18 april 2012 18:19 skrev Johnny Rosenberg gurus.knu...@gmail.com:
 Den 18 april 2012 02:12 skrev Thomas Taylor li...@comcast.net:
 On Tue, 17 Apr 2012 10:48:22 +0100
 Séamas Ó Brógáin s...@iol.ie wrote:

 Doug:

 Using the compose key, the default settings are:

    dash (em rule)      ---
    en rule:            --.







 How do you do that if your system (openSuSE 12.1) only allows two (2) key
 composition?

 Thanks, Tom

 I have had OpenSUSE some years back (I think it was 11.3 or
 something), but unfortunately I didn't test this…
 However, this page doesn't say anything about that the compose key
 behaviour is depending on your GNU/Linux-distribution, so I thought
 this was true for all of them.

Forgot to include the link to ”this page”… sorry… :D
Here it is:
http://www.hermit.org/Linux/ComposeKeys.html

 Maybe it's a Gnome thing and you have the KDE version of OpenSUSE?
 Well, I don't think so, but I use Gnome only, so I don't know.


 Best 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


Re: [libreoffice-users] select en-dash and em-dash characters

2012-04-18 Thread T. R. Valentine
Even Micro$oft Windoze has keyboards using the AltGr.

For a list of available keyboard layouts in Windoze:
http://msdn.microsoft.com/en-us/goglobal/bb964651

An example of a U.S. English (US-International) keyboard layout which
uses the AltGr:
http://www.microsoft.com/resources/msdn/goglobal/keyboards/kbdusx.html


On my main PC (Linux), I use the English-International keyboard as my
default layout because a lot of my typing uses words in French,
German, and other languages. It is way easier than having to open
Character Map, find the desired character, copy it, and paste. AFAIK,
all Linux flavours and all Windoze versions have the ability to switch
between keyboard layouts.


-- 
T. R. Valentine
Your friends will argue with you. Your enemies don't care.
'When I get a little money I buy books; and if any is left I buy food
and clothes.' -- Erasmus

-- 
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] select en-dash and em-dash characters

2012-04-18 Thread Thomas Taylor
On Wed, 18 Apr 2012 18:10:18 +0200
Johnny Rosenberg gurus.knu...@gmail.com wrote:

 Den 17 april 2012 22:32 skrev Thomas Taylor li...@comcast.net:
  On Tue, 17 Apr 2012 18:09:31 +0200
  Johnny Rosenberg gurus.knu...@gmail.com wrote:
 
  Den 16 april 2012 22:36 skrev Séamas Ó Brógáin s...@iol.ie:
   Regina wrote:
  
   They are usually written via AutoCorrect. The simple hyphen is replaced
   with the en-dash or em-dash when the following word is finished . . .
  
   That is _not_ a good idea. The hyphen, en rule and em rule (dash) are
   distinct characters with distinct uses in conventional typography and
   typesetting. Their correct use cannot be predicted by context, nor are
   they interchangeable.
  
   You need to find out where these characters are in the character set you
   are using. This depends on your operating system, your language, and
   your keyboard layout.
  
   As Johnny pointed out, they can be entered with the compose key. If you
   use them so often that even this is too cumbersome you can customise
   your keyboard layout,
 
  That's actually what I did (called ”Sweden Johnny Rosenberg”,
  available on my computers only…), but I didn't mention it because I
  thought it could be a bit tricky…
  I have the en-dash at AltGr+- and the em-dash at AltGr+Shift+-. I also
  did a lot of other modification, like removed all my numbers from the
  first row (I already have them on the num pad to the right – why have
  them at more than one place?) and moved some Shift+number combinations
  so I don't need Shift for characters like ”!#%/” and so on. I even
  made labels to put on my keys, but most of them was worn out after a
  couple of weeks of typing…
 
  To change the layout (or rather add a new one in this case), you need
  to fiddle with three files (at least in Ubuntu):
  /usr/share/X11/xkb/rules/evdev.lst, /usr/share/X11/xkb/rules/evdev.xml
  and /usr/share/X11/xkb/symbols/the file representing your language,
  more on that another time…
 
  Ok, this was a bit off topic…
 
 
  Kind regards
 
  Johnny Rosenberg
  ジョニー・ローゼンバーグ
 
  so that (for example) compose-hyphen gets you the
   en rule and shift-compose-hyphen gets you the dash (em rule). If you
   want to do this I will help you (but only if you use GNU/Linux!).
  
   You could, as Johnny suggests, create your own auto-correct sequences,
   but personally I would avoid all such contrivances. Auto-correct is
   _not_ your friend.
  
  
  
  
  
  
  
   --
   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
 
 
  Hi Johnny;
  Out of curiosity, what is AltGr+ ? Alt is of course the Alt key on the
  keyboard but which key is Gr?  My keyboard (an old IBM windows model)
  doesn't have such a key.
 
  Thanks, Tom
 
 I saw that someone already answered, but I'll reply anyway.
 The ”+” does only mean that the key is hold. So Alt+Shift+x means that
 Alt, Shift and x is pressed simultaneously, or at least that no key is
 released before the other keys is pressed.
 The compose key doesn't work that way, therefore no ”+” sign: ”Compose
 --.” means ”hit the Compose key, release it, then type --.”.

 snip 

Hi Johnny ;)
The problem with the above is that in openSuSE  the compose key only allows two
(2) keystroke combinations, not three (3).  Compose -./-- do not insert
anything.  To me, this is just a point of education as I don't use dash m/n in
my writing.  Just trying to learn a bit.

Thanks for any further explanation. 

Tom

-- 
Tom Taylor - retired penguin
openSUSE 12.1x86_64 openSUSE 12.2x86_64
KDE 4.6.00, FF 7.0  KDE 4.7.2, FF 11.0
claws-mail 3.8.0
registered linux user 263467
linxt-At-comcast-DoT-net

-- 
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] select en-dash and em-dash characters (added)

2012-04-18 Thread Thomas Taylor
On Wed, 18 Apr 2012 18:10:18 +0200
Johnny Rosenberg gurus.knu...@gmail.com wrote:

 Den 17 april 2012 22:32 skrev Thomas Taylor li...@comcast.net:
  On Tue, 17 Apr 2012 18:09:31 +0200
  Johnny Rosenberg gurus.knu...@gmail.com wrote:
 
  Den 16 april 2012 22:36 skrev Séamas Ó Brógáin s...@iol.ie:
   Regina wrote:
  
   They are usually written via AutoCorrect. The simple hyphen is replaced
   with the en-dash or em-dash when the following word is finished . . .
  
   That is _not_ a good idea. The hyphen, en rule and em rule (dash) are
   distinct characters with distinct uses in conventional typography and
   typesetting. Their correct use cannot be predicted by context, nor are
   they interchangeable.
  
   You need to find out where these characters are in the character set you
   are using. This depends on your operating system, your language, and
   your keyboard layout.
  
   As Johnny pointed out, they can be entered with the compose key. If you
   use them so often that even this is too cumbersome you can customise
   your keyboard layout,
 
  That's actually what I did (called ”Sweden Johnny Rosenberg”,
  available on my computers only…), but I didn't mention it because I
  thought it could be a bit tricky…
  I have the en-dash at AltGr+- and the em-dash at AltGr+Shift+-. I also
  did a lot of other modification, like removed all my numbers from the
  first row (I already have them on the num pad to the right – why have
  them at more than one place?) and moved some Shift+number combinations
  so I don't need Shift for characters like ”!#%/” and so on. I even
  made labels to put on my keys, but most of them was worn out after a
  couple of weeks of typing…
 
  To change the layout (or rather add a new one in this case), you need
  to fiddle with three files (at least in Ubuntu):
  /usr/share/X11/xkb/rules/evdev.lst, /usr/share/X11/xkb/rules/evdev.xml
  and /usr/share/X11/xkb/symbols/the file representing your language,
  more on that another time…
 
  Ok, this was a bit off topic…
 
 
  Kind regards
 
  Johnny Rosenberg
  ジョニー・ローゼンバーグ
 
  so that (for example) compose-hyphen gets you the
   en rule and shift-compose-hyphen gets you the dash (em rule). If you
   want to do this I will help you (but only if you use GNU/Linux!).
  
   You could, as Johnny suggests, create your own auto-correct sequences,
   but personally I would avoid all such contrivances. Auto-correct is
   _not_ your friend.
  
  
  
  
  
  
  
   --
   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
 
 
  Hi Johnny;
  Out of curiosity, what is AltGr+ ? Alt is of course the Alt key on the
  keyboard but which key is Gr?  My keyboard (an old IBM windows model)
  doesn't have such a key.
 
  Thanks, Tom
 
 I saw that someone already answered, but I'll reply anyway.
 The ”+” does only mean that the key is hold. So Alt+Shift+x means that
 Alt, Shift and x is pressed simultaneously, or at least that no key is
 released before the other keys is pressed.
 The compose key doesn't work that way, therefore no ”+” sign: ”Compose
 --.” means ”hit the Compose key, release it, then type --.”.

 snip 

Hi Johnny ;)
The problem with the above is that in openSuSE  the compose key only allows two
(2) keystroke combinations, not three (3).  Compose -./-- do not insert
anything.  To me, this is just a point of education as I don't use dash m/n in
my writing.  Just trying to learn a bit.

Thanks for any further explanation. 

Tom

After some trial and error I find that three key combinations work in some
applications but not in others.  They do work in LO but not when immediately
adjacent.  Thanks for your help.

Tom

-- 
Tom Taylor - retired penguin
openSUSE 12.1x86_64 openSUSE 12.2x86_64
KDE 4.6.00, FF 7.0  KDE 4.7.2, FF 11.0
claws-mail 3.8.0
registered linux user 263467
linxt-At-comcast-DoT-net

-- 
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: Calc function

2012-04-18 Thread Andreas Säger

Am 18.04.2012 17:56, Johnny Rosenberg wrote:

Den 18 april 2012 09:47 skrev Andreas Sägerville...@t-online.de:

Am 17.04.2012 19:35, Mike Phelan wrote:


I am trying to automatically remove a number from a range of cells, if it
appears in a different range.

I am creating a spreadsheet where once a number appears in B4:G11 4 times,
it
changes color to Red...got that part.

Then I want to manually enter that number somewhere into J4:N21. once
entered
into J4:N21, i want that number to erase from B4:G11.



=IF(COUNTIF(B4;$J$4:$N$21);;B4)
copy down 7 rows and 5 columns to the right.
Copy the resulting range and paste over B4:G11


ideally at that point i would also like all remaining numbers in B4:G11 to
shift up, leaving no empty cells above cells with values in them (keeping
them
in the order entered within columns).


Sort each of the 6 columns manually.


--
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: beware of the m$ subsidiary

2012-04-18 Thread Tom Davies
Hi :)
Before Linux most of those servers would probably have been using Unix.  A fair 
percentage moved from Unix to Bsd too.  There are apparently other unix-based 
OSes out there and a few other odd ones that form almost all the remaining 
percentage.  
Regards from
Tom :)


--- On Wed, 18/4/12, Ken Springer snowsh...@q.com wrote:

From: Ken Springer snowsh...@q.com
Subject: [libreoffice-users] Re: beware of the m$ subsidiary
To: users@global.libreoffice.org
Date: Wednesday, 18 April, 2012, 18:48

On 4/18/12 10:05 AM, Tom Davies wrote:
 Interestingly apparently many US government agencies and departments use 
 GnuLinux for most
 of their server-side and infra-structure but had to cave into users demands 
 for MS on their desktops.

MS has always been the choice for the OS in almost all cases, AFAIK, but the 
actual programs used varied widely years ago.  My agency generally preferred 
Word Perfect as the word processor, but when (I think) a government wide survey 
was taken as to an across the board single word processing program to aid 
document sharing, WP lost out to Word.  Lots of unhappy people in my agency who 
had to redo all their macros, templates, etc.

That surprises me not as far as the servers go.  It seems the general 
impression of US Fed employees is they are, in general, not terribly bright in 
a lot of areas, where my experience is just the opposite. Especially the tech 
guys.  They are well aware of the advantages of Linux.

The agency I worked for didn't use Linux on any servers, AFAIK.  Not because 
they may not have wanted to, but the support load the tech people had to 
provide so far exceeded their abilities to do a good job, they were always 
making decisions in a direction of having everything the same, to at least try 
to give everyone the help they needed.

The problem, despite the big government hoopla, is there's just not enough 
human beings to do the job well for the tasks assigned.  (Not going into the 
question of efficient operations, etc, as much of that is caused by people 
outside individual agencies, not the average employee.)

The average employee is prevented, intentionally, from having anything more to 
do with the servers other than using them to store their data on.  I was a 
supervisor, and I was at my last unit for 5 years before I even knew I could do 
that.  No one bothered to tell me I actually had access to the server's hard 
drives for file storage.  Our unit didn't even have a dedicated IT position, it 
fell to the administrative officer (total department personnel size of 1) as 
one of many collaborative duties, and when he passed away, it was given to me 
as a similar collaborative duty.  I was Chief of Maintenance (total dept. size 
of 3), as well as Environmental officer, Safety Officer, Fleet Manager, and I 
don't remember what else.


-- Ken

Mac OS X 10.6.8
Firefox 11.0
Thunderbird 11.0.1
LibreOffice 3.5.1.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



Re: [libreoffice-users] select en-dash and em-dash characters

2012-04-18 Thread Doug

On 04/18/2012 12:19 PM, Johnny Rosenberg wrote:

Den 18 april 2012 02:12 skrev Thomas Taylorli...@comcast.net:

On Tue, 17 Apr 2012 10:48:22 +0100
Séamas Ó Brógáins...@iol.ie  wrote:


Doug:

Using the compose key, the default settings are:

dash (em rule)  ---
en rule:--.







How do you do that if your system (openSuSE 12.1) only allows two (2) key
composition?

Thanks, Tom

I have had OpenSUSE some years back (I think it was 11.3 or
something), but unfortunately I didn't test this…
However, this page doesn't say anything about that the compose key
behaviour is depending on your GNU/Linux-distribution, so I thought
this was true for all of them.
Maybe it's a Gnome thing and you have the KDE version of OpenSUSE?
Well, I don't think so, but I use Gnome only, so I don't know.


Best regards

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


Using PCLinuxOS with KDE and the 3-key thing works fine here.
If you're testing it, you may need to go to a program that uses
a variable width font, like Times-Roman.  (I tired it in LO.)

--doug


--
Blessed are the peacekeepers...for they shall be shot at from both sides. 
--A.M. Greeley


--
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: beware of the m$ subsidiary

2012-04-18 Thread Ken Springer

On 4/18/12 12:20 PM, Tom Davies wrote:

Before Linux most of those servers would probably have been using Unix.  A fair 
percentage moved from
Unix to Bsd too.  There are apparently other unix-based OSes out there 
and a few other odd ones that

form almost all the remaining percentage.

That could be, that timeframe was long before I was that knowledgeable 
about computers.


The fed gov department I worked for used MS's server program.  This 
department had mostly small units scattered across the country, and a 
few overseas.  It would be plausible, that when the IT guys in Timbuktu 
needed onsite help with a local server, the familiar desktop interface 
simply made it easier to get the job done.


Or, it was part of an overarching negotiating agreement on the purchase 
price of X number of copies of Windows.


Or, a bit of both!   LOL

--
Ken

Mac OS X 10.6.8
Firefox 11.0
Thunderbird 11.0.1
LibreOffice 3.5.1.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] select en-dash and em-dash characters

2012-04-18 Thread Doug

On 04/18/2012 01:30 PM, Thomas Taylor wrote:

On Wed, 18 Apr 2012 18:10:18 +0200
Johnny Rosenberggurus.knu...@gmail.com  wrote:


Den 17 april 2012 22:32 skrev Thomas Taylorli...@comcast.net:

On Tue, 17 Apr 2012 18:09:31 +0200
Johnny Rosenberggurus.knu...@gmail.com  wrote:


Den 16 april 2012 22:36 skrev Séamas Ó Brógáins...@iol.ie:

Regina wrote:


They are usually written via AutoCorrect. The simple hyphen is replaced
with the en-dash or em-dash when the following word is finished . . .

That is _not_ a good idea. The hyphen, en rule and em rule (dash) are
distinct characters with distinct uses in conventional typography and
typesetting. Their correct use cannot be predicted by context, nor are
they interchangeable.

You need to find out where these characters are in the character set you
are using. This depends on your operating system, your language, and
your keyboard layout.

As Johnny pointed out, they can be entered with the compose key. If you
use them so often that even this is too cumbersome you can customise
your keyboard layout,

That's actually what I did (called ”Sweden Johnny Rosenberg”,
available on my computers only…), but I didn't mention it because I
thought it could be a bit tricky…
I have the en-dash at AltGr+- and the em-dash at AltGr+Shift+-. I also
did a lot of other modification, like removed all my numbers from the
first row (I already have them on the num pad to the right – why have
them at more than one place?) and moved some Shift+number combinations
so I don't need Shift for characters like ”!#%/” and so on. I even
made labels to put on my keys, but most of them was worn out after a
couple of weeks of typing…

To change the layout (or rather add a new one in this case), you need
to fiddle with three files (at least in Ubuntu):
/usr/share/X11/xkb/rules/evdev.lst, /usr/share/X11/xkb/rules/evdev.xml
and /usr/share/X11/xkb/symbols/the file representing your language,
more on that another time…

Ok, this was a bit off topic…


Kind regards

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


so that (for example) compose-hyphen gets you the
en rule and shift-compose-hyphen gets you the dash (em rule). If you
want to do this I will help you (but only if you use GNU/Linux!).

You could, as Johnny suggests, create your own auto-correct sequences,
but personally I would avoid all such contrivances. Auto-correct is
_not_ your friend.







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

Hi Johnny;
Out of curiosity, what is AltGr+ ? Alt is of course the Alt key on the
keyboard but which key is Gr?  My keyboard (an old IBM windows model)
doesn't have such a key.

Thanks, Tom

I saw that someone already answered, but I'll reply anyway.
The ”+” does only mean that the key is hold. So Alt+Shift+x means that
Alt, Shift and x is pressed simultaneously, or at least that no key is
released before the other keys is pressed.
The compose key doesn't work that way, therefore no ”+” sign: ”Compose
--.” means ”hit the Compose key, release it, then type --.”.

  snip

Hi Johnny ;)
The problem with the above is that in openSuSE  the compose key only allows two
(2) keystroke combinations, not three (3).  Compose -./-- do not insert
anything.  To me, this is just a point of education as I don't use dash m/n in
my writing.  Just trying to learn a bit.

Thanks for any further explanation.

Tom


I should think that a bug report to OpenSuse is in order!
--doug

--
Blessed are the peacekeepers...for they shall be shot at from both sides. 
--A.M. Greeley


--
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] select en-dash and em-dash characters

2012-04-18 Thread Tom Davies
Hi :)
It is quite possible that openSuSE don't allow 3 character sequences.  They are 
one of the longest running distros that are still active and they tend to go 
their own way.  I get the impression they aim slightly more at corporate users 
and offer better traditional forms of tech-support which Canonical are also 
trying to add on as options in their support.  Apparently openSuSE contribute 
something like 25% of LO coding work!  A fantastic and much appreciated 
organisation :)))
Regards from
Tom :)



--- On Wed, 18/4/12, Doug dmcgarr...@optonline.net wrote:

From: Doug dmcgarr...@optonline.net
Subject: Re: [libreoffice-users] select en-dash and em-dash characters
To: users@global.libreoffice.org
Date: Wednesday, 18 April, 2012, 19:38

On 04/18/2012 01:30 PM, Thomas Taylor wrote:
 On Wed, 18 Apr 2012 18:10:18 +0200
 Johnny Rosenberggurus.knu...@gmail.com  wrote:

 Den 17 april 2012 22:32 skrev Thomas Taylorli...@comcast.net:
 On Tue, 17 Apr 2012 18:09:31 +0200
 Johnny Rosenberggurus.knu...@gmail.com  wrote:

 Den 16 april 2012 22:36 skrev Séamas Ó Brógáins...@iol.ie:
 Regina wrote:

 They are usually written via AutoCorrect. The simple hyphen is replaced
 with the en-dash or em-dash when the following word is finished . . .
 That is _not_ a good idea. The hyphen, en rule and em rule (dash) are
 distinct characters with distinct uses in conventional typography and
 typesetting. Their correct use cannot be predicted by context, nor are
 they interchangeable.

 You need to find out where these characters are in the character set you
 are using. This depends on your operating system, your language, and
 your keyboard layout.

 As Johnny pointed out, they can be entered with the compose key. If you
 use them so often that even this is too cumbersome you can customise
 your keyboard layout,
 That's actually what I did (called ”Sweden Johnny Rosenberg”,
 available on my computers only…), but I didn't mention it because I
 thought it could be a bit tricky…
 I have the en-dash at AltGr+- and the em-dash at AltGr+Shift+-. I also
 did a lot of other modification, like removed all my numbers from the
 first row (I already have them on the num pad to the right – why have
 them at more than one place?) and moved some Shift+number combinations
 so I don't need Shift for characters like ”!#%/” and so on. I even
 made labels to put on my keys, but most of them was worn out after a
 couple of weeks of typing…

 To change the layout (or rather add a new one in this case), you need
 to fiddle with three files (at least in Ubuntu):
 /usr/share/X11/xkb/rules/evdev.lst, /usr/share/X11/xkb/rules/evdev.xml
 and /usr/share/X11/xkb/symbols/the file representing your language,
 more on that another time…

 Ok, this was a bit off topic…


 Kind regards

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

 so that (for example) compose-hyphen gets you the
 en rule and shift-compose-hyphen gets you the dash (em rule). If you
 want to do this I will help you (but only if you use GNU/Linux!).

 You could, as Johnny suggests, create your own auto-correct sequences,
 but personally I would avoid all such contrivances. Auto-correct is
 _not_ your friend.







 --
 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
 Hi Johnny;
 Out of curiosity, what is AltGr+ ? Alt is of course the Alt key on the
 keyboard but which key is Gr?  My keyboard (an old IBM windows model)
 doesn't have such a key.

 Thanks, Tom
 I saw that someone already answered, but I'll reply anyway.
 The ”+” does only mean that the key is hold. So Alt+Shift+x means that
 Alt, Shift and x is pressed simultaneously, or at least that no key is
 released before the other keys is pressed.
 The compose key doesn't work that way, therefore no ”+” sign: ”Compose
 --.” means ”hit the Compose key, release it, then type --.”.
   snip

 Hi Johnny ;)
 The problem with the above is that in openSuSE  the compose key only allows 
 two
 (2) keystroke combinations, not three (3).  Compose -./-- do not insert
 anything.  To me, this is just a point of education as I don't use dash m/n in
 my writing.  Just trying to learn a bit.

 Thanks for any further explanation.

 Tom

I should think that a bug report to OpenSuse is in order!
--doug

-- 
Blessed are the peacekeepers...for they shall be shot at from both sides. 
--A.M. Greeley


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

[libreoffice-users] Trouble opening ODS file in LibreOffice

2012-04-18 Thread dstubbs
Hi, I have an ODS file that I am not able to open.  It is a spreadsheet
file that I have been using daily since the first of the year.  I have
opened it and updated it every day since the first of January. Yesterday
when I tried to open it, Libreoffice opened properly; then I got a Filter
Selection dialog box.  Whatever filter I select, the file will not open.
I am able to open other ODS files.  Any ideas why this file fails to open?

Dick


-- 
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] Sum across sheets

2012-04-18 Thread Steve Edmonds

Hi.
Is it possible to SUM across sheets without having to name each sheet.
i.e. something like SUM(Sheet5.E4:Sheet9.E4) instead of
SUM(Sheet5.E4,Sheet6.E4,Sheet7.E4,Sheet8.E4,Sheet9.E4)

My sheets are named Bill, Bob, Tom Dick and Harry.
Bill is Sheet5 SUM(Sheet5.E4:Sheet9.E4) doesn't work.
SUM(Bill.E4:Harry.E4) doesn't work.
SUM(Bill.E4,Bob.E4,Tom.E4,Dick.E4,Harry.E4) does work.

Thanks,
Steve


--
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] Sum across sheets

2012-04-18 Thread Regina Henschel

Hi Steve,

Steve Edmonds schrieb:

Hi.
Is it possible to SUM across sheets without having to name each sheet.
i.e. something like SUM(Sheet5.E4:Sheet9.E4) instead of
SUM(Sheet5.E4,Sheet6.E4,Sheet7.E4,Sheet8.E4,Sheet9.E4)

My sheets are named Bill, Bob, Tom Dick and Harry.
Bill is Sheet5 SUM(Sheet5.E4:Sheet9.E4) doesn't work.
SUM(Bill.E4:Harry.E4) doesn't work.
SUM(Bill.E4,Bob.E4,Tom.E4,Dick.E4,Harry.E4) does work.


It should be possible and works for me with LO 3.5.2.2 on WinXP.

What is your version and OS?

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



Re: [libreoffice-users] Sum across sheets

2012-04-18 Thread T. R. Valentine
On 18 April 2012 16:57, Steve Edmonds steve.edmo...@ptglobal.com wrote:

 Is it possible to SUM across sheets without having to name each sheet.
 i.e. something like SUM(Sheet5.E4:Sheet9.E4) instead of
 SUM(Sheet5.E4,Sheet6.E4,Sheet7.E4,Sheet8.E4,Sheet9.E4)

Example: =SUM(Sheet1.A1:Sheet2.C6) -- will total everything in Sheet1
and Sheet2 in cells A1 through C6. It will not include a value in,
e.g., Sheet1.D1.


 My sheets are named Bill, Bob, Tom Dick and Harry.
 Bill is Sheet5 SUM(Sheet5.E4:Sheet9.E4) doesn't work.
 SUM(Bill.E4:Harry.E4) doesn't work.
 SUM(Bill.E4,Bob.E4,Tom.E4,Dick.E4,Harry.E4) does work.

Once you rename a sheet, you have to use the sheet's name. If you
create the formula before renaming a sheet, the formula will be
changed.

If the first sheet is Bill and the last sheet is Harry and you want to
add values in cell E4 of each sheet: =SUM(Bill.E4:Harry.E4)



-- 
T. R. Valentine
Your friends will argue with you. Your enemies don't care.
'When I get a little money I buy books; and if any is left I buy food
and clothes.' -- Erasmus

-- 
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: Trouble opening ODS file in LibreOffice

2012-04-18 Thread Tom
Hi :)
Can you upload the ods to Nabble so that we can have a look?  Note that this
is a public access list so don't upload it if it's confidential.  Just
follow the links to Nabble and reply to one of the posts in the right thread
and then click on the More button.  Upload is the 1st option and puts a
link into the body of the message.
Regards from
Tom :)

--
View this message in context: 
http://nabble.documentfoundation.org/Trouble-opening-ODS-file-in-LibreOffice-tp3921408p3921571.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] Sum across sheets

2012-04-18 Thread Steve Edmonds



On 2012-04-19 10:09, T. R. Valentine wrote:

On 18 April 2012 16:57, Steve Edmondssteve.edmo...@ptglobal.com  wrote:


Is it possible to SUM across sheets without having to name each sheet.
i.e. something like SUM(Sheet5.E4:Sheet9.E4) instead of
SUM(Sheet5.E4,Sheet6.E4,Sheet7.E4,Sheet8.E4,Sheet9.E4)

Example: =SUM(Sheet1.A1:Sheet2.C6) -- will total everything in Sheet1
and Sheet2 in cells A1 through C6. It will not include a value in,
e.g., Sheet1.D1.



My sheets are named Bill, Bob, Tom Dick and Harry.
Bill is Sheet5 SUM(Sheet5.E4:Sheet9.E4) doesn't work.
SUM(Bill.E4:Harry.E4) doesn't work.
SUM(Bill.E4,Bob.E4,Tom.E4,Dick.E4,Harry.E4) does work.

Once you rename a sheet, you have to use the sheet's name. If you
create the formula before renaming a sheet, the formula will be
changed.

If the first sheet is Bill and the last sheet is Harry and you want to
add values in cell E4 of each sheet: =SUM(Bill.E4:Harry.E4)


Thanks TR and to Regina.
I could not get this to work this morning at home (#Ref errors), but it 
does here at work (I just fetched the sheet off my home PC). The sheet 
is a few years old so probably originated in OOO but the OS and LO 
versions at work and home should be the same. I will check, it is 
working now so that is what is important.

Cheers, Steve

--
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: Trouble opening ODS file in LibreOffice

2012-04-18 Thread trickydicky
unable to open this file


http://nabble.documentfoundation.org/file/n3921824/2012_taxes.ods
2012_taxes.ods 

--
View this message in context: 
http://nabble.documentfoundation.org/Trouble-opening-ODS-file-in-LibreOffice-tp3921408p3921824.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: Trouble opening ODS file in LibreOffice

2012-04-18 Thread Steve Edmonds

I get 1.5 kB and empty.
steve

On 2012-04-19 12:46, trickydicky wrote:

unable to open this file


http://nabble.documentfoundation.org/file/n3921824/2012_taxes.ods
2012_taxes.ods

--
View this message in context: 
http://nabble.documentfoundation.org/Trouble-opening-ODS-file-in-LibreOffice-tp3921408p3921824.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