date:20120417

HI :)
There are no updates (well, mostly).  There are only upgrades.  

The menu item is a remnant from when OpenOffice.org used to have lengthy delays 
between releases and ignored most bug-fixes put forwards by the community.  
It's vaguely possible that
1.  development might slow down a bit at some point in the future and
2.  one release or branch might be treated as a longer-term prospect with 
bug-fixes and sundry stuff back-ported to it

At the moment people are being encouraged to keep installing newer and newer 
releases and to find easy ways of doing that with the least disruption possible 
OR to take note that security is almost never the reason for upgrades so if 
your version of LibreOffice does everything you need then you can probably 
stick with it for 6months or a year before upgrading.  

Regards from
Tom :)


--- On Fri, 13/4/12, goutasof gouta...@filzmail.com wrote:

From: goutasof gouta...@filzmail.com
Subject: [libreoffice-users] Mac OS X 10.4 Check Updates Bug
To: users@global.libreoffice.org
Date: Friday, 13 April, 2012, 10:53

Have others seen this problem?  LibreOffice 3.5.1.x menu item, Help / Check for
Updates..., failed to report 3.5.2.x release of 5 Apr 2012.  I did download and
install by hand.  Is update check only for major.minor, not bugfix numbers?



-- 
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] (Win7/LibO-Calc) Bug in tool Multiple operations? Issue SOLVED!

2012-04-17 Thread Pertti Rönnberg


Regina,
Thank you for your kind interest and for your help: your questions 
forced me to study my problem once again.
Obviously I am getting old -- I had done some bad thinking and caused 
circular references.


To other readers I want to recommend that tool Multiple operations in 
LibO-Calc/Data.


I have a feeling that people does not know about it, as you said, it is 
sort of hidden and forgotten. This is a shame because it really is very 
handy for simulating or studying changes by using 1-2 variables.
E.g. estimating how the monthly payments of a loan changes with rate and 
loan length (time) as variables.

It is easy and rather straight forward to use after a little training.
Best regards
Pertti Rönnberg


To others

On 16.4.2012 23:35, Regina Henschel wrote:

Hi Pertti,

Pertti Rönnberg schrieb:

Hello, LibO folks,

In LibO-Calc there is a very interesting and useful tool Data/Multiple
operations -- at least as useful as Pivot Table.


Yes, it is hidden and cannot be written with the function wizard. But 
it is possible to write the function manually, you do not need Data  
Multiple.Operations.




When I recently updated an old calculation process created some 3-4
years ago in OpenO and recreated it in LibO-3.4.5, I noticed that one of
the tool's flexible features had vanished.

In the 'new' Calc the first cells of both row input cell E5 (of E5,
F5, G5,..etc.) and column input cell D6 (of D6, D7, D8, ..etc.)
require a manually inserted absolute value -- the next values
(increasing or decreasing by a difference) can be formulas calculating
from the value before.


Please provide a small reduced spreadsheet document. It should contain 
nothing more than those things needed to trigger the error.


Please post the content of a cell with the generated 
Multiple.Operations formula and please post the content of the formula 
cell, which will be the first parameter in the Multiple.Operations.




In the old calculation these first cells (E5 and D6) could refer to
formulas ina remote cells which increases the flexibility and the
usability of the tool remarkably.


What is a remote cell. Do you try to use a cell from a different 
spreadsheet document?


I have not found a regression. But I have difficulties to understand 
your explanation and therefore might miss something.


Kind regards
Regina




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

[libreoffice-users] Re: Problems importing an OO database into LO

2012-04-17 Thread ptoye


NoOp wrote
 
 On 04/15/2012 08:58 AM, David wrote:
 ...
 
 What database doe you think works better than OpenOffice or LibreOffice?
 
 
 
 Pick.
 

I don't have any views on this matter. 

I vaguely remember that Lotus Approach allowed far more flexibility in
allowing updates to multiple tables, but that was a long time ago and is no
longer available (AFAIK).

Access allows update queries, which are sadly missing from LO/OO.

-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3916631.html
Sent from the Users mailing list archive at Nabble.com.

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

[libreoffice-users] Re: Problems importing an OO database into LO


Am 17.04.2012 10:52, ptoye wrote:


Access allows update queries, which are sadly missing from LO/OO.



Why can't you run SQL update queries? This is trivial to do in SQL. The 
SQL is trivial to execute by macro.
If you desparately want a graphical query designer for 
update/insert/delete queries, then you should write one and store your 
queries somewhere in the .odb container.



--
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-17 Thread Ian Whitfield


 On 04/15/2012 08:58 AM, David wrote:  ...
  
  What database doe you think works better than OpenOffice or LibreOffice?
  

I don't have any views on this matter.
After using OO/LO Base for over 5 years now I gave up last month after 
the latest crash. It has been an ongoing battle to keep my DB 
operational and I was really fed-up with all the crashes, loss of data 
and time spent fixing the DB etc etc over the years.


I'm NOT running a fancy DB here - just a Membership List with about 2500 
records, each record with three photos and approx 70 fields. A bunch of 
Queries and a few Reports so it's not exactly Rocket Science!!


I came to the very sad conclusion, (after my last crash when Base 
managed to randomly drop about a quarter of my Data (not complete 
records but fields in the records), and scramble about another 
third!!! AND it would no longer even run my 'User Form'!!), that 
Base is NOT fit for purpose. This is MY opinion - and I think 5 years is 
a long enough time to get a good feel for it - but no doubt I will get 
flamed for this comment.


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


I'm NOT missing Base!!

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

[libreoffice-users] Re: Problems importing an OO database into LO

2012-04-17 Thread ptoye


Andreas Säger wrote
 
 Why can't you run SQL update queries? This is trivial to do in SQL. The 
 SQL is trivial to execute by macro.
 If you desparately want a graphical query designer for 
 update/insert/delete queries, then you should write one and store your 
 queries somewhere in the .odb container.
 
 
Of course I can. If I can find out how to do it. 

But this isn't the point, is it? The real point is that database front-ends
and macro languages are meant to make life easy, not difficult. You seem to
dislike sugar - worried about your diameter? The computer was made for
man, not man for the computer. Why not program in assembler - gives you much
more control and isn't really that hard (I speak from years of assembler
experience and with my tongue firmly in my cheek)?

-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3916735.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] Mac OS X 10.4 Check Updates Bug

2012-04-17 Thread Manfred J. Krause

Hi,

On Fri, Apr 13, 2012 at 11:53 AM, goutasof wrote:

 Have others seen this problem?  LibreOffice 3.5.1.x menu item, Help / Check 
 for
 Updates..., failed to report 3.5.2.x release of 5 Apr 2012.  I did download 
 and
 install by hand.  Is update check only for major.minor, not bugfix numbers?


No--that works for me (on WinXP).

But the final result is pretty much the same (download manually).
→ http://dl.dropbox.com/u/19264180/LibO/check_for_updates_351.png

The automatic download of the update is currently not available.

mjk

-- 
The Document Foundation announces LibreOffice 3.5.2
http://nabble.documentfoundation.org/The-Document-Foundation-announces-LibreOffice-3-5-2-tc3886925.html

-- 
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-17 Thread Séamas Ó Brógáin

Doug:

Using the compose key, the default settings are:

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






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

off-list Re: [libreoffice-users] Re: Problems importing an OO database into LO

Hi :)
I guess you tried using various external back-ends?  Did you consider using one 
of the back-ends without having Base as the front-end?

People have already suggested that Kexi is not even as 'advanced' as Base but 
that was about a year ago so it's quite possible they were wrong or that things 
have changed.  It's good to have something i can recommend to people that are 
unhappy with Base because Base is clearly not ready and doesn't have enough 
devs working on it.  
Regards from
Tom :)


--- On Tue, 17/4/12, Ian Whitfield whitfi...@telkomsa.net wrote:

From: Ian Whitfield whitfi...@telkomsa.net
Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO
To: users@global.libreoffice.org
Date: Tuesday, 17 April, 2012, 10:28

  On 04/15/2012 08:58 AM, David wrote:  ...
     What database doe you think works better than OpenOffice or 
 LibreOffice?
   
 I don't have any views on this matter.
After using OO/LO Base for over 5 years now I gave up last month after the 
latest crash. It has been an ongoing battle to keep my DB operational and I 
was really fed-up with all the crashes, loss of data and time spent fixing the 
DB etc etc over the years.

I'm NOT running a fancy DB here - just a Membership List with about 2500 
records, each record with three photos and approx 70 fields. A bunch of Queries 
and a few Reports so it's not exactly Rocket Science!!

I came to the very sad conclusion, (after my last crash when Base managed to 
randomly drop about a quarter of my Data (not complete records but fields in 
the records), and scramble about another third!!! AND it would no longer 
even run my 'User Form'!!), that Base is NOT fit for purpose. This is MY 
opinion - and I think 5 years is a long enough time to get a good feel for it 
- but no doubt I will get flamed for this comment.

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

I'm NOT missing Base!!

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


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

Hi :)
Dohhh, that last post was meant to be off-list!!
Regards from
Tom :)

--- On Tue, 17/4/12, Ian Whitfield whitfi...@telkomsa.net wrote:

From: Ian Whitfield whitfi...@telkomsa.net
Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO
To: users@global.libreoffice.org
Date: Tuesday, 17 April, 2012, 10:28

  On 04/15/2012 08:58 AM, David wrote:  ...
     What database doe you think works better than OpenOffice or 
 LibreOffice?

 I don't have any views on this matter.
After using OO/LO Base for over 5 years now I gave up last month after the 
latest crash. It has been an ongoing battle to keep my DB operational and I 
was really fed-up with all the crashes, loss of data and time spent fixing the 
DB etc etc over the years.

I'm NOT running a fancy DB here - just a Membership List with about 2500 
records, each record with three photos and approx 70 fields. A bunch of Queries 
and a few Reports so it's not exactly Rocket Science!!

I came to the very sad conclusion, (after my last crash when Base managed to 
randomly drop about a quarter of my Data (not complete records but fields in 
the records), and scramble about another third!!! AND it would no longer 
even run my 'User Form'!!), that Base is NOT fit for purpose. This is MY 
opinion - and I think 5 years is a long enough time to get a good feel for it 
- but no doubt I will get flamed for this comment.

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

I'm NOT missing Base!!

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

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

2012-04-17 Thread e-letter

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] Re: disappearing letter

2012-04-17 Thread e-letter

On 16/04/2012, NoOp gl...@sbcglobal.net wrote:

 You keep promoting earlier versions of Java, I guess you've not heard
 what happened to Apple for not updating their Java versions:


Off-topic, but why don't people using ibm java and openjdk more?

-- 
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] How to download?



Download FireFox.
It works better than Chrome, in my opinion, for Windows and Linux.



On 04/13/2012 08:38 AM, Darren Govoni wrote:
Yeah. I will try another browser and wired machine, but its a weird 
occurrence still. Been trying to download it for 3 days so far! No 
problems downloading other stuff.


brbrbr--- Original Message ---
On 4/13/2012  06:56 AM Tom Davies wrote:brHi :)
brSounds like it 'should' be downloading fine.  Do you already have 
a 2nd web-browser you can try?  Not that it's likely to make any 
difference.  I think trying the wired machine is smart and covers the 
issue of weird settings in your Chrome (which is unlikely anyway).

brRegards from
brTom :)
br
br
br--- On Fri, 13/4/12, Darren Govoni dar...@ontrenet.com wrote:
br
brFrom: Darren Govoni dar...@ontrenet.com
brSubject: Re: [libreoffice-users] How to download?
brTo: users@global.libreoffice.org
brDate: Friday, 13 April, 2012, 11:15
br
brOn Fri, 2012-04-13 at 08:20 +0100, Tom Davies wrote:
br Hi :)
br Have you made sure there is enough empty space in the folder you 
are downloading to? brYes.

br
br Which country are you in? brUS
br
br Do you have a download limit/month and have you gone over that? 
brNo

br
br Are you using a wireless connection or is there a network cable 
plugged into the machine? brWireless

br
br Have you tried rebooting your router? brYes
br
br Are you using Adblock Plus or some parental thing and 
accidentally blocked things from this site?

brNo
br
brI will try a wget from a wired computer and see, but what should 
be a 8

brminute download never happens. It gets to about 15MB/200MB or so and
brgets interrupted on the server side. br
brI'm using Google Chrome.
br
br Regards from
br Tom :)
br br br --- On Fri, 13/4/12, Jay Lozier jsloz...@gmail.com 
wrote:

br br From: Jay Lozier jsloz...@gmail.com
br Subject: Re: [libreoffice-users] How to download?
br To: users@global.libreoffice.org
br Date: Friday, 13 April, 2012, 5:37
br br On 04/12/2012 09:14 PM, Darren Govoni wrote:
br  Hi,
br I've been trying to download the latest LibreOffice. No luck.
br  It gets about 5%. Its slow then gets interrupted and stops. The
br  torrent does not work. It stays at 0%. Never seen this from a 
download

br  site before.
br 
br  Is there a mirror list?
br 
br  I tested my connection speed. Its fast.
br 
br  thanks.
br 
br 
br What OS and browser are you using?
br br -- br Jay Lozier
br jsloz...@gmail.com
br br br -- br For unsubscribe instructions e-mail to: 
users+h...@global.libreoffice.org
br Problems? 
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
br Posting guidelines + more: 
http://wiki.documentfoundation.org/Netiquette

br List archive: http://listarchives.libreoffice.org/global/users/
br All messages sent to this list will be publicly archived and 
cannot be deleted

br br br
br
br
br-- brFor unsubscribe instructions e-mail to: 
users+h...@global.libreoffice.org
brProblems? 
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
brPosting guidelines + more: 
http://wiki.documentfoundation.org/Netiquette

brList archive: http://listarchives.libreoffice.org/global/users/
brAll messages sent to this list will be publicly archived and 
cannot be deleted

br
br-- brFor unsubscribe instructions e-mail to: 
users+h...@global.libreoffice.org
brProblems? 
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
brPosting guidelines + more: 
http://wiki.documentfoundation.org/Netiquette

brList archive: http://listarchives.libreoffice.org/global/users/
brAll messages sent to this list will be publicly archived and 
cannot be deleted

br
br




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


Am 17.04.2012 11:34, ptoye wrote:


Andreas Säger wrote


Why can't you run SQL update queries? This is trivial to do in SQL. The
SQL is trivial to execute by macro.
If you desparately want a graphical query designer for
update/insert/delete queries, then you should write one and store your
queries somewhere in the .odb container.



Of course I can. If I can find out how to do it.

But this isn't the point, is it? The real point is that database front-ends
and macro languages are meant to make life easy, not difficult. You seem to
dislike sugar - worried about your diameter? The computer was made for
man, not man for the computer. Why not program in assembler - gives you much
more control and isn't really that hard (I speak from years of assembler
experience and with my tongue firmly in my cheek)?

-


You get what you pay for. The rest is about community. Unfortunately, 
this office suite has more consumers and complainers than contributors.
Regarding your remark on assembler code: A very high software stack 
imposes a new quality of problems that would be unknown on hardware level.


Fortunately, there is still the OpenOffice.org community:

http://extensions.services.openoffice.org/en/project/access2base
(which could be even more useful if someone would rewrite these Basic 
routines as a true extension of UNO-components)



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


Am 17.04.2012 11:28, Ian Whitfield wrote:

On 04/15/2012 08:58 AM, David wrote:  ...

  What database doe you think works better than OpenOffice or
LibreOffice?


I don't have any views on this matter.

After using OO/LO Base for over 5 years now I gave up last month after
the latest crash. It has been an ongoing battle to keep my DB
operational and I was really fed-up with all the crashes, loss of data
and time spent fixing the DB etc etc over the years.



Beware of the troll!


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

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.

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.

On 04/17/2012 07: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

Hi :)
To quote Battlestar Galactica All this has happened before and will happen 
again.  

Other companies have also tried opening OpenSource departments or sections that 
work on allegedly OpenSource projects with varying success.  Quality of the 
licenses is checked by various people and organisations.  The Linux 
Foundation and the Free Software Foundation are good.  If the licenses allow 
people to check the code then the code gets checked too.  If the licenses don't 
allow people to explore the code then it's not OpenSource anyway.  MS's kernel 
contributions apparently got cleaned up by non-MS people because MS wouldn't 
clean up the code themsleves.  NVidia's hybrid, partly OpenSource drivers led 
to big improvements in the properly OpenSource drivers and now NVidia cards 
seem to be better than Ati in GnuLinux even tho many of us would prefer to get 
Ati cards.  

Most of us do have to continue to support MS formats but that doesn't mean we 
have to use them exclusively.  

Have you ever worked in an office and found a bunch of people all smoke 
together or chip off down the pub together and become an unofficial clique that 
work together better and support each other more than the rest of the office?  
That sort of thing is beginning to happen with ODF users.    

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] beware of the m$ subsidiary
To: users@global.libreoffice.org
Date: Tuesday, 17 April, 2012, 13:01


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.

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.

On 04/17/2012 07: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-17 Thread Simon Cropper


On 17/04/12 23:16, Tom Davies wrote:

Hi :)
To quote Battlestar Galactica All this has happened before and will happen 
again.

Other companies have also tried opening OpenSource departments or sections that work on allegedly 
OpenSource projects with varying success.  Quality of the licenses is checked by various people and 
organisations.  The Linux Foundation and the Free Software Foundation are good. 
 If the licenses allow people to check the code then the code gets checked too.  If the licenses don't 
allow people to explore the code then it's not OpenSource anyway.  MS's kernel contributions apparently 
got cleaned up by non-MS people because MS wouldn't clean up the code themsleves.  NVidia's hybrid, 
partly OpenSource drivers led to big improvements in the properly OpenSource drivers and now NVidia 
cards seem to be better than Ati in GnuLinux even tho many of us would prefer to get Ati cards.

Most of us do have to continue to support MS formats but that doesn't mean we 
have to use them exclusively.

Have you ever worked in an office and found a bunch of people all smoke 
together or chip off down the pub together and become an unofficial clique that 
work together better and support each other more than the rest of the office?  
That sort of thing is beginning to happen with ODF users.

Regards from
Tom :)


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

From: webmaster-Kracked_P_Pwebmas...@krackedpress.com
Subject: Re: [libreoffice-users] beware of the m$ subsidiary
To: users@global.libreoffice.org
Date: Tuesday, 17 April, 2012, 13:01


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.

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.

On 04/17/2012 07: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.







Which pub? ;)

--
Cheers Simon

   Simon Cropper - Open Content Creator / Website Administrator

   Free and Open Source Software Workflow Guides
   
   Introduction   http://www.fossworkflowguides.com
   GIS Packages   http://www.fossworkflowguides.com/gis
   bash / Pythonhttp://www.fossworkflowguides.com/scripting

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


On 04/17/2012 09:26 AM, Simon Cropper wrote:

On 17/04/12 23:16, Tom Davies wrote:

Hi :)
To quote Battlestar Galactica All this has happened before and will 
happen again.


Other companies have also tried opening OpenSource departments or 
sections that work on allegedly OpenSource projects with varying 
success.  Quality of the licenses is checked by various people and 
organisations.  The Linux Foundation and the Free Software 
Foundation are good.  If the licenses allow people to check the code 
then the code gets checked too.  If the licenses don't allow people 
to explore the code then it's not OpenSource anyway.  MS's kernel 
contributions apparently got cleaned up by non-MS people because MS 
wouldn't clean up the code themsleves.  NVidia's hybrid, partly 
OpenSource drivers led to big improvements in the properly OpenSource 
drivers and now NVidia cards seem to be better than Ati in GnuLinux 
even tho many of us would prefer to get Ati cards.


Most of us do have to continue to support MS formats but that doesn't 
mean we have to use them exclusively.


Have you ever worked in an office and found a bunch of people all 
smoke together or chip off down the pub together and become an 
unofficial clique that work together better and support each other 
more than the rest of the office?  That sort of thing is beginning to 
happen with ODF users.


Regards from
Tom :)


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


From: webmaster-Kracked_P_Pwebmas...@krackedpress.com
Subject: Re: [libreoffice-users] beware of the m$ subsidiary
To: users@global.libreoffice.org
Date: Tuesday, 17 April, 2012, 13:01


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.


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.


On 04/17/2012 07: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.







Which pub? ;)

It is a British type of thing to say, but it works.  But that is how 
the people got together to talk treason to get the 13 colonies out 
from under the British overlords and become the USA.  That was the 
first real social network that I know of that changed history of my 
country.


Actually it is still done in the UK [as far as I heard] and is being 
done in one form or another in the USA.  That is offline social 
networking, not online.

.



--
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: disappearing letter

Hi :)
There is currently a court-case about this between Oracle and Google.  Oracle 
appear to be claiming that code released and patented by Sun and released under 
a GPL has been copied by Google for use in Android.  The OpenJDK is not 
independent of Oracle.  

From the IBM website
http://www.ibm.com/developerworks/java/newto/
OpenJDKOpenJDK is a free and open source implementation of the Java
   programming language, available under the GPLv2 license. 
   In October 2010, IBM, previously the main corporate contributor of the 
competing Apache
   Harmony project, formed an alliance with Oracle to support OpenJDK and 
create a single, stable
   platform for Java development.So 'IBM Java' is tied to Oracle too.  

Ok, in theory being on a GPL means the code could be forked from by any other 
project or organisation but Google appear to be in hot water for doing just 
that.  

The court-case as proposed by Oracle is based on who holds certain patents and 
seems to be avoiding the issue about licenses.  I don't understand the 
ins-and-outs and haven't even read GrokLaw about it so the articles i base my 
personal opinions on could easily have got completely the wrong story and then 
i have read between the lines and arrived at something even more inaccurate.

Regards from
Tom :)


--- On Tue, 17/4/12, e-letter inp...@gmail.com wrote:

From: e-letter inp...@gmail.com
Subject: Re: [libreoffice-users] Re: disappearing letter
To: users@global.libreoffice.org
Date: Tuesday, 17 April, 2012, 12:51

On 16/04/2012, NoOp gl...@sbcglobal.net wrote:

 You keep promoting earlier versions of Java, I guess you've not heard
 what happened to Apple for not updating their Java versions:


Off-topic, but why don't people using ibm java and openjdk more?

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

Hi :)
Lqtm.  People often forget there is only really one pub but it must be massive 
and it can be difficult to get to all parts of it, particularly parts that are 
in other counties. Lqtm
Regards from
Tom :)


--- On Tue, 17/4/12, Simon Cropper simoncrop...@fossworkflowguides.com wrote:

From: Simon Cropper simoncrop...@fossworkflowguides.com
Subject: Re: [libreoffice-users] beware of the m$ subsidiary
To: users@global.libreoffice.org
Date: Tuesday, 17 April, 2012, 14:26

On 17/04/12 23:16, Tom Davies wrote:
 Hi :)
 To quote Battlestar Galactica All this has happened before and will happen 
 again.

 Other companies have also tried opening OpenSource departments or sections 
 that work on allegedly OpenSource projects with varying success.  Quality of 
 the licenses is checked by various people and organisations.  The Linux 
 Foundation and the Free Software Foundation are good.  If the licenses 
 allow people to check the code then the code gets checked too.  If the 
 licenses don't allow people to explore the code then it's not OpenSource 
 anyway.  MS's kernel contributions apparently got cleaned up by non-MS people 
 because MS wouldn't clean up the code themsleves.  NVidia's hybrid, partly 
 OpenSource drivers led to big improvements in the properly OpenSource drivers 
 and now NVidia cards seem to be better than Ati in GnuLinux even tho many of 
 us would prefer to get Ati cards.

 Most of us do have to continue to support MS formats but that doesn't mean we 
 have to use them exclusively.

 Have you ever worked in an office and found a bunch of people all smoke 
 together or chip off down the pub together and become an unofficial clique 
 that work together better and support each other more than the rest of the 
 office?  That sort of thing is beginning to happen with ODF users.

 Regards from
 Tom :)


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

 From: webmaster-Kracked_P_Pwebmas...@krackedpress.com
 Subject: Re: [libreoffice-users] beware of the m$ subsidiary
 To: users@global.libreoffice.org
 Date: Tuesday, 17 April, 2012, 13:01


 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.

 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.

 On 04/17/2012 07: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.





Which pub? ;)

-- 
Cheers Simon

    Simon Cropper - Open Content Creator / Website Administrator

    Free and Open Source Software Workflow Guides
    
    Introduction               http://www.fossworkflowguides.com
    GIS Packages           http://www.fossworkflowguides.com/gis
    bash / Python    http://www.fossworkflowguides.com/scripting

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

Hi :)
Not really a troll.  The chap has worked harder than most to try to get Base 
more widely accepted both within TDF and outside and has tried to be positive 
about it.  However it's good to hear he has found success with a different 
OpenSource program.  It's also good to hear that Kexi appears to be better than 
it was.  
Regards from
Tom :)

--- On Tue, 17/4/12, Andreas Säger ville...@t-online.de wrote:

From: Andreas Säger ville...@t-online.de
Subject: [libreoffice-users] Re: Problems importing an OO database into LO
To: users@global.libreoffice.org
Date: Tuesday, 17 April, 2012, 12:58

Am 17.04.2012 11:28, Ian Whitfield wrote:
 On 04/15/2012 08:58 AM, David wrote:  ...
   What database doe you think works better than OpenOffice or
 LibreOffice?
 
 I don't have any views on this matter.
 After using OO/LO Base for over 5 years now I gave up last month after
 the latest crash. It has been an ongoing battle to keep my DB
 operational and I was really fed-up with all the crashes, loss of data
 and time spent fixing the DB etc etc over the years.


Beware of the troll!


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

2012-04-17 Thread Pertti Rönnberg

On 17.4.2012 12:34, ptoye wrote:

Andreas Säger wrote

Why can't you run SQL update queries? This is trivial to do in SQL. The
SQL is trivial to execute by macro.
If you desparately want a graphical query designer for
update/insert/delete queries, then you should write one and store your
queries somewhere in the .odb container.

Of course I can. If I can find out how to do it.

But this isn't the point, is it? The real point is that database front-ends
and macro languages are meant to make life easy, not difficult. You seem to
dislike sugar - worried about your diameter? The computer was made for
man, not man for the computer. Why not program in assembler - gives you much
more control and isn't really that hard (I speak from years of assembler
experience and with my tongue firmly in my cheek)?

-
Peter
--
View this message in context:
http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3916735.html
Sent from the Users mailing list archive at Nabble.com.

Well said Peter!

I totally and completely agree with you and Ian Whitfield.

And thanks to Ian for the tips about Kexi – I am almost ready for
anything but LibO-Base.

Since the beginning of this year I have been trying to create a similar
member register about a boy scout organization’s senior leaders also
collecting memorable info from gone days – before these leaders are
gone. The most I got from the efforts is waste of time and frustration.

A week ago Dan Lewis kindly sent to me drafts on documentation about
creating a Base-db. It is very well written, clear, logic, easy to
follow – but it is a draft, written in 2010 for OpenO. As far as I could
see, there are nothing similar for LibO-Base yet.

Regarding LibO-Base’s situation today, very much should be helped if
that Dan’s documentation should be completed and finished and included
in the LibO’s (Base) introduction.

(When following Dan’s documentation I also noticed that in LibO-Base you
can create a form /_based on a query_/ only using the Form Wizard –
Design View allows you to create a form /_only based on a table = one
table!_/)

To the LibO-folks and developers I repeat:

Stop developing LibO-Base;go back to the latest stable version and start
to complete it and repair all discrepancies in the program and between
the program and it’s documentation!

There is so much good done in LibO-Base so why not get the rest OK? So
it at least should meet the promises in advertising.! Without problems!

And:
What (in @!?*@!??) can be the clever idea with having in LibO-base a
embedded HSQL v.1.8 that is not supported any more when the latest
version is 2.2.x? What about e.g. SQLite?

As Peter said:thus making the life easier -- and if not easier but not
more difficult!

Regards

Pertti Rönnberg

Re: [libreoffice-users] Re: Problems importing an OO database into LO

Hi :)

Almost no-one is developing Base or at least developments are not
reaching the releases.  So LO Base is almost no different from OOo's
Base except that it might have some regressions from the developments
of other components of LO.  



I get the impression that there is no official guide for OOo's Base and
so i am hoping that the documentation being written for LO/OOo Base
will help the devs work out what needs to be worked on or at least how
Base should be working.  



The BoD are against the idea of pulling in expertise from the various
back-ends that could work well with Base.  Someone did approach
Postgresql and they seemed positive but they need to break through the
reluctance of the BoD.  



I figured that we might get some feedback if people here started using
MariaDb.  Obviously people from MySql are unlikely to help as MySql is
owned by Oracle.  However the database experts here would rather
promote MySql which is only ever going to be a one-way street.  



I had hoped that other people would approach other projects such as (crucially) 
HSqlDb.  



Collaborating about Base is difficult because the experts and required
skills are scattered across several different mailing list and none are
willing to join another high-traffic list that hardly ever deals with
Base.  The BoD say they have more important issues to deal with and
can't spare the resources of setting up a mailing list dedicated to
Base.  - After all the other apps/modules of LO don't have their own
mailing lists and don't need them so why treat Base any different?



The BoD's big plan for getting Base up to scratch is to sitwait to
see if someone gets annoyed enough with it to start working at it but
the problems are more extensive than 1 or 2 people could handle so
every-time someone starts they get demoralised and leave.  Ian is just
one more example of this.    

Dan is a star for making such a good start on the documentation.  
Regards from
Tom :)

--- On Tue, 17/4/12, Pertti Rönnberg p...@elisanet.fi wrote:

From: Pertti Rönnberg p...@elisanet.fi
Subject: Re: [libreoffice-users] Re: Problems importing an OO database into LO
To: users@global.libreoffice.org
Date: Tuesday, 17 April, 2012, 15:03

On 17.4.2012 12:34, ptoye wrote:
 Andreas Säger wrote
 Why can't you run SQL update queries? This is trivial to do in SQL. The
 SQL is trivial to execute by macro.
 If you desparately want a graphical query designer for
 update/insert/delete queries, then you should write one and store your
 queries somewhere in the .odb container.
 
 
 Of course I can. If I can find out how to do it.
 
 But this isn't the point, is it? The real point is that database front-ends
 and macro languages are meant to make life easy, not difficult. You seem to
 dislike sugar - worried about your diameter? The computer was made for
 man, not man for the computer. Why not program in assembler - gives you much
 more control and isn't really that hard (I speak from years of assembler
 experience and with my tongue firmly in my cheek)?
 
 -
 Peter
 --
 View this message in context: 
 http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3916735.html
 Sent from the Users mailing list archive at Nabble.com.
 

Well said Peter!

I totally and completely agree with you and Ian Whitfield.


And thanks to Ian for the tips about Kexi – I am almost ready for anything but 
LibO-Base.

Since the beginning of this year I have been trying to create a similar member 
register about a boy scout organization’s senior leaders also collecting 
memorable info from gone days – before these leaders are gone. The most I got 
from the efforts is waste of time and frustration.

A week ago Dan Lewis kindly sent to me drafts on documentation about creating a 
Base-db. It is very well written, clear, logic, easy to follow – but it is a 
draft, written in 2010 for OpenO. As far as I could see, there are nothing 
similar for LibO-Base yet.

Regarding LibO-Base’s situation today, very much should be helped if that Dan’s 
documentation should be completed and finished and included in the LibO’s 
(Base) introduction.

(When following Dan’s documentation I also noticed that in LibO-Base you can 
create a form /_based on a query_/ only using the Form Wizard – Design View 
allows you to create a form /_only based on a table = one table!_/)

To the LibO-folks and developers I repeat:

Stop developing LibO-Base;go back to the latest stable version and start to 
complete it and repair all discrepancies in the program and between the program 
and it’s documentation!

There is so much good done in LibO-Base so why not get the rest OK? So it at 
least should meet the promises in advertising.! Without problems!

And:
What (in @!?*@!??) can be the clever idea with having in LibO-base a embedded 
HSQL v.1.8 that is not supported any more when the latest version is 2.2.x? 
What about e.g. SQLite?

As Peter said:thus making the life easier  -- and if not easier

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

Hi :)
The message got sent to my junk folder and i haven't seen any replies so i 
thought it might be a good idea to try to get it  onto the list by trying to 
reply to it.
Good luck and regards from
Tom :)

--- On Tue, 17/4/12, frofa fro...@yahoo.com.au wrote:

From: frofa fro...@yahoo.com.au
Subject: [libreoffice-users] Legacy Base reports won't open in LibreOffice 3.5
To: users@global.libreoffice.org
Date: Tuesday, 17 April, 2012, 5:26

The original problem (I reported elsewhere in Feb 2012) was that my numerous
(painstakingly designed) reports originally done in OO 3.3 using the
built-in report wizard/designer (used because I could not get the result I
wanted with the Report Builder extension) would NOT open/run in LO 3.5
(despite running perfectly in OO).

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.

UPDATE  SOLUTION….

After much trial-and-error sleuthing, I may have hit upon a solution to this
apparent problem. It involves adding a 'missing' hidden form control (see
steps below). I'll be interested to know if this actually helps anyone with
problems running legacy database reports under LO.

1. Open your legacy report for EDITING in the usual way (right-click and
choose 'Edit').

2. Now open the FORM NAVIGATOR (button).

3. Under the 'Report source' item you should see these controls -
CommandType, QueryName, Command, GroupFieldNames, FieldNames,
RecordFieldNames. If there is NOT an item named 'Sorting', you must add it.
I found it 'missing' in my legacy reports (created in OO), and when I added
it, the reports run properly! (Perhaps this 'Sorting' hidden control has
been added at some stage of LO development?)

4. To add the 'Sorting' item, just do these steps:
  - Right-Click on the enclosing item 'ReportSource'
  - Under the NEW item pop-up menu select 'HiddenControl', and a new control
will be created in the end of the list of existing controls (probably under
the item 'RecordFieldNames').
  - Now, change the name of this new control to 'Sorting'.
  - To do this, right-click on the new item, and choose PROPERTIES from the
pop-up menu.
  - In the resulting window/pane, change the (Hidden Control) name to
'Sorting' (type exactly - no quotes, and with a capital 'S') and close the
window.
  - You should now see an item called 'Sorting' at the end of your list of
hidden control for your report source item.
  - Close the Form Navigator window and SAVE the report.

5. Your legacy report should now run/open as it used to under OpenOffice.

I wonder if anyone else has experienced this problem and might like to try
out the solution above, and let us know if it worked? (note: I'm using LO on
Mac OS 10.6). 

--
View this message in context: 
http://nabble.documentfoundation.org/Legacy-Base-reports-won-t-open-in-LibreOffice-3-5-tp3916293p3916293.html
Sent from the Users mailing list archive at Nabble.com.

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

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

[libreoffice-users] Re: Problems importing an OO database into LO


Am 17.04.2012 16:03, Pertti Rönnberg wrote:


To the LibO-folks and developers I repeat:

Stop developing LibO-Base;go back to the latest stable version and start
to complete it and repair all discrepancies in the program and between
the program and it’s documentation!

There is so much good done in LibO-Base so why not get the rest OK? So
it at least should meet the promises in advertising.! Without problems!

As far as I can see, the Base component of LibO 3.5 is identical to the 
one in OOo 3.3.

And:
What (in @!?*@!??) can be the clever idea with having in LibO-base a
embedded HSQL v.1.8 that is not supported any more when the latest
version is 2.2.x? What about e.g. SQLite?

Within a few minutes you can export your embedded HSQL 1.8 to an 
external HSQL 2.8. This is really a piece of cake.
SQLite would not solve a single problem with Base, even if somebody 
would manage to integrate this thing. It would be rather different 
from all the other supported databases.
HSQL is a vanilla database. There is nothing special with its features 
and data types. Being a very well done Java application it is platform 
independent byte by byte.



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

Hi :)
Would it be easy to upgrade the HSqlDb embedded in Base or would all the tweaks 
need to be applied?  Are the tweaks vital or could they left out? 
Regards from
Tom :)


--- On Tue, 17/4/12, Andreas Säger ville...@t-online.de wrote:

From: Andreas Säger ville...@t-online.de
Subject: [libreoffice-users] Re: Problems importing an OO database into LO
To: users@global.libreoffice.org
Date: Tuesday, 17 April, 2012, 16:28

Am 17.04.2012 16:03, Pertti Rönnberg wrote:

 To the LibO-folks and developers I repeat:
 
 Stop developing LibO-Base;go back to the latest stable version and start
 to complete it and repair all discrepancies in the program and between
 the program and it’s documentation!
 
 There is so much good done in LibO-Base so why not get the rest OK? So
 it at least should meet the promises in advertising.! Without problems!
 
As far as I can see, the Base component of LibO 3.5 is identical to the one in 
OOo 3.3.
 And:
 What (in @!?*@!??) can be the clever idea with having in LibO-base a
 embedded HSQL v.1.8 that is not supported any more when the latest
 version is 2.2.x? What about e.g. SQLite?
 
Within a few minutes you can export your embedded HSQL 1.8 to an external HSQL 
2.8. This is really a piece of cake.
SQLite would not solve a single problem with Base, even if somebody would 
manage to integrate this thing. It would be rather different from all the 
other supported databases.
HSQL is a vanilla database. There is nothing special with its features and 
data types. Being a very well done Java application it is platform independent 
byte by byte.


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


Am 17.04.2012 17:38, Tom Davies wrote:

Hi :)
Would it be easy to upgrade the HSqlDb embedded in Base or would all the tweaks 
need to be applied?  Are the tweaks vital or could they left out?
Regards from
Tom :)




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.



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


Am 16.04.2012 22:36, Séamas Ó Brógáin wrote:

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.



There is AutoCorrect, there is AutoText (F3 and Ctrl+F3) and there is a 
most simple macro:

REM  *  BASIC  *
sub Insert_Em_Dash()
REM the quoted string is one em-dash
insertChar —

REM same with decimal:
' insertChar Chr(8212)

REM same with a hex number:
'insertChar Chr(cInt(H2014))
end sub

sub Insert_En_Dash()
insertChar Chr(cInt(H2013))
end sub

sub Insert_Figure_Dash()
insertChar Chr(cInt(H2012))
end sub

sub insertChar(s$)
dim document   as object
dim dispatcher as object
document   = ThisComponent.CurrentController.Frame
dispatcher = createUnoService(com.sun.star.frame.DispatchHelper)
dim args1(0) as new com.sun.star.beans.PropertyValue
args1(0).Name = Text
args1(0).Value = s
dispatcher.executeDispatch(document, .uno:InsertText, , 0, args1())
end sub


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

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


--- On Tue, 17/4/12, Andreas Säger ville...@t-online.de wrote:

From: Andreas Säger ville...@t-online.de
Subject: [libreoffice-users] Re: Problems importing an OO database into LO
To: users@global.libreoffice.org
Date: Tuesday, 17 April, 2012, 17:14

Am 17.04.2012 17:38, Tom Davies wrote:
 Hi :)
 Would it be easy to upgrade the HSqlDb embedded in Base or would all the 
 tweaks need to be applied?  Are the tweaks vital or could they left out?
 Regards from
 Tom :)
 
 

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.


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

2012-04-17 Thread Fernand Vanrie


On 17/04/2012 18:14, Andreas Säger wrote:

Am 17.04.2012 17:38, Tom Davies wrote:

Hi :)
Would it be easy to upgrade the HSqlDb embedded in Base or would all 
the tweaks need to be applied?  Are the tweaks vital or could they 
left out?

Regards from
Tom :)




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.




+ 1000


--
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-17 Thread ptoye


Pertti Rönnberg wrote
 
 
 Well said Peter!
 
 I totally and completely agree with you and Ian Whitfield.
 
 

Well, someone likes me! My point is that I'm really a hacker when it comes
to databases, not a professional coder, and life really needs to be made
easier.

I'm almost thinking of installing something like MySQL and writing my own
front-end in Java.

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.

-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3918036.html
Sent from the Users mailing list archive at Nabble.com.

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

[libreoffice-users] Re: Browser plugin gives blank page

2012-04-17 Thread Marc Paré


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


--
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-17 Thread Steve Edmonds




On 2012-04-18 06:13, ptoye wrote:

Pertti Rönnberg wrote


Well said Peter!

I totally and completely agree with you and Ian Whitfield.



Well, someone likes me! My point is that I'm really a hacker when it comes
to databases, not a professional coder, and life really needs to be made
easier.

I'm almost thinking of installing something like MySQL and writing my own
front-end in Java.
That's what I did, but front end in Apache/PHP. Take it anywhere, easily 
migrate, update. Data security (from fall over and future proofing. 
Divergence not an issue.)


Steve


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.

-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3918036.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: Browser plugin gives blank page


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

Re: [libreoffice-users] Re: Problems importing an OO database into LO

2012-04-17 Thread Jay Lozier


On 04/17/2012 02:13 PM, ptoye wrote:

Pertti Rönnberg wrote


Well said Peter!

I totally and completely agree with you and Ian Whitfield.



Well, someone likes me! My point is that I'm really a hacker when it comes
to databases, not a professional coder, and life really needs to be made
easier.

I'm almost thinking of installing something like MySQL and writing my own
front-end in Java.
Try MySQL Workbench as MySQL/MariaDB front-end. It has a nice GUI 
interface and is FOSS. There is Ubuntu ppa for Natty and Oneiric if the 
version found on Oracle does not work.


There is a browser/php based GUI front-end phpMyAdmin I believe is the name.

Another front end is HeidiSQL, it is included with the Windows version 
of MariaDB. There is no Linux version of this front-end.


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.

-
Peter
--
View this message in context: 
http://nabble.documentfoundation.org/Problems-importing-an-OO-database-into-LO-tp3890826p3918036.html
Sent from the Users mailing list archive at Nabble.com.




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


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

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

2012-04-17 Thread Thomas Taylor

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

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

Hi :)
AltGr is the Alt key on the right of the space-bar.  You probably just haven't 
noticed the Gr bit before.  
Regards from
Tom :)

--- On Tue, 17/4/12, Thomas Taylor li...@comcast.net wrote:

From: Thomas Taylor li...@comcast.net
Subject: Re: [libreoffice-users] select en-dash and em-dash characters
To: users@global.libreoffice.org
Date: Tuesday, 17 April, 2012, 21:32

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

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

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