Re: New Zealand connection, was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

[Tom Davies]

Hi :)
I kinda assumed there would be some lag added due to processing at each end and 
up there.  Also bandwidth issues and perhaps that the satellites and supporting 
systems might prioritise military, government, corporate and scientific 
data-flow above house calls.

I doubt it's that photons have gotten lazy over the years!  Lol
Regards from
Tom :)  


--- On Wed, 25/7/12, James Knott  wrote:

From: James Knott 
Subject: Re: New Zealand connection, was Fw: Re: [libreoffice-users] now can 
Purchase a NA-DVD
To: users@global.libreoffice.org
Date: Wednesday, 25 July, 2012, 2:51

Brian Barker wrote:
>> Also the "lag time" for satellite can be up to 15 seconds from ground 
>> station through a satellite to the ground station.
> 
> Oh dear: the speed of light must have decreased by a factor of 63 since I was 
> at school!  Has someone told the scientific community?

Probably some politician's attempt to amend the laws of physics. ;-)

Another example: 

RE: [libreoffice-users] Re: Do You Share ODF Documents With MS Office Users?

[Dennis E. Hamilton]

I just used Office Word 2013 Preview to open a PDF that I saved from 
LibreOffice Writer.  It opened in Word (with conversion) and edited just like a 
Word document.  I was able to save it as a .docx (the default suggestion).  I 
couldn't save as PDF though.  That appears to be a glitch in the Preview, 
because Save As ... PDF is enabled.

 - Dennis

-Original Message-
From: NoOp [mailto:gl...@sbcglobal.net] 
Sent: Tuesday, July 24, 2012 19:14
To: users@global.libreoffice.org
Subject: [libreoffice-users] Re: Do You Share ODF Documents With MS Office 
Users?

On 07/24/2012 03:59 AM, Johnny Rosenberg wrote:
[ ... ]
> (besides, the next version of MS Office seems to be able to open PDF
> files and edit them as if they were MS Office documents). Most of the

MS Office 2012?
[ ... ]


-- 
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] repeated search

[Thomas Blasejewicz]

Good morning from Japan
Currently using LO 3.4.5 on Windows XP.

Search: Ctrl + F
In this verion now there is a funny little window opening at the lower
left corner of the screen, while formerly it used to be new
window in the center of the screen. (which was to my taste a lot better)

I noticed, that if you type something there and search: works fine, no
problem.
But, if you close the search window and a little later want to search
again - possibly the same or a related term,
the search window is always empty.

In former times, the software used to automatically insert there what
you have been looking for the last time = saving you the energy to type
it again.

Is there any hope of getting this functionality (this is the way other
software is working too) back?
Maybe some setting somewhere?
Since this is a function I use very often, I find the blank search
window very annoying (and counterproductive).

Thank you.

-- 
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: Do You Share ODF Documents With MS Office Users?

[NoOp]

On 07/24/2012 03:59 AM, Johnny Rosenberg wrote:
...
> 
> Whenever I share office files (mostly spreadsheets) with people I
> export them to PDF first. People are not supposed to edit my files

PDF is not always the panacea some purport it to be... Just a few recent
samples:


[Text in PDF created by cups-pdf not visible when open in LIbreOffice
Draw] - not an LO issue.


[PDF saved forms are not compatible with Adobe Reader] - not LO related
at all, but can be quite devistating if you're passing along PDF's
expecting them to be "Adobe" readable.

While I think that LO does a remarkable job (waves to the devs) in PDF
export, be aware that there are issues:




> (besides, the next version of MS Office seems to be able to open PDF
> files and edit them as if they were MS Office documents). Most of the

MS Office 2012?



To add or edit text in a PDF, you must have the original file from which
the PDF has been made. You can also use a PDF converter, which can be
purchased through the Office Marketplace File Converters.

To change the PDF file, do one of the following:

Open the original Office file in your Office program, make your
changes, and then save the file in PDF format again.
Use a third-party PDF converter tool to import your PDF into an
Office file format, make your changes, and then save the file in PDF
format again.
Use Adobe Acrobat. For more information, see Adobe Acrobat.


> people I know have LibreOffice or OpenOffice.org installed, so it
> could happen that I share an ODS file or two… I rarely use Writer.
> When I write something, it's often things that I need to remember,
> small notes of different kinds, and then I find things like Tomboy
> Notes (GNote if Mono is not an option) more intuitive. I have never
> used Impress, and I never will. Just hate when people use presentation
> software.
...




-- 
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] Selecting fonts in Impress

[anne-ology]

   If it shows how to maintain the font style when adding text to each
subsequent slide,
   I'd very much appreciate seeing your presentation.

   Thank you.



On Mon, Jul 23, 2012 at 7:46 PM, Dan  wrote:

 Is there some way, while in Impress, to make the desired font the
> default for that particular file? It's so frustrating to have to
> continually re-apply the text's font.
>  I like to use differing fonts but within any one file, I want to use
> the same font.
>
> --Anne-ology
>
>  This had been added to another email thread, so I have created a new
> one with this.
>  Anne: I have a slide presentation that looks rather closely to how
> Impress works. At one time it was based on the Getting Started with
> Impress. If you want me to send it to you I will. It is 1.3 MB. It
> discusses using styles which allows you to define what font you want to use
> for each style. For example, I used the style "Title" for the heading of
> all of my slides. All the slide headings have Bitstream Vera Sans Bold
> Italic Size 44. By changing the font and its characteristics in the "Title"
> style, I change all of this for every slide heading at one time.
>
> --Dan
>

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

Re: New Zealand connection, was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

[James Knott]

Brian Barker wrote:
Also the "lag time" for satellite can be up to 15 seconds from ground 
station through a satellite to the ground station.


Oh dear: the speed of light must have decreased by a factor of 63 
since I was at school!  Has someone told the scientific community?


Probably some politician's attempt to amend the laws of physics. ;-)

Another example: 

Re: [libreoffice-users] Re: Can I populate a whole row in Spreadsheet by importing from Database into only one cell?

[Brian Barker]

At 15:09 24/07/2012 -0700, Kuuga Noname wrote:
I found a really weird problem today when I was rearranging the 
sheets, to make them easier to read and find important information 
quickly. I moved the equipment tables with your formula to the first 
sheet and no matter what, the formula only works if the tables begin 
in column A. I then moved the original table and the same thing 
happened there. Why is this? I tried to move the weapon table to the 
same column and re-make the weapons array but that didn't do the trick either.


Nothing weird about it!  The third parameter of the VLOOKUP() 
function indicates the column number in the table from which data 
will be harvested.  Note that this is the column number *within the 
table*, not the number of the spreadsheet column - so it shouldn't 
matter if you move the source table about.


In your original arrangement, the values you needed to appear in 
column C were to be harvested from the second column of the source 
table, those for D from the third, and so on.  The formula COLUMN()-1 
does this: it represents the number one fewer than the (spreadsheet) 
column number of the destination column.  If you move the destination 
table horizontally, you will just have to modify that formula - to 
COLUMN()-2 or whatever.


Brian Barker


--
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: New Zealand connection, was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

[Brian Barker]

At 09:16 24/07/2012 -0400, Tim Lungstrom wrote:
Also the "lag time" for satellite can be up to 15 seconds from 
ground station through a satellite to the ground station.


Oh dear: the speed of light must have decreased by a factor of 63 
since I was at school!  Has someone told the scientific community?


(The delay on the double journey to and from a geostationary 
satellite is about a quarter of a second.)


Brian Barker


--
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] Where are my custom labels?

[Libre User]

Sorry, I mistyped. I am using 3.4.6 which I upgraded from 3.2.? which 
is why I referred to it as the 3.2 family. I just don't remember


Jerry

At 04:37 PM 7/24/2012, you wrote:
Hi Jerry, Libre User schrieb: > I have recently upgraded to 
LibreOffice 3.6.4 and can't find my custom > labels.  Using the LO 
3.2 family I have been creating labels for museum > exhibits.  From 
a museum supplied spreadsheet with the necessary fields, > I used an 
LO Base query sheet and then used "Insert Labels".  I created > a 
custom label by modifying a standard Avery letter sized label 
format > and saved it under a unique name.  Populating the label 
fields from the > query sheet format, I then could create the 
finished the label using the > mail merge function. The definition 
of the labels itself (how many columns and rows, width and height 
...) is stored in the file registrymodifications.xcu in the user 
folder. It is a textfile. The definitions are in an item with "path" 
/org.openoffice.office.Labels/Manufacturer. Search for 
"Manufacturer" in that file. If the database is not visible, you 
need to register it. Use Tools > Options > LibreOffice Base > 
Databases > New. It does not make a new database but only a new 
registration. Browse to the odb file, which belongs to your 
database. It should be in the database folder in the user directory. 
It is not clear, what versions do you really use. Neither LO 3.2 nor 
LO 3.6.4 exists. It might by, that you have not done an upgrade but 
a parallel installation and the old user folder still exists. 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 


--
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] Where are my custom labels?

[Libre User]

Sorry,  should have been 3.4.6.  I guess I'm a dyslectic typist.

Jerry

At 02:54 PM 7/24/2012, you wrote:

Hi :)
Hopefully you mean 3.5.4 as 3.6.anything hasn't been properly 
released yet (although i think you can beta-test a pre-release if 
you feel the urge (if not then you're missing out))


With the 3.5.x branch the User Profile changed location but the 
3.5.4 'should' have found your old one and 'borrowed' it

http://wiki.documentfoundation.org/Documentation/UserProfile
hopefully the wiki guide might help you find your user profiles, 
both the old one and the new one.  I would recommend backing them 
both up before trying to copy the old one into the right place.


Good luck!  Please let us know how it goes!
Regards from
Tom :)


--- On Tue, 24/7/12, Libre User  wrote:

From: Libre User 
Subject: [libreoffice-users] Where are my custom labels?
To: users@global.libreoffice.org
Date: Tuesday, 24 July, 2012, 3:11

I have recently upgraded to LibreOffice 3.6.4 and can't find my 
custom labels.  Using the LO 3.2 family I have been creating labels 
for museum exhibits.  From a museum supplied spreadsheet with the 
necessary fields, I used an LO Base query sheet and then used 
"Insert Labels".  I created a custom label by modifying a standard 
Avery letter sized label format and saved it under a unique 
name.  Populating the label fields from the query sheet format, I 
then could create the finished the label using the mail merge function.


Since upgrading to  LO 3.6.4 my custom label no longer appears among 
the choices when I select the Avery Letter labels.  Is my custom 
label format gone or is it hidden in a folder somewhere?


Also where are the other label formats stored?

Jerry

-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? 
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/

Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? 
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/

Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


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

Re: [libreoffice-users] formatting

[Dan]

 And I offered to send you a copy of a slide show which would 
visually show you how to do many things in Impress. I have not seen any 
comments about it. It might be "talking over your head", or it might 
not. How will you know unless you got the slide show and studied it? It 
seems like you would like to learn more about Impress.


--Dan

anne-ology wrote:

You're obviously knowledgeable, but 'talking over my head'  ;-)

   and you obviously have a good sense of humour  ;-)

wishing you 'Bon Chance' this day, and always,



On Tue, Jul 24, 2012 at 2:45 PM, Jean-Francois Nifenecker <
jean-francois.nifenec...@laposte.net> wrote:

Le 24/07/2012 18:35, anne-ology a écrit :


  Thanks for your response.


 Unfortunately, it's 'clear as mud'  ;-)



:,(


  (1) - I want to be able to make the font of a single file

automatic ... not necessarily using that font again in another file.



Basically, using styles allows just that: set the styles of a particular
file.


  (2) - the style of the file otherwise is defaulted for that

file
... just not the font.



Now, I'm lost ;)


  (3) - F11 does nothing in Impress; nor any of these F keys in

OO-LO



Well, mine does. Try the Format / Styles and formatting menu which does
the same.
This Styles and formatting window lists the styles that are currently
defined in the document.


  (4) - propagate ... hierarchy ... ??? [from gardening to

history-genealogy ... ]



LOL!

Styles can be hierarchically connected with each other: a style can be the
parent of another one.

EG: in Impress, in the Styles and formatting window (see 3. above) click
on the Presentation styles button (2nd from the left on the top row). Also,
select the Hierarchy type in the bottom list. You'll notice that the styles
named Outline1..Outline9 are members of the same "family".

Any change applied to a parent automagically propagates ;) to its heirs.
This means that setting the font of a parent automatically sets its
children font.

I hope I made me clear this time.


  (5) - FR LibO ??? [parlez-vous francais?]




At times, yes ;) but not on this board.


--
Jean-Francois Nifenecker, Bordeaux








--
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] Where are my custom labels?

[Regina Henschel]

Hi Jerry,

Libre User schrieb:

I have recently upgraded to LibreOffice 3.6.4 and can't find my custom
labels.  Using the LO 3.2 family I have been creating labels for museum
exhibits.  From a museum supplied spreadsheet with the necessary fields,
I used an LO Base query sheet and then used "Insert Labels".  I created
a custom label by modifying a standard Avery letter sized label format
and saved it under a unique name.  Populating the label fields from the
query sheet format, I then could create the finished the label using the
mail merge function.


The definition of the labels itself (how many columns and rows, width 
and height ...) is stored in the file registrymodifications.xcu in the 
user folder. It is a textfile. The definitions are in an item with 
"path" /org.openoffice.office.Labels/Manufacturer. Search for 
"Manufacturer" in that file.


If the database is not visible, you need to register it. Use Tools > 
Options > LibreOffice Base > Databases > New. It does not make a new 
database but only a new registration. Browse to the odb file, which 
belongs to your database. It should be in the database folder in the 
user directory.


It is not clear, what versions do you really use. Neither LO 3.2 nor LO 
3.6.4 exists. It might by, that you have not done an upgrade but a 
parallel installation and the old user folder still exists.


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: New Zealand connection,was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

[Anthony Easthope]

I must say that we down under are now slowly undertaking a country wide
program to get majority of the country connected through fibre. I for
one had a digger parked on my front lawn for 2 weeks while they where
laying it down my street. only there is a catch to this scheme we are
unable to connect to it until 2015! or at least thats for my region
(taranaki)

On Tue, 24 Jul 2012, at 05:30 PM, Tom Davies wrote:
> Hi :)
> Ahh, finally i got this far back in the thread!
> 
> Didn't New Zealand win the "Best backdrop" award at the Oscars?  Surely
> that has to count for something! 
> Regards from
> Tom :)
> 
> 
> --- On Tue, 24/7/12, Russell Wilson  wrote:
> 
> From: Russell Wilson 
> Subject: Re: New Zealand connection, was Fw: Re: [libreoffice-users] now
> can Purchase a NA-DVD
> To: "users@global.libreoffice.org" 
> Date: Tuesday, 24 July, 2012, 15:15
> 
> try  starting with something like 1/4 population of New York, 1000 times
> its surface area, and 1/4 of 1% of its financial worth
> 
> Russell
> Dunedin, New Zealand
> 
> 
> 
> 
> >Tom Davies wrote:
> >> Weird.  I assumed it was all done by satellites and that was why the 
> >> connection to the outside world had such limited bandwidth and was so slow.
> >
> >Satellites are so 20th century.  ;-)
> >
> >Actually, with all the fibre cables that have been laid around the world, I 
> >don't understand how NZ could have such poor connections.
> >
> >
> 
> 
> -- 
> 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
> 


-- 
  
  antiso...@myopera.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] formatting

[anne-ology]

   You're obviously knowledgeable, but 'talking over my head'  ;-)

  and you obviously have a good sense of humour  ;-)

   wishing you 'Bon Chance' this day, and always,



On Tue, Jul 24, 2012 at 2:45 PM, Jean-Francois Nifenecker <
jean-francois.nifenec...@laposte.net> wrote:

Le 24/07/2012 18:35, anne-ology a écrit :
>
>  Thanks for your response.
>>
>> Unfortunately, it's 'clear as mud'  ;-)
>>
>
> :,(
>
>
>  (1) - I want to be able to make the font of a single file
>> automatic ... not necessarily using that font again in another file.
>>
>
> Basically, using styles allows just that: set the styles of a particular
> file.
>
>
>  (2) - the style of the file otherwise is defaulted for that
>> file
>> ... just not the font.
>>
>
> Now, I'm lost ;)
>
>
>  (3) - F11 does nothing in Impress; nor any of these F keys in
>> OO-LO
>>
>
> Well, mine does. Try the Format / Styles and formatting menu which does
> the same.
> This Styles and formatting window lists the styles that are currently
> defined in the document.
>
>
>  (4) - propagate ... hierarchy ... ??? [from gardening to
>> history-genealogy ... ]
>>
>
> LOL!
>
> Styles can be hierarchically connected with each other: a style can be the
> parent of another one.
>
> EG: in Impress, in the Styles and formatting window (see 3. above) click
> on the Presentation styles button (2nd from the left on the top row). Also,
> select the Hierarchy type in the bottom list. You'll notice that the styles
> named Outline1..Outline9 are members of the same "family".
>
> Any change applied to a parent automagically propagates ;) to its heirs.
> This means that setting the font of a parent automatically sets its
> children font.
>
> I hope I made me clear this time.
>
>
>  (5) - FR LibO ??? [parlez-vous francais?]
>>
>
> At times, yes ;) but not on this board.
>
>
> --
> Jean-Francois Nifenecker, Bordeaux
>
>

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

[Tom Davies]

Hi :)
I think the French team focus more on their Faq than on documentation
https://wiki.documentfoundation.org/Documentation/Publications/fr
but here is their home-page for LO
http://fr.libreoffice.org/
which looks quite full and has a lot of pages.  

I'm not sure it really helps this time, sorry!
Regards from
Tom :)  



--- On Tue, 24/7/12, Jean-Francois Nifenecker 
 wrote:

From: Jean-Francois Nifenecker 
Subject: Re: [libreoffice-users] formatting
To: users@global.libreoffice.org
Date: Tuesday, 24 July, 2012, 20:45

Le 24/07/2012 18:35, anne-ology a écrit :
>         Thanks for your response.
> 
>         Unfortunately, it's 'clear as mud'  ;-)

:,(

>             (1) - I want to be able to make the font of a single file
> automatic ... not necessarily using that font again in another file.

Basically, using styles allows just that: set the styles of a particular file.

>             (2) - the style of the file otherwise is defaulted for that file
> ... just not the font.

Now, I'm lost ;)

>             (3) - F11 does nothing in Impress; nor any of these F keys in
> OO-LO

Well, mine does. Try the Format / Styles and formatting menu which does the 
same.
This Styles and formatting window lists the styles that are currently defined 
in the document.

>             (4) - propagate ... hierarchy ... ??? [from gardening to
> history-genealogy ... ]

LOL!

Styles can be hierarchically connected with each other: a style can be the 
parent of another one.

EG: in Impress, in the Styles and formatting window (see 3. above) click on the 
Presentation styles button (2nd from the left on the top row). Also, select the 
Hierarchy type in the bottom list. You'll notice that the styles named 
Outline1..Outline9 are members of the same "family".

Any change applied to a parent automagically propagates ;) to its heirs. This 
means that setting the font of a parent automatically sets its children font.

I hope I made me clear this time.

>             (5) - FR LibO ??? [parlez-vous francais?]

At times, yes ;) but not on this board.

-- Jean-Francois Nifenecker, Bordeaux

-- 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: Can I populate a whole row in Spreadsheet by importing from Database into only one cell?

[kuuga]

Thank you, this was just what I needed. I apologise for the late reply but I
have been very busy .

I found a really weird problem today when I was rearranging the sheets, to
make them easier to read and find important information quickly. I moved the
equipment tables with your formula to the first sheet and no matter what,
the formula only works if the tables begin in column A. I then moved the
original table and the same thing happened there. Why is this? I tried to
move the weapon table to the same column and re-make the weapons array but
that didn't do the trick either.

As for the bonus point formula, I already use SUM to get the original value
inherited from two base stats. I'm not really sure how to explain but you
can see what I've done if you open the Skills sheet and look in the C and
I-J columns.



--
View this message in context: 
http://nabble.documentfoundation.org/Can-I-populate-a-whole-row-in-Spreadsheet-by-importing-from-Database-into-only-one-cell-tp3996910p3997534.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] Where are my custom labels?

[Tom Davies]

Hi :)
Hopefully you mean 3.5.4 as 3.6.anything hasn't been properly released yet 
(although i think you can beta-test a pre-release if you feel the urge (if not 
then you're missing out))

With the 3.5.x branch the User Profile changed location but the 3.5.4 'should' 
have found your old one and 'borrowed' it
http://wiki.documentfoundation.org/Documentation/UserProfile
hopefully the wiki guide might help you find your user profiles, both the old 
one and the new one.  I would recommend backing them both up before trying to 
copy the old one into the right place.

Good luck!  Please let us know how it goes!
Regards from
Tom :)


--- On Tue, 24/7/12, Libre User  wrote:

From: Libre User 
Subject: [libreoffice-users] Where are my custom labels?
To: users@global.libreoffice.org
Date: Tuesday, 24 July, 2012, 3:11

I have recently upgraded to LibreOffice 3.6.4 and can't find my custom labels.  
Using the LO 3.2 family I have been creating labels for museum exhibits.  From 
a museum supplied spreadsheet with the necessary fields, I used an LO Base 
query sheet and then used "Insert Labels".  I created a custom label by 
modifying a standard Avery letter sized label format and saved it under a 
unique name.  Populating the label fields from the query sheet format, I then 
could create the finished the label using the mail merge function.

Since upgrading to  LO 3.6.4 my custom label no longer appears among the 
choices when I select the Avery Letter labels.  Is my custom label format gone 
or is it hidden in a folder somewhere?

Also where are the other label formats stored?

Jerry 

-- 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 Re: [libreoffice-users] Migrating from Windows; take it slow

[Lynne Stevens]

omega
The
Omega sector
America's Last
Line of
Defense

*Virtual box is found by typing in Virtual Box into search engine and 
click on the one which says Download it is by Oracle and get the right 
one for the O/S you have . . . I have run all kinds of stuff from inside 
of virtual Box even a USB thing from sprint for getting on the internet 
plug it in and run and that was from Linux and let windows use the 
conection Linux makes running windows seem hard

I use Ubuntu 11.04 . . I started with10.10 VERY STABLE version and then
upgraded to 11.04  I am not going beyond this version as they have the 
floating Icons and it take 2 more clicks to get a program open than with 
Gnome Classic Desktop
Until they fix the next versions to have a Gnome Desktop I am not going 
to even recommend them any more . . Mint and Fallback are piss poor 
fixes for a Gnome Classic desktop . .




*

On 07/24/2012 11:27 AM, Tom Davies wrote:

Hi :)
I meant to say earlier that often (although probably not in this case) there is 
usually something somewhere in Gnu&Linux-land that does do exactly what.  The 
problem most people have is finding it and it's forum or mailing-list.
Regards from
Tom :)


--- On Tue, 24/7/12, Lynne Stevens  wrote:

From: Lynne Stevens 
Subject: Re: [libreoffice-users] Migrating from Windows; take it slow
To: users@global.libreoffice.org
Date: Tuesday, 24 July, 2012, 18:26



omega
 The
Omega sector
America's Last
Line of
Defense

*So install virtual box in LINUX and add the guest additions then add the 
extended pack and you can run or use any thing from inside windows I use it to 
run all kinds of junk not YET in Linux like the drives for ADS Instant video 
transfer from the TV to the computer and use Pinnacle Studios to make movies 
with Linux see's the item and windows runs it . .
*

*


*

On 07/24/2012 05:58 AM, webmaster-Kracked_P_P wrote:

The real problem for many people is the hardware and software needs.

I still have some USB hardware that does not work on Linux.  No working drivers.

Then there is the problem of having to use certain software, for work or 
pleasure, that you either cannot find a good Linux alternative or you MUST use. 
 There is the option of WINE, but some software seems not to want to work under 
that.  Personally, I have never gotten WINE to work for me, but that is just me.

I made a personal choice and used Ubuntu when I bought my last "default" 
desktop.  I had to adjust to some of the software though.  I still have the Windows 
laptops [single or dual boot] to deal with the need Windows software.  My Epson printer 
prints on DVD media, but I have not found any replacement for its Windows software to do 
that work.  There is a graphic program that I bought for Windows that works much easier 
that GIMP, so if I have trouble with an image/graphics, I need to work on it with that 
Windows software.  BUT, most most of the work I do, Ubuntu and the free software for it 
works for me.

So, even though I use Ubuntu as my default system, I still need to keep Windows 
around for those things that I cannot find drivers and software version for in 
Linux.

Even version of Linux differ.
The scanning part of my Epson printer does not work at all with Ubuntu 10.04, 
but will work on 12.04.  I updated the software and drivers I use for it on my 
10.04 system, but still not luck. Something in 12.04 makes it work that I seem 
not to be able to get with 10.04.



On 07/24/2012 08:37 AM, Tom Davies wrote:

Hi :)
Virtualisation is good but if it's a question of drivers for a particular piece 
of hardware then it might not work.  It might, but it if the underlaying OS 
can't see it then i don't see how the virtual machine that is sitting on top of 
that OS is supposed to see it.

It is possible to use emulators or even better is WINE (stands for "Wine Is Not an 
Emulator") but that is a lot more sophisticated and hence slightly harder to set-up 
initially for some programs.

The worst way around is to have a Gnu&Linux in a virtual machine on Windows because 
then the stability of the unix-based systems is sitting on top of the flakiness of 
Windows so you end-up adding the worst of each OS.  A dual-boot means each is directly 
on bare metal so it gives a fair comparison.  Windows inside a virtual machine inside 
Gnu&Linux sounds like it's going to be ver stable too.

Ubuntu and Puppy and possibly a few others have a magic way of installing inside Windows.  It 
avoids 1 of the layers between bare-metal and the OS because it avoids the virtual machine bit.  
The Ubuntu magic way is called the "Wubi".  Again you are adding the worst of each OS and 
in addition the "drives" are really compressed files but it's fast and easy to install 
and many people keep using such things for years with no problems. Obviously it's not made by 
Microsoft and so every once in a while someone has troubles with Windows trying to reject it but 
that is fairly rare.  We used to get about 1 question per

RE: [libreoffice-users] Do You Share ODF Documents With MS Office Users?

[Dennis E. Hamilton]

No, it was a mistake.

The ODF 1.0 and ODF 1.1 standards did not provide a specification for 
spreadsheet formulas, so what OpenOffice implemented was 
implementation-specific and the Office team decided, with some public 
consultation, to not attempt to match OpenOffice, but to work within the ODF 
Standard.  Hence the formula support was also implementation-specific (they 
used a namespace that defined Excel formulas) and there was no interop between 
Office and OpenOffice.

However, now that there is ODF 1.2 and OpenFormula, you'll be happy to know 
that Office 2013 Preview supports OpenFormula in reading and saving ODS in 
Excel.  You can test this by using SkyDrive with the Office Preview Web Apps.

 - Dennis

-Original Message-
From: Gordon Burgess-Parker [mailto:gbpli...@gmail.com] 
Sent: Tuesday, July 24, 2012 11:43
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Do You Share ODF Documents With MS Office 
Users?

On 24/07/12 15:38, Chuck Davis wrote:
>   Cost them some money for new licenses but they upgraded their MS licenses 
> to read my
> files.
>

You need to be aware that MS Office 2010, while it will read ods files, 
strips out ALL the formulae - just leaving the last value. Yeah, sure, 
MS Office "reads" odf format.seems like a deliberate ploy to me.

-- 
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: Batch conversion from csv

[Andreas Säger]

Am 24.07.2012 20:11, Michael Crider wrote:

which only exports as csv.
The reason I attempted other spreadsheet types is because dBase files
can be opened directly in Calc, as well as accessed through Base.
I am open any suggestions for improving this process.




Connect a Base document to your IBM database (via ODBC).
Connect another Base document to an empty directory (the dBase directory).
Copy table icons in the source database and paste them into the tables 
container of the other database.


If your source database is not accessible via ODBC, then you need the 
csv export and you connect a Base docoment to a _directory_ where your 
equally structured csv files can be found.
Again, you copy the source table icons (not the opened grid!) from one 
database to another.



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

[Jean-Francois Nifenecker]

Le 24/07/2012 18:35, anne-ology a écrit :

Thanks for your response.

Unfortunately, it's 'clear as mud'  ;-)


:,(


(1) - I want to be able to make the font of a single file
automatic ... not necessarily using that font again in another file.


Basically, using styles allows just that: set the styles of a particular 
file.



(2) - the style of the file otherwise is defaulted for that file
... just not the font.


Now, I'm lost ;)


(3) - F11 does nothing in Impress; nor any of these F keys in
OO-LO


Well, mine does. Try the Format / Styles and formatting menu which does 
the same.
This Styles and formatting window lists the styles that are currently 
defined in the document.



(4) - propagate ... hierarchy ... ??? [from gardening to
history-genealogy ... ]


LOL!

Styles can be hierarchically connected with each other: a style can be 
the parent of another one.


EG: in Impress, in the Styles and formatting window (see 3. above) click 
on the Presentation styles button (2nd from the left on the top row). 
Also, select the Hierarchy type in the bottom list. You'll notice that 
the styles named Outline1..Outline9 are members of the same "family".


Any change applied to a parent automagically propagates ;) to its heirs. 
This means that setting the font of a parent automatically sets its 
children font.


I hope I made me clear this time.


(5) - FR LibO ??? [parlez-vous francais?]


At times, yes ;) but not on this board.

--
Jean-Francois Nifenecker, Bordeaux

--
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: SQL statement in Base query

[Andreas Säger]

Am 23.07.2012 23:54, Dan wrote:

Ferry Toth wrote:

Did you try with another database as a backend? I like postgres as a
backend a lot.

Ferry


  I am writing a chapter of the Base Guide that includes using SQL
in the Query Design dialog. Chapter 8 of the Base Guides covers using
HSQLDB 2.2.8, MySQL, and PostgreSQL as back ends. So, I am not there
quite yet. It seems that because Base uses HSQLDB 1.8, it does not
conform with the user guide for the database engine it uses.
  When I get to that point, I will need to research how each of
these backends use SQL.
--Dan





Hi,

SELECT  FROM A CROSS JOIN B
 ... is a more explicit way to say...
The older and more common syntax is:
SELECT  FROM A,B
... which creates the cartesian product, which includes all combinations 
of A and B with a row count of COUNT(A.*)*COUNT(B.*)

Both syntax variants can be limited by a WHERE clause.
In the 90ies such queries where not exactly equivalent to INNER JOINs. A 
cross join with WHERE clause used to be much slower because it created 
the full cartesian product first and then filtered out the unwanted 
rows. Only the [INNER] JOIN ... ON... syntax triggered certain 
optimizers. Today this is not an issue anymore. At least HSQLDB performs 
equally well with any syntax variant


SELECT  FROM A CROSS JOIN B WHERE A.BID=B.ID
SELECT  FROM A, B WHERE A.BID=B.ID

SELECT  FROM A JOIN B ON A.BID=B.ID
SELECT  FROM A INNER JOIN B ON A.BID=B.ID

HSQLDB supports all of these with equal results and performance. Base 
parses them correctly.


The ultimate SQL reference for all the common database engines:
> http://kb.askmonty.org/en/cartesian-filter-join-ii-cross-join/



--
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] Do You Share ODF Documents With MS Office Users?

[Gordon Burgess-Parker]

On 24/07/12 15:38, Chuck Davis wrote:

  Cost them some money for new licenses but they upgraded their MS licenses to 
read my
files.



You need to be aware that MS Office 2010, while it will read ods files, 
strips out ALL the formulae - just leaving the last value. Yeah, sure, 
MS Office "reads" odf format.seems like a deliberate ploy to me.


--
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] Do You Share ODF Documents With MS Office Users?

[Don Parris]

Thanks Chuck!  That's pretty helpful.

Thanks to the others as well.  Again, my focus is more on whether and how
people share their documents than on the intricacies of advocacy.  :-)

Regards,
Don

On Tue, Jul 24, 2012 at 10:38 AM, Chuck Davis  wrote:

> To answer your question:  Yes, I send *.odf files to others in a
> business setting.  When they tell me they can't open the file I
> instruct them to upgrade their office suite to a more modern version
> (i.e. buy new licenses) or, alternatively, obtain a (free) copy of
> OOo.  I told our accounting firm if they wanted to do our work they
> would upgrade to read *.odf files -- and they did.  Cost them some
> money for new licenses but they upgraded their MS licenses to read my
> files.
>
>
> On Mon, Jul 23, 2012 at 6:03 PM, Don Parris  wrote:
> > I would like to take something of a straw poll, if that's ok.  I simply
> > want to know whether any of you have shared documents using the ODF
> format
> > with MS Office users (preferably in a business environment), and what was
> > the reaction?  What problems
> >
> > I am not seeking advice on how to share documents with MS Office users.
> >  Nor am I interested in an in-depth analysis of why one might experience
> > problems in sharing such documents.  I simply want to know your
> experience.
> >
> > I have been sharing a simple spreadsheet document between LO (at home)
> and
> > MSO (at work) in the OD format.  The experience has been interesting on
> the
> > MS Office side of it.  I get error messages (that don't seem to be real
> > errors), and if I choose the "repair" option, it claims to fix the
> errors,
> > and even gives me a link to click to see the list of alleged corrections.
> >  The list is just a near-empty XML document.  And to save a document in
> ODF
> > raises a warning *every single time*, with no opportunity to say "stop
> > warning me".
> >
> > I know most of us still have to deal with both suites.  I just wonder if
> > anyone else (how many???) has experienced similar issues.
> >
> > Thanks,
> > Don
> > --
> > D.C. Parris, FMP, Linux+, ESL Certificate
> > Minister, Security/FM Coordinator, Free Software Advocate
> > http://dcparris.net/
> > <
> http://www.linkedin.com/in/dcparris>
> > GPG Key ID: F5E179BE
> >
> > --
> > 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
>
>


-- 
D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software Advocate
http://dcparris.net/

GPG Key ID: F5E179BE

-- 
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] Migrating from Windows; take it slow

[Tom Davies]

Hi :)
I meant to say earlier that often (although probably not in this case) there is 
usually something somewhere in Gnu&Linux-land that does do exactly what.  The 
problem most people have is finding it and it's forum or mailing-list.  
Regards from
Tom :)  


--- On Tue, 24/7/12, Lynne Stevens  wrote:

From: Lynne Stevens 
Subject: Re: [libreoffice-users] Migrating from Windows; take it slow
To: users@global.libreoffice.org
Date: Tuesday, 24 July, 2012, 18:26



omega
    The
Omega sector
America's Last
Line of
Defense

*So install virtual box in LINUX and add the guest additions then add the 
extended pack and you can run or use any thing from inside windows I use it to 
run all kinds of junk not YET in Linux like the drives for ADS Instant video 
transfer from the TV to the computer and use Pinnacle Studios to make movies 
with Linux see's the item and windows runs it . .
*

*


*

On 07/24/2012 05:58 AM, webmaster-Kracked_P_P wrote:
> 
> The real problem for many people is the hardware and software needs.
> 
> I still have some USB hardware that does not work on Linux.  No working 
> drivers.
> 
> Then there is the problem of having to use certain software, for work or 
> pleasure, that you either cannot find a good Linux alternative or you MUST 
> use.  There is the option of WINE, but some software seems not to want to 
> work under that.  Personally, I have never gotten WINE to work for me, but 
> that is just me.
> 
> I made a personal choice and used Ubuntu when I bought my last "default" 
> desktop.  I had to adjust to some of the software though.  I still have the 
> Windows laptops [single or dual boot] to deal with the need Windows 
> software.  My Epson printer prints on DVD media, but I have not found any 
> replacement for its Windows software to do that work.  There is a graphic 
> program that I bought for Windows that works much easier that GIMP, so if I 
> have trouble with an image/graphics, I need to work on it with that Windows 
> software.  BUT, most most of the work I do, Ubuntu and the free software for 
> it works for me.
> 
> So, even though I use Ubuntu as my default system, I still need to keep 
> Windows around for those things that I cannot find drivers and software 
> version for in Linux.
> 
> Even version of Linux differ.
> The scanning part of my Epson printer does not work at all with Ubuntu 10.04, 
> but will work on 12.04.  I updated the software and drivers I use for it on 
> my 10.04 system, but still not luck. Something in 12.04 makes it work that I 
> seem not to be able to get with 10.04.
> 
> 
> 
> On 07/24/2012 08:37 AM, Tom Davies wrote:
>> Hi :)
>> Virtualisation is good but if it's a question of drivers for a particular 
>> piece of hardware then it might not work.  It might, but it if the 
>> underlaying OS can't see it then i don't see how the virtual machine that is 
>> sitting on top of that OS is supposed to see it.
>> 
>> It is possible to use emulators or even better is WINE (stands for "Wine Is 
>> Not an Emulator") but that is a lot more sophisticated and hence slightly 
>> harder to set-up initially for some programs.
>> 
>> The worst way around is to have a Gnu&Linux in a virtual machine on Windows 
>> because then the stability of the unix-based systems is sitting on top of 
>> the flakiness of Windows so you end-up adding the worst of each OS.  A 
>> dual-boot means each is directly on bare metal so it gives a fair 
>> comparison.  Windows inside a virtual machine inside Gnu&Linux sounds like 
>> it's going to be ver stable too.
>> 
>> Ubuntu and Puppy and possibly a few others have a magic way of installing 
>> inside Windows.  It avoids 1 of the layers between bare-metal and the OS 
>> because it avoids the virtual machine bit.  The Ubuntu magic way is called 
>> the "Wubi".  Again you are adding the worst of each OS and in addition the 
>> "drives" are really compressed files but it's fast and easy to install and 
>> many people keep using such things for years with no problems. Obviously 
>> it's not made by Microsoft and so every once in a while someone has troubles 
>> with Windows trying to reject it but that is fairly rare.  We used to get 
>> about 1 question per month that was specifically about the Wubi and solved 
>> by moving to a dual-boot.
>> 
>> 
>> So, there are tons of different ways of avoiding wiping Windows and that 
>> seems to be the best way to make the migration much more gentle and less 
>> stressful.  Throwing yourself to the lions is the fastest way to learn to 
>> deal with lions (or die) but there is no real need to create so much stress.
>> Regards from
>> Tom :)
>> 
>> 
>> --- On Tue, 24/7/12, Simon Cropper  
>> wrote:
>> 
>> From: Simon Cropper 
>> Subject: Re: [libreoffice-users] Migrating from Windows; take it slow
>> To: users@global.libreoffice.org
>> Date: Tuesday, 24 July, 2012, 11:05
>> 
>> On 24/07/12 19:36, Keith Bainbridge wrote:
>>> On Sun, 22 Jul 2012 13:41:59 -0400 webmaster-Kracked_P_P
>>>  wrote:

Re: [libreoffice-users] Re: Batch conversion from csv

[Michael Crider]

On 07/24/2012 12:16 PM, Andreas Säger wrote:

Am 24.07.2012 13:34, Michael Crider wrote:

I have csv files generated from an SQL command-line utility that I am
trying to convert to dBase using the batch converter. If I open the csv
in LibreOffice, a default option is "Quoted fields as text", and if it
is saved as another filetype, those fields remain text, but when using
the batch converter it will bring all numbers in as numbers, even if
they are quoted. The command I am using is:
libreoffice --headless --invisible --convert-to dbf *.csv
I have the same results if I convert to other spreadsheet types. Is
there a way to tell the batch converter to convert "quoted fields as 
text"?





CSV is a database exchange format. dBase is a database in a directory. 
Why do you try to load csv into spreadsheets?
Why csv at all? Probably you can connect Base to the database and use 
it directly. Base is a versatile tool to serve database data to office 
documents and it can be used to move data from one database type to 
another.



This is part of my attempt to automate the process (run by cron) to 
export data from an IBM server (DB2 database) to netbooks that are 
carried away from the office. There are 2 tables which are each dumped 
to dBase files and copied to the netbooks, where an odb file exists that 
points to the directory with the dBase files. Initially the data was 
being downloaded from DB2 by a Windows program that could save directly 
as dBase, but this could not be automated, and I wanted to move the 
process to an Ubuntu server. The only option I have found for retrieving 
the data from DB2 is using IBM's unixODBC driver and the isql command, 
which only exports as csv.
The reason I attempted other spreadsheet types is because dBase files 
can be opened directly in Calc, as well as accessed through Base.

I am open any suggestions for improving this process.


--
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] SQL statement in Base query

[Jay Lozier]

On 07/24/2012 01:39 PM, Mark Stanton wrote:

In article <500ea6e8.4030...@gmail.com>, Jay Lozier wrote:

Actually most users of different backend db will be familiar with the
SQL version of that backend. What users need are two things: a connector
between Base and the backend and instructions on connecting to that backend.

The problem is, I think, that Base does some "pre-processing" to check the SQL, 
which
causes a problem, particularly in this context (non-standard SQL).  Although 
there are
some helpful points to it are there enough?

Regards
Mark
Another question is whether  a generic connector versus a specific 
connector (say for MySQL) will more problematic. I would hope a specific 
connector would address using some of the extensions which a generic 
connector probably would not. Also, I would expect Base to lag behind 
the current release of most backends. New features in the current 
release may not be supported by Base or the connector. The severity of 
this issue probably depends on whether the db project/vendor explicitly 
supports using Base as a front end or are they supplied by others 
(independent or AOO/LO).


I prefer to use Base for entry forms and predefined queries and use 
other db specific tools for administrative tasks and db design.


--
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] SQL statement in Base query

[Mark Stanton]

In article <500ea6e8.4030...@gmail.com>, Jay Lozier wrote:
> Actually most users of different backend db will be familiar with the 
> SQL version of that backend. What users need are two things: a connector 
> between Base and the backend and instructions on connecting to that backend.

The problem is, I think, that Base does some "pre-processing" to check the SQL, 
which 
causes a problem, particularly in this context (non-standard SQL).  Although 
there are 
some helpful points to it are there enough?

Regards
Mark



-- 
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] Migrating from Windows; take it slow

[Lynne Stevens]

omega
The
Omega sector
America's Last
Line of
Defense

*So install virtual box in LINUX and add the guest additions then add 
the extended pack and you can run or use any thing from inside windows I 
use it to run all kinds of junk not YET in Linux like the drives for ADS 
Instant video transfer from the TV to the computer and use Pinnacle 
Studios to make movies with Linux see's the item and windows runs it . .

*

*


*

On 07/24/2012 05:58 AM, webmaster-Kracked_P_P wrote:


The real problem for many people is the hardware and software needs.

I still have some USB hardware that does not work on Linux.  No 
working drivers.


Then there is the problem of having to use certain software, for work 
or pleasure, that you either cannot find a good Linux alternative or 
you MUST use.  There is the option of WINE, but some software seems 
not to want to work under that.  Personally, I have never gotten WINE 
to work for me, but that is just me.


I made a personal choice and used Ubuntu when I bought my last 
"default" desktop.  I had to adjust to some of the software though.  I 
still have the Windows laptops [single or dual boot] to deal with the 
need Windows software.  My Epson printer prints on DVD media, but I 
have not found any replacement for its Windows software to do that 
work.  There is a graphic program that I bought for Windows that works 
much easier that GIMP, so if I have trouble with an image/graphics, I 
need to work on it with that Windows software.  BUT, most most of the 
work I do, Ubuntu and the free software for it works for me.


So, even though I use Ubuntu as my default system, I still need to 
keep Windows around for those things that I cannot find drivers and 
software version for in Linux.


Even version of Linux differ.
The scanning part of my Epson printer does not work at all with Ubuntu 
10.04, but will work on 12.04.  I updated the software and drivers I 
use for it on my 10.04 system, but still not luck. Something in 12.04 
makes it work that I seem not to be able to get with 10.04.




On 07/24/2012 08:37 AM, Tom Davies wrote:

Hi :)
Virtualisation is good but if it's a question of drivers for a 
particular piece of hardware then it might not work.  It might, but 
it if the underlaying OS can't see it then i don't see how the 
virtual machine that is sitting on top of that OS is supposed to see it.


It is possible to use emulators or even better is WINE (stands for 
"Wine Is Not an Emulator") but that is a lot more sophisticated and 
hence slightly harder to set-up initially for some programs.


The worst way around is to have a Gnu&Linux in a virtual machine on 
Windows because then the stability of the unix-based systems is 
sitting on top of the flakiness of Windows so you end-up adding the 
worst of each OS.  A dual-boot means each is directly on bare metal 
so it gives a fair comparison.  Windows inside a virtual machine 
inside Gnu&Linux sounds like it's going to be ver stable too.


Ubuntu and Puppy and possibly a few others have a magic way of 
installing inside Windows.  It avoids 1 of the layers between 
bare-metal and the OS because it avoids the virtual machine bit.  The 
Ubuntu magic way is called the "Wubi".  Again you are adding the 
worst of each OS and in addition the "drives" are really compressed 
files but it's fast and easy to install and many people keep using 
such things for years with no problems. Obviously it's not made by 
Microsoft and so every once in a while someone has troubles with 
Windows trying to reject it but that is fairly rare.  We used to get 
about 1 question per month that was specifically about the Wubi and 
solved by moving to a dual-boot.



So, there are tons of different ways of avoiding wiping Windows and 
that seems to be the best way to make the migration much more gentle 
and less stressful.  Throwing yourself to the lions is the fastest 
way to learn to deal with lions (or die) but there is no real need to 
create so much stress.

Regards from
Tom :)


--- On Tue, 24/7/12, Simon Cropper 
 wrote:


From: Simon Cropper 
Subject: Re: [libreoffice-users] Migrating from Windows; take it slow
To: users@global.libreoffice.org
Date: Tuesday, 24 July, 2012, 11:05

On 24/07/12 19:36, Keith Bainbridge wrote:

On Sun, 22 Jul 2012 13:41:59 -0400 webmaster-Kracked_P_P
 wrote:

Anyone who really wants to learn how to use Linux as a replacement
for Windows, try dual booting a system if you do not have a spare one
to try Linux with as its only OS.


G'day.


The other option for the odd trip back to windows is virtualisation.
Mostly, you can tell the system to let windows use a device as if you
had booted into windows

Regards


Keith Bainbridge
PO Box 324
BELMONT Vic 3216 Australia
+61 (0)408 522 706

keith.bainbridge.3...@gmail.com


Visualization also has the added benefit of a shared clipboard and being
able to work on the same data at the same time (well nearly).







--
For unsubscribe instructions e-mail to: users+

[libreoffice-users] Re: Batch conversion from csv

[Andreas Säger]

Am 24.07.2012 13:34, Michael Crider wrote:

I have csv files generated from an SQL command-line utility that I am
trying to convert to dBase using the batch converter. If I open the csv
in LibreOffice, a default option is "Quoted fields as text", and if it
is saved as another filetype, those fields remain text, but when using
the batch converter it will bring all numbers in as numbers, even if
they are quoted. The command I am using is:
libreoffice --headless --invisible --convert-to dbf *.csv
I have the same results if I convert to other spreadsheet types. Is
there a way to tell the batch converter to convert "quoted fields as text"?




CSV is a database exchange format. dBase is a database in a directory. 
Why do you try to load csv into spreadsheets?
Why csv at all? Probably you can connect Base to the database and use it 
directly. Base is a versatile tool to serve database data to office 
documents and it can be used to move data from one database type to another.



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

[anne-ology]

   Thanks for your response.

   Unfortunately, it's 'clear as mud'  ;-)
   (1) - I want to be able to make the font of a single file
automatic ... not necessarily using that font again in another file.
   (2) - the style of the file otherwise is defaulted for that file
... just not the font.
   (3) - F11 does nothing in Impress; nor any of these F keys in
OO-LO
   (4) - propagate ... hierarchy ... ??? [from gardening to
history-genealogy ... ]
   (5) - FR LibO ??? [parlez-vous francais?]



On Tue, Jul 24, 2012 at 1:16 AM, Jean-Francois Nifenecker <
jean-francois.nifenec...@laposte.net> wrote:

Le 24/07/2012 01:56, anne-ology a écrit :
>
>  Is there some way, while in Impress, to make the desired font the
>> default for that particular file?
>>it's so frustrating to have to continually re-apply the text's
>> font.
>>
>>
> Yes, it is.
>
> The answer is: styles.
>
> In Impress, there are two styles categories : images and presentations
> (display them using F11).
>
> In the images category, setting Default style font will propagate to the
> others, because Default is their common parent (select the Hierarchy option
> at the bottom of the styles window).
>
> In the presentations category, apart from the outline1..9 styles, styles
> have no parent. So you'd have to set outline1 font (which will propagate to
> the outlineX styles) and to set each of the other styles font to get to
> what you're looking for.
>
> Disclaimer: the names used above are a free translation from my FR LibO.
> --
> Jean-Francois Nifenecker, Bordeaux
>
>

-- 
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: New Zealand connection, was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

[Tom Davies]

Hi :)
Ahh, finally i got this far back in the thread!

Didn't New Zealand win the "Best backdrop" award at the Oscars?  Surely that 
has to count for something! 
Regards from
Tom :)


--- On Tue, 24/7/12, Russell Wilson  wrote:

From: Russell Wilson 
Subject: Re: New Zealand connection, was Fw: Re: [libreoffice-users] now can 
Purchase a NA-DVD
To: "users@global.libreoffice.org" 
Date: Tuesday, 24 July, 2012, 15:15

try  starting with something like 1/4 population of New York, 1000 times its 
surface area, and 1/4 of 1% of its financial worth

Russell
Dunedin, New Zealand




>Tom Davies wrote:
>> Weird.  I assumed it was all done by satellites and that was why the 
>> connection to the outside world had such limited bandwidth and was so slow.
>
>Satellites are so 20th century.  ;-)
>
>Actually, with all the fibre cables that have been laid around the world, I 
>don't understand how NZ could have such poor connections.
>
>


-- 
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: New Zealand connection, was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

[Kaya Saman]

On Tue, Jul 24, 2012 at 5:24 PM, Tom Davies  wrote:
> Hi :)
> Going 'off-topic' in a thread like this is not a problem.  We are not trying 
> to fix a set problem for a specific op.  It's just a chat.  I broke it out of 
> the original question by forwarding it back to the list and i changed the 
> subject-line so that people could filter it out quickly and easily.
>
> Oooo i dream of getting 10Mbps at the wall in this office!  Yes, that is 10 
> not anywhere near 100!  We had much higher at the last place and even though 
> we are all just emailing it does feel quite sluggish here.  City centre 
> location in a city just outside London (about an hour away by train or car).
>
> Regards from
> Tom :)
>
>

Hi Tom,

take a look at: https://hyperoptic.com/web/guest/home

currently they're majorly in London but will start spreading out in a
few years.


In conjunction to Metro Ethernet it's pretty cheap... as the
equivalent would be in the 1000's of GBP :-)


Regards,


Kaya

-- 
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: New Zealand connection, was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

[Tom Davies]

Hi :)
Going 'off-topic' in a thread like this is not a problem.  We are not trying to 
fix a set problem for a specific op.  It's just a chat.  I broke it out of the 
original question by forwarding it back to the list and i changed the 
subject-line so that people could filter it out quickly and easily.  

Oooo i dream of getting 10Mbps at the wall in this office!  Yes, that is 10 not 
anywhere near 100!  We had much higher at the last place and even though we are 
all just emailing it does feel quite sluggish here.  City centre location in a 
city just outside London (about an hour away by train or car).  

Regards from
Tom :)  


--- On Tue, 24/7/12, Kaya Saman  wrote:



On Tue, Jul 24, 2012 at 3:35 PM, webmaster-Kracked_P_P
 wrote:
> On 07/24/2012 10:02 AM, James Knott wrote:
>>
>> webmaster-Kracked_P_P wrote:
>>>
>>> That underwater cable network is used for both phone and Internet
>>> communication, since phone systems not seem to be converted to digital to go
>>> through the cables to give more "lines" of communication between countries
>>
>>
>> 
>>
>> Are analog trunks still in use anywhere?  The phone system has been
>> digital for many years, long before there was an Internet. It'd have to be
>> an extremely old cable to require analog trunks. Anything running over fibre
>> would most certainly be digital.
>>
> They still have the cables and they are used.  Mostly they are used as
> digital trunk lines, but not every one has been converted do to their age.
> The expense of laying a new fiber cable across a large body of ocean/sea is
> something that slows up the process of many parts of the world getting the
> better/faster connections.  The poorer the country, or the less number of
> potential users of the service, the longer it will take for the giant
> communication companies to spend the type of money needed to give these
> users the type of service many of us enjoy.  Europe has a better broadband
> system than most of the USA does.  I saw a program for places like the
> Netherlands and other European countries where they have a very large
> section of their country with fiber to the home and they have many different
> companies to choose from for broadband.  With that large competition for the
> broadband market, their Internet prices for 50 MB/s bandwidth is lower than
> my area of the USA for a 5 to 10 MB/s access.  We have just two options.
> Cable modem service or a DSL service.  We pay $50+ a month for either.  On
> some science TV programming, they showed services for as little as $15 a
> month for the same services.  It all comes down to how good is their trunk
> system and how the marketing controls over those trunk lines are regulated.
> For countries like New Zealand, they have to rely on a limited trunk cable
> on the ocean floor.  I would wonder if it was possible to run a trunk line
> from their nation to Australia.  Would it give them more access, or is
> Australia using the same trunk cable system as well.
>
>

Sorry to jump in on a whim like this however, there are quite a few
countries out there in the world now upgrading to fiber as the defacto
for residential "broadband internet" platforms. A few years back when
I was doing the Cisco CCNA course my then lecturer who was an
ex-university lecturer stated that during his frequest travels to
China, they had 100Mbps to the port on the wall at home.

In fact even in Europe they are starting to offer psuedo-metro
solutions where you get either 100Mbps or 1Gbps connections directly
to the wall for business or residences.

The question with these speeds then becomes can non-carrier and
essentially consumer based hardware support those speeds?

Even VDSL2 needs a bit of power to be able to get the maximum out of
between 32-64Mbps which is rated at.


Without going too much off-topic looking at most business based
network kit: Cisco, Juniper etc they can't get anywhere near
100Mbps on routed connections.


The $5000 29xx series of Cisco is claimed to do round 75Mbps
manufacturers figures, so in essence you are probably looking at round
65-70Mbps. I know for a fact that the Cisco 1800 series maxes out at
round 50-55Mbps when using inter-vlan routing, the 800 series is worse
at 40-45Mbps. (I have a few Cisco's at home to test with :-) )


At work our Juniper firewalls doing inter-vlan routing will only
manage 400Mbps in conjunction with $35,000 Cisco 4900_m switches.


Actually it's cheaper and better to build one's own routing system
however, that is wy off-topic. :-)



So in essence I beleive that network gear needs to get better if we
can truly utilize high-speed carriers which are fast coming directly
to our homes!


Regards,


Kaya


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

Re: [libreoffice-users] Migrating from Windows; take it slow

[Tom Davies]

Hi :)
I am actually having a lot of trouble with Windows Xp right now trying to get 
the drivers for an onboard ethernet port.  Ubuntu picked it up right away but 
Xp claims there is no spoon (oops, i mean connection)

Often if 1 distro can pick it up and another can't then it's quite possible to 
get the thing working on any distro but it helps to find a forum where someone 
can help.  Also if a Windows driver does exist then it should be possible to 
use "ndiswrapper" to use that Windows driver in whichever Gnu&Linux distro you 
are trying to work on.  Again it helps to have some forum help.  Perhaps 
http://www.linuxquestions.org

Regards from
Tom :)  


--- On Tue, 24/7/12, webmaster-Kracked_P_P  wrote:

From: webmaster-Kracked_P_P 
Subject: Re: [libreoffice-users] Migrating from Windows; take it slow
To: users@global.libreoffice.org
Date: Tuesday, 24 July, 2012, 15:21


LiveCD/DVD is the only way to see as many distros as possible to figure out 
which one may be best for you.  Even though there are limits on what you can do 
with a LiveCD, it was the only way I knew of, back then, to really decide which 
version of Linux, and desktop environment I wanted to use.

As for Banking and other things on Windows, there are "secure" browsing apps 
that will not leave any traces.  There are even ones that will hide who you are 
from the web sites through a portal service where you can browse in safety 
knowing the web sites will get no info from your system, since they only see 
what the service lets them see - false stuff.  I do not remember where you can 
get these services anymore, but in the mid 2000's I saw a few of them when I 
was looking for free services to help with Windows security problems.

Back to Windows to Linux. . . .

Well, I remember the days when I had to try different version of Linux via a 
Windows VM system.  Back then Mandrake, Red Hat, and others tried in that 
classroom environment.  That is when I decided that Linux might be something to 
try out on a "spare" computer.  All I had in those days were P4 based systems 
running 333MHz to 500MHz for CPUs.

Now it is much easier to see a lot of different distros, as long as you have 
the bandwidth to download .iso files of their LiveCDs or Live DVDs.  I think I 
still have about 5 or 10 different distro and desktop environment combinations 
on Live "media" in my software drawer.  That drawer had mostly Windows software 
and the media I got with my computers, printers, and other hardware, but I keep 
Linux related CDs and DVDs there as well.  It is a 36" by 18" by 8" and it is 
stuffed.

But, for now, if you are a Windows user, I really believe that you take it slow 
and keep both your Windows system and a Linux system going at the same time.  
If you have the hard drive space, a dual boot option seems a good one when you 
do not have a spare system. I use a Dell Laptop with Vista as my dual booting 
system.  I installed Ubuntu 10.04 on it, then upgraded it to 12.04 a few months 
ago, but decided I did not like the Unity/tablet style of desktop and added 
MATE desktop environment to it.  If you like using Ubuntu 10.04's GNOME 2.x 
desktop, this works better than any GNOME option that 12.04 comes with.  MATE 
works as a 12.04 replacement for the type of desktop I got use to with my 
desktop, which I still run 10.04 on.

The big issue for most people who go from Windows to Linux, is the lack of 
drivers for some older hardware [dedicated drivers for very specific hardware] 
that use USB or are specialty cards.  Then their may be problems with drivers 
for the most up-to-date printers and their extra non-printing functions.  Epson 
printer/scanners have problems with the scanner part for some distro versions.  
HP seems to work the best for Printer and Scanner options for Linux systems, or 
at least in my case.

So the big issue with some people will be finding a distro that works with all 
their hardware.  Live media version of a Linux version does help there.  If 
your hardware works then and there, you are set.  My HP laptop had problems 
finding a distro that would work with its sound system.  That was in the days 
of Ubuntu 9.04, and that was the only LiveCD version that worked with that 
laptop's audio system.  HP Pavilion zv6123 AMD64 Athlon powered laptop.  I no 
longer need it to be my Linux system, so it is back to XP/pro and it is used as 
my primary laptop I take to users who need help with their Windows systems.  I 
have a faster laptop, Dell, but I rather not take it if I can.


On 07/24/2012 09:26 AM, Tom Davies wrote:
> Hi :)
> That sounds the perfect way to try it.
> 
> Tim (Webmaster at Kracked Press) made a good point about trying LiveCds to 
> just test-drive various distros.  Trying a few is really ideal.
> 
> Ubuntu might be a good one to start with but it is designed to be comparable 
> with the latest Windows so it is often more heavy and bloated than other 
> distros.  Fedora is quite good because it also tries to be q

Re: New Zealand connection, was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

[James Knott]

Tom Davies wrote:

I think the distance between Australia and New Zealand is surprisingly large.  
Nothing like as close as i keep thinking it is.


If Sarah Palin lived in NZ, she could see Australia from her home. ;-)



--
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: New Zealand connection, was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

[Kaya Saman]

On Tue, Jul 24, 2012 at 3:35 PM, webmaster-Kracked_P_P
 wrote:
> On 07/24/2012 10:02 AM, James Knott wrote:
>>
>> webmaster-Kracked_P_P wrote:
>>>
>>> That underwater cable network is used for both phone and Internet
>>> communication, since phone systems not seem to be converted to digital to go
>>> through the cables to give more "lines" of communication between countries
>>
>>
>> 
>>
>> Are analog trunks still in use anywhere?  The phone system has been
>> digital for many years, long before there was an Internet. It'd have to be
>> an extremely old cable to require analog trunks. Anything running over fibre
>> would most certainly be digital.
>>
> They still have the cables and they are used.  Mostly they are used as
> digital trunk lines, but not every one has been converted do to their age.
> The expense of laying a new fiber cable across a large body of ocean/sea is
> something that slows up the process of many parts of the world getting the
> better/faster connections.  The poorer the country, or the less number of
> potential users of the service, the longer it will take for the giant
> communication companies to spend the type of money needed to give these
> users the type of service many of us enjoy.  Europe has a better broadband
> system than most of the USA does.  I saw a program for places like the
> Netherlands and other European countries where they have a very large
> section of their country with fiber to the home and they have many different
> companies to choose from for broadband.  With that large competition for the
> broadband market, their Internet prices for 50 MB/s bandwidth is lower than
> my area of the USA for a 5 to 10 MB/s access.  We have just two options.
> Cable modem service or a DSL service.  We pay $50+ a month for either.  On
> some science TV programming, they showed services for as little as $15 a
> month for the same services.  It all comes down to how good is their trunk
> system and how the marketing controls over those trunk lines are regulated.
> For countries like New Zealand, they have to rely on a limited trunk cable
> on the ocean floor.  I would wonder if it was possible to run a trunk line
> from their nation to Australia.  Would it give them more access, or is
> Australia using the same trunk cable system as well.
>
>
> --
> 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
>

Sorry to jump in on a whim like this however, there are quite a few
countries out there in the world now upgrading to fiber as the defacto
for residential "broadband internet" platforms. A few years back when
I was doing the Cisco CCNA course my then lecturer who was an
ex-university lecturer stated that during his frequest travels to
China, they had 100Mbps to the port on the wall at home.

In fact even in Europe they are starting to offer psuedo-metro
solutions where you get either 100Mbps or 1Gbps connections directly
to the wall for business or residences.

The question with these speeds then becomes can non-carrier and
essentially consumer based hardware support those speeds?

Even VDSL2 needs a bit of power to be able to get the maximum out of
between 32-64Mbps which is rated at.


Without going too much off-topic looking at most business based
network kit: Cisco, Juniper etc they can't get anywhere near
100Mbps on routed connections.


The $5000 29xx series of Cisco is claimed to do round 75Mbps
manufacturers figures, so in essence you are probably looking at round
65-70Mbps. I know for a fact that the Cisco 1800 series maxes out at
round 50-55Mbps when using inter-vlan routing, the 800 series is worse
at 40-45Mbps. (I have a few Cisco's at home to test with :-) )


At work our Juniper firewalls doing inter-vlan routing will only
manage 400Mbps in conjunction with $35,000 Cisco 4900_m switches.


Actually it's cheaper and better to build one's own routing system
however, that is wy off-topic. :-)



So in essence I beleive that network gear needs to get better if we
can truly utilize high-speed carriers which are fast coming directly
to our homes!


Regards,


Kaya

-- 
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: New Zealand connection, was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

[James Knott]

webmaster-Kracked_P_P wrote:

On 07/24/2012 10:02 AM, James Knott wrote:

webmaster-Kracked_P_P wrote:
That underwater cable network is used for both phone and Internet 
communication, since phone systems not seem to be converted to 
digital to go through the cables to give more "lines" of 
communication between countries




Are analog trunks still in use anywhere?  The phone system has been 
digital for many years, long before there was an Internet. It'd have 
to be an extremely old cable to require analog trunks. Anything 
running over fibre would most certainly be digital.


They still have the cables and they are used.  Mostly they are used as 
digital trunk lines, but not every one has been converted do to their 
age.  The expense of laying a new fiber cable across a large body of 
ocean/sea is something that slows up the process of many parts of the 
world getting the better/faster connections. The poorer the country, 
or the less number of potential users of the service, the longer it 
will take for the giant communication companies to spend the type of 
money needed to give these users the type of service many of us 
enjoy.  Europe has a better broadband system than most of the USA 
does.  I saw a program for places like the Netherlands and other 
European countries where they have a very large section of their 
country with fiber to the home and they have many different companies 
to choose from for broadband.  With that large competition for the 
broadband market, their Internet prices for 50 MB/s bandwidth is lower 
than my area of the USA for a 5 to 10 MB/s access.  We have just two 
options. Cable modem service or a DSL service.  We pay $50+ a month 
for either.  On some science TV programming, they showed services for 
as little as $15 a month for the same services.  It all comes down to 
how good is their trunk system and how the marketing controls over 
those trunk lines are regulated.   For countries like New Zealand, 
they have to rely on a limited trunk cable on the ocean floor.  I 
would wonder if it was possible to run a trunk line from their nation 
to Australia.  Would it give them more access, or is Australia using 
the same trunk cable system as well.





This list 
 
shows many cables going to New Zealand, though some have now been 
decommissioned.  I see links to Canada, U.S., Australia, Fiji and other 
islands.  As for local access, you might be interested in this article: 



These days, low bandwidth tends to be more of a political vs economic or 
technical issue.  For example, in the U.S., someone else mentioned low 
bandwidth in some areas.  Yet, in some states, the incumbent carriers 
have pushed for state laws that prohibit municipalities from providing 
Internet service in areas that the carriers refuse to.  This leaves the 
residents with no access to high speed internet.





--
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: New Zealand connection, was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

[Tom Davies]

Hi :)
I think the distance between Australia and New Zealand is surprisingly large.  
Nothing like as close as i keep thinking it is.  

The Netherlands and Sweden are very atypical of European countries.  I think 
they have an extremely high tax-rate but that gets put into very high 
visibility projects instead of being sunk into black-holes such as "defence" or 
things that only the rich and famous or just people in the capital get to use.  

Regard from
Tom :)  



--- On Tue, 24/7/12, webmaster-Kracked_P_P  wrote:

From: webmaster-Kracked_P_P 
Subject: Re: New Zealand connection, was Fw: Re: [libreoffice-users] now can 
Purchase a NA-DVD
To: users@global.libreoffice.org
Date: Tuesday, 24 July, 2012, 15:35

On 07/24/2012 10:02 AM, James Knott wrote:
> webmaster-Kracked_P_P wrote:
>> That underwater cable network is used for both phone and Internet 
>> communication, since phone systems not seem to be converted to digital to go 
>> through the cables to give more "lines" of communication between countries
> 
> 
> 
> Are analog trunks still in use anywhere?  The phone system has been digital 
> for many years, long before there was an Internet. It'd have to be an 
> extremely old cable to require analog trunks. Anything running over fibre 
> would most certainly be digital.
> 
They still have the cables and they are used.  Mostly they are used as digital 
trunk lines, but not every one has been converted do to their age.  The expense 
of laying a new fiber cable across a large body of ocean/sea is something that 
slows up the process of many parts of the world getting the better/faster 
connections.  The poorer the country, or the less number of potential users of 
the service, the longer it will take for the giant communication companies to 
spend the type of money needed to give these users the type of service many of 
us enjoy.  Europe has a better broadband system than most of the USA does.  I 
saw a program for places like the Netherlands and other European countries 
where they have a very large section of their country with fiber to the home 
and they have many different companies to choose from for broadband.  With that 
large competition for the broadband market, their Internet prices for 50 MB/s 
bandwidth is lower than my
 area of the USA for a 5 to 10 MB/s access.  We have just two options.  Cable 
modem service or a DSL service.  We pay $50+ a month for either.  On some 
science TV programming, they showed services for as little as $15 a month for 
the same services.  It all comes down to how good is their trunk system and how 
the marketing controls over those trunk lines are regulated.   For countries 
like New Zealand, they have to rely on a limited trunk cable on the ocean 
floor.  I would wonder if it was possible to run a trunk line from their nation 
to Australia.  Would it give them more access, or is Australia using the same 
trunk cable system as well.

-- 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] Do You Share ODF Documents With MS Office Users?

[Chuck Davis]

To answer your question:  Yes, I send *.odf files to others in a
business setting.  When they tell me they can't open the file I
instruct them to upgrade their office suite to a more modern version
(i.e. buy new licenses) or, alternatively, obtain a (free) copy of
OOo.  I told our accounting firm if they wanted to do our work they
would upgrade to read *.odf files -- and they did.  Cost them some
money for new licenses but they upgraded their MS licenses to read my
files.


On Mon, Jul 23, 2012 at 6:03 PM, Don Parris  wrote:
> I would like to take something of a straw poll, if that's ok.  I simply
> want to know whether any of you have shared documents using the ODF format
> with MS Office users (preferably in a business environment), and what was
> the reaction?  What problems
>
> I am not seeking advice on how to share documents with MS Office users.
>  Nor am I interested in an in-depth analysis of why one might experience
> problems in sharing such documents.  I simply want to know your experience.
>
> I have been sharing a simple spreadsheet document between LO (at home) and
> MSO (at work) in the OD format.  The experience has been interesting on the
> MS Office side of it.  I get error messages (that don't seem to be real
> errors), and if I choose the "repair" option, it claims to fix the errors,
> and even gives me a link to click to see the list of alleged corrections.
>  The list is just a near-empty XML document.  And to save a document in ODF
> raises a warning *every single time*, with no opportunity to say "stop
> warning me".
>
> I know most of us still have to deal with both suites.  I just wonder if
> anyone else (how many???) has experienced similar issues.
>
> Thanks,
> Don
> --
> D.C. Parris, FMP, Linux+, ESL Certificate
> Minister, Security/FM Coordinator, Free Software Advocate
> http://dcparris.net/
> 
> GPG Key ID: F5E179BE
>
> --
> 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: New Zealand connection, was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

[James Knott]

James Knott wrote:

it would cost more to maintain them then^H^H^H^H than to replace.




--
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: New Zealand connection, was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

[webmaster-Kracked_P_P]

On 07/24/2012 10:02 AM, James Knott wrote:

webmaster-Kracked_P_P wrote:
That underwater cable network is used for both phone and Internet 
communication, since phone systems not seem to be converted to 
digital to go through the cables to give more "lines" of 
communication between countries




Are analog trunks still in use anywhere?  The phone system has been 
digital for many years, long before there was an Internet. It'd have 
to be an extremely old cable to require analog trunks. Anything 
running over fibre would most certainly be digital.


They still have the cables and they are used.  Mostly they are used as 
digital trunk lines, but not every one has been converted do to their 
age.  The expense of laying a new fiber cable across a large body of 
ocean/sea is something that slows up the process of many parts of the 
world getting the better/faster connections.  The poorer the country, or 
the less number of potential users of the service, the longer it will 
take for the giant communication companies to spend the type of money 
needed to give these users the type of service many of us enjoy.  Europe 
has a better broadband system than most of the USA does.  I saw a 
program for places like the Netherlands and other European countries 
where they have a very large section of their country with fiber to the 
home and they have many different companies to choose from for 
broadband.  With that large competition for the broadband market, their 
Internet prices for 50 MB/s bandwidth is lower than my area of the USA 
for a 5 to 10 MB/s access.  We have just two options.  Cable modem 
service or a DSL service.  We pay $50+ a month for either.  On some 
science TV programming, they showed services for as little as $15 a 
month for the same services.  It all comes down to how good is their 
trunk system and how the marketing controls over those trunk lines are 
regulated.   For countries like New Zealand, they have to rely on a 
limited trunk cable on the ocean floor.  I would wonder if it was 
possible to run a trunk line from their nation to Australia.  Would it 
give them more access, or is Australia using the same trunk cable system 
as well.


--
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: New Zealand connection, was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

[James Knott]

Russell Wilson wrote:

try  starting with something like 1/4 population of New York, 1000 times its 
surface area, and 1/4 of 1% of its financial worth


First off, I was thinking of the international trunks.  Analog systems 
are so obsolete that it would cost more to maintain them then to 
replace.  However, even domestically, the same still applies.  I don't 
know if you're referring to New York City or New York State, but even 
assuming the city, Canada has about 4 × the population, or 16 × that of 
NZ, but the area of almost 10 million sq Kilometres is close to 40 times 
that of New Zealand, yet the analog phone system is long gone here.


BTW, I've worked in the telecommunications industry for most of my 
career and it's been over 30 years since the last time I saw an analog 
system.  New Zealand would *REALLY* have to be a back water country to 
still be using an analog phone system.




--
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: New Zealand connection, was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

[Jay Lozier]

On 07/24/2012 10:15 AM, Russell Wilson wrote:

try  starting with something like 1/4 population of New York, 1000 times its 
surface area, and 1/4 of 1% of its financial worth

Russell
Dunedin, New Zealand
In the US, there are rural areas that still do not have very fast 
connections because of the cost of installing fiber cable.






From: James Knott 
To: users@global.libreoffice.org
Sent: Wednesday, 25 July 2012 1:57 AM
Subject: Re: New Zealand connection, was Fw: Re: [libreoffice-users] now can 
Purchase a NA-DVD

Tom Davies wrote:

Weird.  I assumed it was all done by satellites and that was why the connection 
to the outside world had such limited bandwidth and was so slow.

Satellites are so 20th century.  ;-)

Actually, with all the fibre cables that have been laid around the world, I 
don't understand how NZ could have such poor connections.


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







--
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] Migrating from Windows; take it slow

[webmaster-Kracked_P_P]

LiveCD/DVD is the only way to see as many distros as possible to figure 
out which one may be best for you.  Even though there are limits on what 
you can do with a LiveCD, it was the only way I knew of, back then, to 
really decide which version of Linux, and desktop environment I wanted 
to use.


As for Banking and other things on Windows, there are "secure" browsing 
apps that will not leave any traces.  There are even ones that will hide 
who you are from the web sites through a portal service where you can 
browse in safety knowing the web sites will get no info from your 
system, since they only see what the service lets them see - false 
stuff.  I do not remember where you can get these services anymore, but 
in the mid 2000's I saw a few of them when I was looking for free 
services to help with Windows security problems.


Back to Windows to Linux. . . .

Well, I remember the days when I had to try different version of Linux 
via a Windows VM system.  Back then Mandrake, Red Hat, and others tried 
in that classroom environment.  That is when I decided that Linux might 
be something to try out on a "spare" computer.  All I had in those days 
were P4 based systems running 333MHz to 500MHz for CPUs.


Now it is much easier to see a lot of different distros, as long as you 
have the bandwidth to download .iso files of their LiveCDs or Live 
DVDs.  I think I still have about 5 or 10 different distro and desktop 
environment combinations on Live "media" in my software drawer.  That 
drawer had mostly Windows software and the media I got with my 
computers, printers, and other hardware, but I keep Linux related CDs 
and DVDs there as well.  It is a 36" by 18" by 8" and it is stuffed.


But, for now, if you are a Windows user, I really believe that you take 
it slow and keep both your Windows system and a Linux system going at 
the same time.  If you have the hard drive space, a dual boot option 
seems a good one when you do not have a spare system. I use a Dell 
Laptop with Vista as my dual booting system.  I installed Ubuntu 10.04 
on it, then upgraded it to 12.04 a few months ago, but decided I did not 
like the Unity/tablet style of desktop and added MATE desktop 
environment to it.  If you like using Ubuntu 10.04's GNOME 2.x desktop, 
this works better than any GNOME option that 12.04 comes with.  MATE 
works as a 12.04 replacement for the type of desktop I got use to with 
my desktop, which I still run 10.04 on.


The big issue for most people who go from Windows to Linux, is the lack 
of drivers for some older hardware [dedicated drivers for very specific 
hardware] that use USB or are specialty cards.  Then their may be 
problems with drivers for the most up-to-date printers and their extra 
non-printing functions.  Epson printer/scanners have problems with the 
scanner part for some distro versions.  HP seems to work the best for 
Printer and Scanner options for Linux systems, or at least in my case.


So the big issue with some people will be finding a distro that works 
with all their hardware.  Live media version of a Linux version does 
help there.  If your hardware works then and there, you are set.  My HP 
laptop had problems finding a distro that would work with its sound 
system.  That was in the days of Ubuntu 9.04, and that was the only 
LiveCD version that worked with that laptop's audio system.  HP Pavilion 
zv6123 AMD64 Athlon powered laptop.  I no longer need it to be my Linux 
system, so it is back to XP/pro and it is used as my primary laptop I 
take to users who need help with their Windows systems.  I have a faster 
laptop, Dell, but I rather not take it if I can.



On 07/24/2012 09:26 AM, Tom Davies wrote:

Hi :)
That sounds the perfect way to try it.

Tim (Webmaster at Kracked Press) made a good point about trying LiveCds to just 
test-drive various distros.  Trying a few is really ideal.

Ubuntu might be a good one to start with but it is designed to be comparable with 
the latest Windows so it is often more heavy and bloated than other distros.  
Fedora is quite good because it also tries to be quite plug&play but it's often 
the experimental cutting-edge and used as the test-bed for trying apps ahead of 
other distros (well, ahead of Redhat at least).  Anyway the best thing is to try a 
few distros to see what works best for you on your machine and then install it.  
All distros cover the middle-ground and a wide-spread of different machines but 
each distro seems slightly better at certain wacky combinations of real-world 
machines.  Does anyone really have a 'typical' machine in a 'normal' set-up??

I really wish Windows had an equivalent of the LiveCd session that almost every 
distro seems to have these days.  I think if i did internet banking i would 
want to always do it from a LiveCd and thus leave no trace of it on which-ever 
machine.

Regards from
Tom :)



--- On Tue, 24/7/12, Chaim Seymour  wrote:

From: Chaim Seymour 
Subject: Re: [libreoffice-users] Migrat

Re: [libreoffice-users] Do You Share ODF Documents With MS Office Users?

[Jay Lozier]

On 07/24/2012 05:06 AM, Anthony Easthope wrote:

I have a comment on the error dialogue.
I once got into a heated debate with my ICT teacher earlier on this year
and in the debate the comment was made by her that: "Microsoft with that
error dialogue are really just trying to insinuate that their products
are superior to others"

I in a way kind of agree with her because Microsoft have always insisted
that the MO range of extensions should be the industry standard. Due to
this sort of approach I find roadblocks when trying to submit work in
.ODT format to institutions such as NZQA (New Zealand Qualifications
Association). they keep getting angry at me for using a so called "UN
recognized file format". I have now managed to persuade my school and
some other institutions that for a truly open submission and form of
collaboration that the use of ODF standards should be encouraged. the
major problem with persuasion is that people are not willing to make the
change is due to the lack of knowledge of understanding of opensource
and how it can really become better than commercial counterparts.
IMHO most people use the default settings of the software they are 
provided and do not make an effort to learn much about the software's 
capabilities. So if support for a set of file formats is not transparent 
they will probably panic if they see an "error" message when opening a file.


Another problem for FOSS is that our marketing budget is nil and depends 
on word of mouth almost exclusively. IMHO most people do not understand 
the motivation of the FOSS community of developing and supporting useful 
software for all users. Thus, FUD is often used to scare them away 
claiming that many projects become abandonware without mentioning that 
commercial abandonware is also a major problem (any still use Ami-pro?).


With education there can be a global revolution in the sense that open
source programs such as LO will become commonplace and the illegal act
of actions such as piracy (search on youtube "crack microsoft offfice
2010" to see what I mean!) will almost cease,

Regards
Anthony Easthope


On Mon, 23 Jul 2012, at 09:03 PM, Don Parris wrote:

I would like to take something of a straw poll, if that's ok.  I simply
want to know whether any of you have shared documents using the ODF
format
with MS Office users (preferably in a business environment), and what was
the reaction?  What problems

I am not seeking advice on how to share documents with MS Office users.
  Nor am I interested in an in-depth analysis of why one might experience
problems in sharing such documents.  I simply want to know your
experience.

I have been sharing a simple spreadsheet document between LO (at home)
and
MSO (at work) in the OD format.  The experience has been interesting on
the
MS Office side of it.  I get error messages (that don't seem to be real
errors), and if I choose the "repair" option, it claims to fix the
errors,
and even gives me a link to click to see the list of alleged corrections.
  The list is just a near-empty XML document.  And to save a document in
  ODF
raises a warning *every single time*, with no opportunity to say "stop
warning me".

I know most of us still have to deal with both suites.  I just wonder if
anyone else (how many???) has experienced similar issues.

Thanks,
Don
--
D.C. Parris, FMP, Linux+, ESL Certificate
Minister, Security/FM Coordinator, Free Software Advocate
http://dcparris.net/

GPG Key ID: F5E179BE

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






--
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: New Zealand connection, was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

[Russell Wilson]

try  starting with something like 1/4 population of New York, 1000 times its 
surface area, and 1/4 of 1% of its financial worth

Russell
Dunedin, New Zealand




>
> From: James Knott 
>To: users@global.libreoffice.org 
>Sent: Wednesday, 25 July 2012 1:57 AM
>Subject: Re: New Zealand connection, was Fw: Re: [libreoffice-users] now can 
>Purchase a NA-DVD
> 
>Tom Davies wrote:
>> Weird.  I assumed it was all done by satellites and that was why the 
>> connection to the outside world had such limited bandwidth and was so slow.
>
>Satellites are so 20th century.  ;-)
>
>Actually, with all the fibre cables that have been laid around the world, I 
>don't understand how NZ could have such poor connections.
>
>
>-- 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: New Zealand connection, was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

[James Knott]

webmaster-Kracked_P_P wrote:
That underwater cable network is used for both phone and Internet 
communication, since phone systems not seem to be converted to digital 
to go through the cables to give more "lines" of communication between 
countries




Are analog trunks still in use anywhere?  The phone system has been 
digital for many years, long before there was an Internet.  It'd have to 
be an extremely old cable to require analog trunks. Anything running 
over fibre would most certainly be digital.




--
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: New Zealand connection, was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

[James Knott]

Tom Davies wrote:

Weird.  I assumed it was all done by satellites and that was why the connection 
to the outside world had such limited bandwidth and was so slow.


Satellites are so 20th century.  ;-)

Actually, with all the fibre cables that have been laid around the 
world, I don't understand how NZ could have such poor connections.



--
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: LibO 3.6.0.2 - Calc: date notation

[Joep L. Blom]

On 24-07-12 00:41, Jay Lozier wrote:

On 07/23/2012 05:18 PM, Joep L. Blom wrote:

On 23-07-12 21:02, Andreas Säger wrote:

Am 23.07.2012 14:44, Guy Voets wrote:

Hi folks,



I resent the US way of ISO 8601. We Dutch and other Europeans use the
more logical sequence of day-month-year instead of the illogical
year-month-day.(most important first, least important last: very often
the year can be missed).

The standard US date convention is even less logical than ymd or dmy it
is mdy. Ymd and dmy both have a progression that makes sense. I live in
the US.


planas,
I don't envy you!
Joep



--
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-election of the TDF Membership Committee

[Tom Davies]

Hi :)
This is totally awesome imo.  Quite a few of us never made it to becoming 
members so we might have some issues with it but basically i think this is all 
quite awesome.  

Most organisations i have ever heard of that intended to become "community led" 
never quite got this far.  They almost invariably got stuck with day-to-day 
problems and delayed this step towards truely becoming what they intended.  

There seems to be a slight gender imbalance at the top despite many of the 
lists having a significant number of their best people being non-male.  Jean, 
Hazel (docs), Regina (on this list), Eliane (marketing), Sophia (BoD) and 
others.  I really hope that some step forwards to give this organisation a bit 
more balance and help by diversifying the ideas that reach the top layers of 
TDF and help strengthen TDF by being part of it at such high levels.  

Regards from
Tom :)  


--- On Tue, 24/7/12, Thorsten Behrens  wrote:

From: Thorsten Behrens 
Subject: [tdf-announce] Re-election of the TDF Membership Committee
To: annou...@documentfoundation.org
Date: Tuesday, 24 July, 2012, 13:52

Dear supporters of The Document Foundation,

after the election of the board, and the formal establishing of TDF
earlier this year, it is now time to seat the last body of our entity
with people elected by the members of The Document Foundation.

To facilitate that, all seat holders of our initial membership
committee safe two have now resigned, giving the board the
opportunity to hold a re-election according to § 12 III of our
statutes.

The board hereby announces elections to the MC, starting             

 2012-09-09 00:00 UTC

and lasting until

 2012-09-16 23:59 UTC

Nomination period for candidates will open

 2012-08-10 00:00 UTC.

All members of The Document Foundation as of 2012-07-01 are eligible
to vote, and to run for a seat. Members may self-nominate. 

With best regards,

-- 
Thorsten Behrens, Director, Deputy Chairman of the Board
The Document Foundation, Zimmerstr. 69, 10117 Berlin, Germany
Rechtsfähige Stiftung des bürgerlichen Rechts
Legal details: http://www.documentfoundation.org/imprint

-- 
Unsubscribe instructions: E-mail to announce+h...@documentfoundation.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
List archive: http://listarchives.documentfoundation.org/www/announce/


-- 
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: Re: SQL statement in Base query

[Jay Lozier]

On 07/24/2012 03:06 AM, Tom Davies wrote:

Hi :)
If only it were possible to somehow communicate with people from the various 
back-end projects perhaps even ask them to write-up a brief sub-chapter on how 
to use their back-end in conjunction with Base.  I wonder if any of them know 
anything about the use of Sql in their projects.

The BoD want to sit&wait rather than be pro-active about this sort of 
collaboration.

Regards from
Tom :)
Actually most users of different backend db will be familiar with the 
SQL version of that backend. What users need are two things: a connector 
between Base and the backend and instructions on connecting to that backend.


SQL is the standard query language for relational databases so if one 
writes queries for a relational database one should know a dialect of 
SQL. SQL has a published international standard that db developers 
follow. The problem is that each developer will add non-standard 
extensions for their db making the resulting code possibly not portable. 
An example is loading/exporting data from a file into a database is 
defined in the SQL specifications so each db has its extension to do the 
same thing. Each extension needs the same information but has a 
different syntax for the command.



--- On Mon, 23/7/12, Dan  wrote:

From: Dan 
Subject: Re: [libreoffice-users] Re: Re: SQL statement in Base query
To: users@global.libreoffice.org
Date: Monday, 23 July, 2012, 22:54

Ferry Toth wrote:

Did you try with another database as a backend? I like postgres as a
backend a lot.

Ferry

   I am writing a chapter of the Base Guide that includes using SQL
in the Query Design dialog. Chapter 8 of the Base Guides covers using
HSQLDB 2.2.8, MySQL, and PostgreSQL as back ends. So, I am not there
quite yet. It seems that because Base uses HSQLDB 1.8, it does not
conform with the user guide for the database engine it uses.
   When I get to that point, I will need to research how each of
these backends use SQL.
--Dan


Dan schreef op wo 18-07-2012 om 16:40 [-0400]:


Andreas Säger wrote:

On this simple level I would consider HSQLDB as free of bugs whereas the
primitive Base parser fails in many different ways.
Did you try the direct SQL mode (SQL view, menu:Edit>Run SQL directly)? If
you get reasonable result in direct mode, it is one of many bugs in the
Base's SQL parser.

--
View this message in context: 
http://nabble.documentfoundation.org/SQL-statement-in-Base-query-tp3996273p3996282.html
Sent from the Users mailing list archive at Nabble.com.


That is the one thing that I forgot to mention: I get the same
message when using direct SQL mode. I even tried using Tools > SQL, but
with the same message.

--Dan








--
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] Migrating from Windows; take it slow

[Tom Davies]

Hi :)
That sounds the perfect way to try it.  

Tim (Webmaster at Kracked Press) made a good point about trying LiveCds to just 
test-drive various distros.  Trying a few is really ideal.  

Ubuntu might be a good one to start with but it is designed to be comparable 
with the latest Windows so it is often more heavy and bloated than other 
distros.  Fedora is quite good because it also tries to be quite plug&play but 
it's often the experimental cutting-edge and used as the test-bed for trying 
apps ahead of other distros (well, ahead of Redhat at least).  Anyway the best 
thing is to try a few distros to see what works best for you on your machine 
and then install it.  All distros cover the middle-ground and a wide-spread of 
different machines but each distro seems slightly better at certain wacky 
combinations of real-world machines.  Does anyone really have a 'typical' 
machine in a 'normal' set-up??  

I really wish Windows had an equivalent of the LiveCd session that almost every 
distro seems to have these days.  I think if i did internet banking i would 
want to always do it from a LiveCd and thus leave no trace of it on which-ever 
machine.  

Regards from
Tom :)  



--- On Tue, 24/7/12, Chaim Seymour  wrote:

From: Chaim Seymour 
Subject: Re: [libreoffice-users] Migrating from Windows; take it slow
To: users@global.libreoffice.org
Date: Tuesday, 24 July, 2012, 14:02

Hi

I can offer another option, which I find very satisfactory. My previous
laptop had windows vista and was unsatisfactory. When I bought a new
computer (with Windows 7), I formatted the disk on the old computer and
installed Linux. I tried 2 or 3 different linux packages and since my
computer was weak, I settled for Fedora which seems to use less resources
than Ubuntu.

The computer used to get very hot with Vista, but behaves much better with
Linux.

I use both laptops in parallel, but tend to use the Linux more.

Chaim

On 24 July 2012 12:36, Keith Bainbridge  wrote:

> On Sun, 22 Jul 2012 13:41:59 -0400 webmaster-Kracked_P_P
>  wrote:
> > Anyone who really wants to learn how to use Linux as a replacement
> > for Windows, try dual booting a system if you do not have a spare one
> > to try Linux with as its only OS.
>
>
> G'day.
>
>
> The other option for the odd trip back to windows is virtualisation.
> Mostly, you can tell the system to let windows use a device as if you
> had booted into windows
>
> Regards
>
>
> Keith Bainbridge
> PO Box 324
> BELMONT Vic 3216 Australia
>  +61 (0)408 522 706
>
> keith.bainbridge.3...@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
>
>


-- 
Chaim Seymour
David Elazar 8
Givat Shemuel 54032
Israel
tel: 972-3-5320560

-- 
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: New Zealand connection, was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

[webmaster-Kracked_P_P]

Mostly it is fiber/copper for world-wide communication.
That underwater cable network is used for both phone and Internet 
communication, since phone systems not seem to be converted to digital 
to go through the cables to give more "lines" of communication between 
countries, i.e. more phone connections between people.  Long distance is 
now mostly Internet-based since it cost less to send phone through the 
communication networks between countries in a Internet-based digital 
phone system.  That is what makes having a call center in India for a US 
based company so much as a viable option, cheap person to call center 
calling. If it was the old style phone connections, it would be too 
expensive.


SO
now there is a set of underwater cables between large land masses in the 
world, including island nations large enough, like New Zealand.  A few 
years back, the cable running from the west coast of the US, down to 
South America, was tapped to give more options to a Central American 
country.  They we using the cable connection on the eastern side of the 
country that was much older and over-taxed with users.  This worked, but 
that tap reduced "bandwidth" to the countries to the south.  But, the 
good part was if there was a problem with the cable to the north of the 
tap, the countries south of that problem could have their communications 
diverted through the Central American country's tap to the Caribbean 
cable network.


As for satellites, it is a more expensive route to go for digital 
communications.  You need to have a powerful uplink and such on your 
end, but there are limits to how much bandwidth can be sent through a 
satellite nowadays. Also the "lag time" for satellite can be up to 15 
seconds from ground station through a satellite to the ground station.


On 07/24/2012 08:44 AM, Tom Davies wrote:

Hi :)
Weird.  I assumed it was all done by satellites and that was why the connection 
to the outside world had such limited bandwidth and was so slow.

I remember a few years ago a ship in the meditteranean accidentally ripped up 
THE single cable connecting Asia to the rest of the world!  or least the 
middle-east(ish) part of Asia.  Tons of people were having serious problems 
with speed chess (less than 5min for an entire game).

Regards from
Tom :)


--- On Tue, 24/7/12, Anthony Easthope  wrote:

From: Anthony Easthope 
Subject: Re: [libreoffice-users] now can Purchase a NA-DVD
To: users@global.libreoffice.org
Date: Tuesday, 24 July, 2012, 10:38

I was doing some reading about New Zealand's connection to the world and
it turns out we down under tap into some underwater fiber cable and that
the Government for some reason hires it from the US government, anyway
somewhere in the agreement it mentions that NZ can't exceed a ceartin
limit otherwise it would cook the service or something like that, anyway
I am writing this in a hurry as some one else wants the Mac so ill see
if i can post the link at a later date!

On Sun, 22 Jul 2012, at 02:06 PM, Tom Davies wrote:

Hi again (sorry for the double-posting)  :)

The issue about New Zealand's connection to the rest of the world cropped
up years ago in Ubuntu.  I think either Universities there or the
authorities or someone ran a big hosting site to mirror "the essentials"
and somehow Ubuntu managed to get mirrored on that.  Server-to-server
'up'-loading (or is it downloading or cross-loading?) should be far
faster than going through a domestic route!

I think the Ubuntu crowd discussed posting physical media to get the bulk
done more easily.
Regards from
Tom :)


--- On Sat, 21/7/12, webmaster-Kracked_P_P 
wrote:

From: webmaster-Kracked_P_P 
Subject: Re: [libreoffice-users] now can Purchase a NA-DVD
To: users@global.libreoffice.org
Date: Saturday, 21 July, 2012, 23:18


DO you have a broadband Internet connection?  The .iso file is listed
here.
http://www.libreoffice.org/download/?type=box&version=3.5.5
If you do not have broadband connection, there should be a way for you to
get a copy from some source.  I have shipped one to Malta from the USA,
but do not like to spend my own money on shipping, most of the time.

--

Here is a link to the Online version of the DVD. [actually to the Install
page]
http://libreoffice-na.us/English-3.5-installs/install.html

Browse this site and you will find all of the files and such on the DVD.
The online site tends to get updated more often than the physical media
or the .iso file does, but still it will give you a look at the DVD.

Right now, the only real updates to the online version [same as the
physical one really] is the fact that there are 2 more chapters in Draw
online than the one that can be bought or the .iso file to be downloaded.

Mostly there are the documentation, the 180+ dictionaries, the
extensions, templates, artwork, the extra free packages, etc., etc..  I
did not fee that a DVD should contain only the basic install files for
LibreOffice.  That would be a waste of a DVD. So it got fil

Re: [libreoffice-users] Migrating from Windows; take it slow

[Chaim Seymour]

Hi

I can offer another option, which I find very satisfactory. My previous
laptop had windows vista and was unsatisfactory. When I bought a new
computer (with Windows 7), I formatted the disk on the old computer and
installed Linux. I tried 2 or 3 different linux packages and since my
computer was weak, I settled for Fedora which seems to use less resources
than Ubuntu.

The computer used to get very hot with Vista, but behaves much better with
Linux.

I use both laptops in parallel, but tend to use the Linux more.

Chaim

On 24 July 2012 12:36, Keith Bainbridge  wrote:

> On Sun, 22 Jul 2012 13:41:59 -0400 webmaster-Kracked_P_P
>  wrote:
> > Anyone who really wants to learn how to use Linux as a replacement
> > for Windows, try dual booting a system if you do not have a spare one
> > to try Linux with as its only OS.
>
>
> G'day.
>
>
> The other option for the odd trip back to windows is virtualisation.
> Mostly, you can tell the system to let windows use a device as if you
> had booted into windows
>
> Regards
>
>
> Keith Bainbridge
> PO Box 324
> BELMONT Vic 3216 Australia
>  +61 (0)408 522 706
>
> keith.bainbridge.3...@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
>
>


-- 
Chaim Seymour
David Elazar 8
Givat Shemuel 54032
Israel
tel: 972-3-5320560

-- 
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] Migrating from Windows; take it slow

[webmaster-Kracked_P_P]

The real problem for many people is the hardware and software needs.

I still have some USB hardware that does not work on Linux.  No working 
drivers.


Then there is the problem of having to use certain software, for work or 
pleasure, that you either cannot find a good Linux alternative or you 
MUST use.  There is the option of WINE, but some software seems not to 
want to work under that.  Personally, I have never gotten WINE to work 
for me, but that is just me.


I made a personal choice and used Ubuntu when I bought my last "default" 
desktop.  I had to adjust to some of the software though.  I still have 
the Windows laptops [single or dual boot] to deal with the need Windows 
software.  My Epson printer prints on DVD media, but I have not found 
any replacement for its Windows software to do that work.  There is a 
graphic program that I bought for Windows that works much easier that 
GIMP, so if I have trouble with an image/graphics, I need to work on it 
with that Windows software.  BUT, most most of the work I do, Ubuntu and 
the free software for it works for me.


So, even though I use Ubuntu as my default system, I still need to keep 
Windows around for those things that I cannot find drivers and software 
version for in Linux.


Even version of Linux differ.
The scanning part of my Epson printer does not work at all with Ubuntu 
10.04, but will work on 12.04.  I updated the software and drivers I use 
for it on my 10.04 system, but still not luck. Something in 12.04 makes 
it work that I seem not to be able to get with 10.04.




On 07/24/2012 08:37 AM, Tom Davies wrote:

Hi :)
Virtualisation is good but if it's a question of drivers for a particular piece 
of hardware then it might not work.  It might, but it if the underlaying OS 
can't see it then i don't see how the virtual machine that is sitting on top of 
that OS is supposed to see it.

It is possible to use emulators or even better is WINE (stands for "Wine Is Not an 
Emulator") but that is a lot more sophisticated and hence slightly harder to set-up 
initially for some programs.

The worst way around is to have a Gnu&Linux in a virtual machine on Windows because 
then the stability of the unix-based systems is sitting on top of the flakiness of 
Windows so you end-up adding the worst of each OS.  A dual-boot means each is directly 
on bare metal so it gives a fair comparison.  Windows inside a virtual machine inside 
Gnu&Linux sounds like it's going to be ver stable too.

Ubuntu and Puppy and possibly a few others have a magic way of installing inside Windows.  It 
avoids 1 of the layers between bare-metal and the OS because it avoids the virtual machine bit.  
The Ubuntu magic way is called the "Wubi".  Again you are adding the worst of each OS and 
in addition the "drives" are really compressed files but it's fast and easy to install 
and many people keep using such things for years with no problems.  Obviously it's not made by 
Microsoft and so every once in a while someone has troubles with Windows trying to reject it but 
that is fairly rare.  We used to get about 1 question per month that was specifically about the 
Wubi and solved by moving to a dual-boot.


So, there are tons of different ways of avoiding wiping Windows and that seems 
to be the best way to make the migration much more gentle and less stressful.  
Throwing yourself to the lions is the fastest way to learn to deal with lions 
(or die) but there is no real need to create so much stress.
Regards from
Tom :)


--- On Tue, 24/7/12, Simon Cropper  wrote:

From: Simon Cropper 
Subject: Re: [libreoffice-users] Migrating from Windows; take it slow
To: users@global.libreoffice.org
Date: Tuesday, 24 July, 2012, 11:05

On 24/07/12 19:36, Keith Bainbridge wrote:

On Sun, 22 Jul 2012 13:41:59 -0400 webmaster-Kracked_P_P
 wrote:

Anyone who really wants to learn how to use Linux as a replacement
for Windows, try dual booting a system if you do not have a spare one
to try Linux with as its only OS.


G'day.


The other option for the odd trip back to windows is virtualisation.
Mostly, you can tell the system to let windows use a device as if you
had booted into windows

Regards


Keith Bainbridge
PO Box 324
BELMONT Vic 3216 Australia
+61 (0)408 522 706

keith.bainbridge.3...@gmail.com


Visualization also has the added benefit of a shared clipboard and being
able to work on the same data at the same time (well nearly).




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

New Zealand connection, was Fw: Re: [libreoffice-users] now can Purchase a NA-DVD

[Tom Davies]

Hi :)
Weird.  I assumed it was all done by satellites and that was why the connection 
to the outside world had such limited bandwidth and was so slow.  

I remember a few years ago a ship in the meditteranean accidentally ripped up 
THE single cable connecting Asia to the rest of the world!  or least the 
middle-east(ish) part of Asia.  Tons of people were having serious problems 
with speed chess (less than 5min for an entire game).  

Regards from
Tom :)  


--- On Tue, 24/7/12, Anthony Easthope  wrote:

From: Anthony Easthope 
Subject: Re: [libreoffice-users] now can Purchase a NA-DVD
To: users@global.libreoffice.org
Date: Tuesday, 24 July, 2012, 10:38

I was doing some reading about New Zealand's connection to the world and
it turns out we down under tap into some underwater fiber cable and that
the Government for some reason hires it from the US government, anyway
somewhere in the agreement it mentions that NZ can't exceed a ceartin
limit otherwise it would cook the service or something like that, anyway
I am writing this in a hurry as some one else wants the Mac so ill see
if i can post the link at a later date!

On Sun, 22 Jul 2012, at 02:06 PM, Tom Davies wrote:
> Hi again (sorry for the double-posting)  :)
> 
> The issue about New Zealand's connection to the rest of the world cropped
> up years ago in Ubuntu.  I think either Universities there or the
> authorities or someone ran a big hosting site to mirror "the essentials"
> and somehow Ubuntu managed to get mirrored on that.  Server-to-server
> 'up'-loading (or is it downloading or cross-loading?) should be far
> faster than going through a domestic route!  
> 
> I think the Ubuntu crowd discussed posting physical media to get the bulk
> done more easily.  
> Regards from
> Tom :)  
> 
> 
> --- On Sat, 21/7/12, webmaster-Kracked_P_P 
> wrote:
> 
> From: webmaster-Kracked_P_P 
> Subject: Re: [libreoffice-users] now can Purchase a NA-DVD
> To: users@global.libreoffice.org
> Date: Saturday, 21 July, 2012, 23:18
> 
> 
> DO you have a broadband Internet connection?  The .iso file is listed
> here.
> http://www.libreoffice.org/download/?type=box&version=3.5.5
> If you do not have broadband connection, there should be a way for you to
> get a copy from some source.  I have shipped one to Malta from the USA,
> but do not like to spend my own money on shipping, most of the time.
> 
> --
> 
> Here is a link to the Online version of the DVD. [actually to the Install
> page]
> http://libreoffice-na.us/English-3.5-installs/install.html
> 
> Browse this site and you will find all of the files and such on the DVD. 
> The online site tends to get updated more often than the physical media
> or the .iso file does, but still it will give you a look at the DVD.
> 
> Right now, the only real updates to the online version [same as the
> physical one really] is the fact that there are 2 more chapters in Draw
> online than the one that can be bought or the .iso file to be downloaded.
> 
> Mostly there are the documentation, the 180+ dictionaries, the
> extensions, templates, artwork, the extra free packages, etc., etc..  I
> did not fee that a DVD should contain only the basic install files for
> LibreOffice.  That would be a waste of a DVD. So it got filled with a lot
> of things that I [and others] thought a user might want to have with
> him/her on a DVD so that they did not have to go looking for it
> elsewhere.  I must have 99% of the dictionaries that can work with
> LibreOffice, unless you get them via any language packages, like you need
> for a Linux install.
> 
> 
> On 07/21/2012 05:44 PM, Anthony Easthope wrote:
> > I am curious as to what the 2gb of extras contain! I am considering
> > purchasing a dvd but not sure if it is able to be shipped to New Zealand
> > if it could that would be great!
> > 
> > On Sat, 21 Jul 2012, at 04:07 AM, Fabian Rodriguez wrote:
> >> On 07/20/2012 10:08 AM, webmaster-Kracked_P_P wrote:
> >>> Thanks to Drew, we now have a service that will "print-on-demand" a
> >>> copy of the LibreOffice North American Community DVD - version 3.5.5.
> >>> 
> >>> Here is a link for a direct retail page:
> >>> http://kunaki.com/sales.asp?PID=PX00B1FF2L
> >>> **Kunaki handles all the payment collection.**
> >>> 
> >> [...]
> >> 
> >> Well done, Drew! I had been researching manufacturers, this is the same
> >> used by Raphael Hertzog to distribute his Debian remix:
> >> http://raphaelhertzog.com/products/debian-cd-dvd/
> >> 
> >> I had that in my personal ToDo for a while
> >> (http://wiki.documentfoundation.org/User:MagicFab/LibODVD#ToDo), glad
> >> you're validating it. If/when you have a sample of what they ship, it'd
> >> be important to have pictures. I'll order one to carry it and use as a
> >> demo. I plan to finish my local design and use the same ship by
> >> september.
> >> 
> >> Cheers,
> >> 
> >> Fabian Rodriguez
> >> http://libreoffice.magicfab.ca
> >> 
> >> 
> >> 

Re: [libreoffice-users] Migrating from Windows; take it slow

[Tom Davies]

Hi :)
Virtualisation is good but if it's a question of drivers for a particular piece 
of hardware then it might not work.  It might, but it if the underlaying OS 
can't see it then i don't see how the virtual machine that is sitting on top of 
that OS is supposed to see it.  

It is possible to use emulators or even better is WINE (stands for "Wine Is Not 
an Emulator") but that is a lot more sophisticated and hence slightly harder to 
set-up initially for some programs.  

The worst way around is to have a Gnu&Linux in a virtual machine on Windows 
because then the stability of the unix-based systems is sitting on top of the 
flakiness of Windows so you end-up adding the worst of each OS.  A dual-boot 
means each is directly on bare metal so it gives a fair comparison.  Windows 
inside a virtual machine inside Gnu&Linux sounds like it's going to be ver 
stable too.  

Ubuntu and Puppy and possibly a few others have a magic way of installing 
inside Windows.  It avoids 1 of the layers between bare-metal and the OS 
because it avoids the virtual machine bit.  The Ubuntu magic way is called the 
"Wubi".  Again you are adding the worst of each OS and in addition the "drives" 
are really compressed files but it's fast and easy to install and many people 
keep using such things for years with no problems.  Obviously it's not made by 
Microsoft and so every once in a while someone has troubles with Windows trying 
to reject it but that is fairly rare.  We used to get about 1 question per 
month that was specifically about the Wubi and solved by moving to a dual-boot. 
  


So, there are tons of different ways of avoiding wiping Windows and that seems 
to be the best way to make the migration much more gentle and less stressful.  
Throwing yourself to the lions is the fastest way to learn to deal with lions 
(or die) but there is no real need to create so much stress.  
Regards from
Tom :)   


--- On Tue, 24/7/12, Simon Cropper  wrote:

From: Simon Cropper 
Subject: Re: [libreoffice-users] Migrating from Windows; take it slow
To: users@global.libreoffice.org
Date: Tuesday, 24 July, 2012, 11:05

On 24/07/12 19:36, Keith Bainbridge wrote:
> On Sun, 22 Jul 2012 13:41:59 -0400 webmaster-Kracked_P_P
>  wrote:
>> Anyone who really wants to learn how to use Linux as a replacement
>> for Windows, try dual booting a system if you do not have a spare one
>> to try Linux with as its only OS.
>
>
> G'day.
>
>
> The other option for the odd trip back to windows is virtualisation.
> Mostly, you can tell the system to let windows use a device as if you
> had booted into windows
>
> Regards
>
>
> Keith Bainbridge
> PO Box 324
> BELMONT Vic 3216 Australia
>   +61 (0)408 522 706
>
> keith.bainbridge.3...@gmail.com
>

Visualization also has the added benefit of a shared clipboard and being 
able to work on the same data at the same time (well nearly).

-- 
Cheers Simon

    Simon Cropper - Open Content Creator

    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

[libreoffice-users] Batch conversion from csv

[Michael Crider]

I have csv files generated from an SQL command-line utility that I am 
trying to convert to dBase using the batch converter. If I open the csv 
in LibreOffice, a default option is "Quoted fields as text", and if it 
is saved as another filetype, those fields remain text, but when using 
the batch converter it will bring all numbers in as numbers, even if 
they are quoted. The command I am using is:

libreoffice --headless --invisible --convert-to dbf *.csv
I have the same results if I convert to other spreadsheet types. Is 
there a way to tell the batch converter to convert "quoted fields as text"?



--
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] Do You Share ODF Documents With MS Office Users?

[Johnny Rosenberg]

2012/7/24 Anthony Easthope :
> I have a comment on the error dialogue.
> I once got into a heated debate with my ICT teacher earlier on this year
> and in the debate the comment was made by her that: "Microsoft with that
> error dialogue are really just trying to insinuate that their products
> are superior to others"
>
> I in a way kind of agree with her because Microsoft have always insisted
> that the MO range of extensions should be the industry standard. Due to
> this sort of approach I find roadblocks when trying to submit work in
> .ODT format to institutions such as NZQA (New Zealand Qualifications
> Association). they keep getting angry at me for using a so called "UN
> recognized file format". I have now managed to persuade my school and
> some other institutions that for a truly open submission and form of
> collaboration that the use of ODF standards should be encouraged. the
> major problem with persuasion is that people are not willing to make the
> change is due to the lack of knowledge of understanding of opensource
> and how it can really become better than commercial counterparts.
>
> With education there can be a global revolution in the sense that open
> source programs such as LO will become commonplace and the illegal act
> of actions such as piracy (search on youtube "crack microsoft offfice
> 2010" to see what I mean!) will almost cease,
>
> Regards
> Anthony Easthope
>
>
> On Mon, 23 Jul 2012, at 09:03 PM, Don Parris wrote:
>> I would like to take something of a straw poll, if that's ok.  I simply
>> want to know whether any of you have shared documents using the ODF
>> format
>> with MS Office users (preferably in a business environment), and what was
>> the reaction?  What problems
>>
>> I am not seeking advice on how to share documents with MS Office users.
>>  Nor am I interested in an in-depth analysis of why one might experience
>> problems in sharing such documents.  I simply want to know your
>> experience.
>>
>> I have been sharing a simple spreadsheet document between LO (at home)
>> and
>> MSO (at work) in the OD format.  The experience has been interesting on
>> the
>> MS Office side of it.  I get error messages (that don't seem to be real
>> errors), and if I choose the "repair" option, it claims to fix the
>> errors,
>> and even gives me a link to click to see the list of alleged corrections.
>>  The list is just a near-empty XML document.  And to save a document in
>>  ODF
>> raises a warning *every single time*, with no opportunity to say "stop
>> warning me".
>>
>> I know most of us still have to deal with both suites.  I just wonder if
>> anyone else (how many???) has experienced similar issues.
>>
>> Thanks,
>> Don
>> --
>> D.C. Parris, FMP, Linux+, ESL Certificate
>> Minister, Security/FM Coordinator, Free Software Advocate
>> http://dcparris.net/
>> 
>> GPG Key ID: F5E179BE
>>
>> --
>> 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
>>
>
>
> --
>
>   antiso...@myopera.com

Whenever I share office files (mostly spreadsheets) with people I
export them to PDF first. People are not supposed to edit my files
(besides, the next version of MS Office seems to be able to open PDF
files and edit them as if they were MS Office documents). Most of the
people I know have LibreOffice or OpenOffice.org installed, so it
could happen that I share an ODS file or two… I rarely use Writer.
When I write something, it's often things that I need to remember,
small notes of different kinds, and then I find things like Tomboy
Notes (GNote if Mono is not an option) more intuitive. I have never
used Impress, and I never will. Just hate when people use presentation
software.



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] Migrating from Windows; take it slow

[Simon Cropper]

On 24/07/12 19:36, Keith Bainbridge wrote:

On Sun, 22 Jul 2012 13:41:59 -0400 webmaster-Kracked_P_P
 wrote:

Anyone who really wants to learn how to use Linux as a replacement
for Windows, try dual booting a system if you do not have a spare one
to try Linux with as its only OS.



G'day.


The other option for the odd trip back to windows is virtualisation.
Mostly, you can tell the system to let windows use a device as if you
had booted into windows

Regards


Keith Bainbridge
PO Box 324
BELMONT Vic 3216 Australia
  +61 (0)408 522 706

keith.bainbridge.3...@gmail.com



Visualization also has the added benefit of a shared clipboard and being 
able to work on the same data at the same time (well nearly).


--
Cheers Simon

   Simon Cropper - Open Content Creator

   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] Migrating from Windows; take it slow

[Keith Bainbridge]

On Sun, 22 Jul 2012 13:41:59 -0400 webmaster-Kracked_P_P
 wrote:
> Anyone who really wants to learn how to use Linux as a replacement
> for Windows, try dual booting a system if you do not have a spare one
> to try Linux with as its only OS.


G'day.


The other option for the odd trip back to windows is virtualisation.
Mostly, you can tell the system to let windows use a device as if you
had booted into windows

Regards


Keith Bainbridge
PO Box 324
BELMONT Vic 3216 Australia
 +61 (0)408 522 706

keith.bainbridge.3...@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] now can Purchase a NA-DVD

[Anthony Easthope]

I was doing some reading about New Zealand's connection to the world and
it turns out we down under tap into some underwater fiber cable and that
the Government for some reason hires it from the US government, anyway
somewhere in the agreement it mentions that NZ can't exceed a ceartin
limit otherwise it would cook the service or something like that, anyway
I am writing this in a hurry as some one else wants the Mac so ill see
if i can post the link at a later date!

On Sun, 22 Jul 2012, at 02:06 PM, Tom Davies wrote:
> Hi again (sorry for the double-posting)  :)
> 
> The issue about New Zealand's connection to the rest of the world cropped
> up years ago in Ubuntu.  I think either Universities there or the
> authorities or someone ran a big hosting site to mirror "the essentials"
> and somehow Ubuntu managed to get mirrored on that.  Server-to-server
> 'up'-loading (or is it downloading or cross-loading?) should be far
> faster than going through a domestic route!  
> 
> I think the Ubuntu crowd discussed posting physical media to get the bulk
> done more easily.  
> Regards from
> Tom :)  
> 
> 
> --- On Sat, 21/7/12, webmaster-Kracked_P_P 
> wrote:
> 
> From: webmaster-Kracked_P_P 
> Subject: Re: [libreoffice-users] now can Purchase a NA-DVD
> To: users@global.libreoffice.org
> Date: Saturday, 21 July, 2012, 23:18
> 
> 
> DO you have a broadband Internet connection?  The .iso file is listed
> here.
> http://www.libreoffice.org/download/?type=box&version=3.5.5
> If you do not have broadband connection, there should be a way for you to
> get a copy from some source.  I have shipped one to Malta from the USA,
> but do not like to spend my own money on shipping, most of the time.
> 
> --
> 
> Here is a link to the Online version of the DVD. [actually to the Install
> page]
> http://libreoffice-na.us/English-3.5-installs/install.html
> 
> Browse this site and you will find all of the files and such on the DVD. 
> The online site tends to get updated more often than the physical media
> or the .iso file does, but still it will give you a look at the DVD.
> 
> Right now, the only real updates to the online version [same as the
> physical one really] is the fact that there are 2 more chapters in Draw
> online than the one that can be bought or the .iso file to be downloaded.
> 
> Mostly there are the documentation, the 180+ dictionaries, the
> extensions, templates, artwork, the extra free packages, etc., etc..  I
> did not fee that a DVD should contain only the basic install files for
> LibreOffice.  That would be a waste of a DVD. So it got filled with a lot
> of things that I [and others] thought a user might want to have with
> him/her on a DVD so that they did not have to go looking for it
> elsewhere.  I must have 99% of the dictionaries that can work with
> LibreOffice, unless you get them via any language packages, like you need
> for a Linux install.
> 
> 
> On 07/21/2012 05:44 PM, Anthony Easthope wrote:
> > I am curious as to what the 2gb of extras contain! I am considering
> > purchasing a dvd but not sure if it is able to be shipped to New Zealand
> > if it could that would be great!
> > 
> > On Sat, 21 Jul 2012, at 04:07 AM, Fabian Rodriguez wrote:
> >> On 07/20/2012 10:08 AM, webmaster-Kracked_P_P wrote:
> >>> Thanks to Drew, we now have a service that will "print-on-demand" a
> >>> copy of the LibreOffice North American Community DVD - version 3.5.5.
> >>> 
> >>> Here is a link for a direct retail page:
> >>> http://kunaki.com/sales.asp?PID=PX00B1FF2L
> >>> **Kunaki handles all the payment collection.**
> >>> 
> >> [...]
> >> 
> >> Well done, Drew! I had been researching manufacturers, this is the same
> >> used by Raphael Hertzog to distribute his Debian remix:
> >> http://raphaelhertzog.com/products/debian-cd-dvd/
> >> 
> >> I had that in my personal ToDo for a while
> >> (http://wiki.documentfoundation.org/User:MagicFab/LibODVD#ToDo), glad
> >> you're validating it. If/when you have a sample of what they ship, it'd
> >> be important to have pictures. I'll order one to carry it and use as a
> >> demo. I plan to finish my local design and use the same ship by
> >> september.
> >> 
> >> Cheers,
> >> 
> >> Fabian Rodriguez
> >> http://libreoffice.magicfab.ca
> >> 
> >> 
> >> -- 
> >> 
> >> 
> >> -- 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.documentfound

Re: [libreoffice-users] Do You Share ODF Documents With MS Office Users?

[Anthony Easthope]

I have a comment on the error dialogue.
I once got into a heated debate with my ICT teacher earlier on this year
and in the debate the comment was made by her that: "Microsoft with that
error dialogue are really just trying to insinuate that their products
are superior to others"

I in a way kind of agree with her because Microsoft have always insisted
that the MO range of extensions should be the industry standard. Due to
this sort of approach I find roadblocks when trying to submit work in
.ODT format to institutions such as NZQA (New Zealand Qualifications
Association). they keep getting angry at me for using a so called "UN
recognized file format". I have now managed to persuade my school and
some other institutions that for a truly open submission and form of
collaboration that the use of ODF standards should be encouraged. the
major problem with persuasion is that people are not willing to make the
change is due to the lack of knowledge of understanding of opensource
and how it can really become better than commercial counterparts.

With education there can be a global revolution in the sense that open
source programs such as LO will become commonplace and the illegal act
of actions such as piracy (search on youtube "crack microsoft offfice
2010" to see what I mean!) will almost cease, 

Regards 
Anthony Easthope


On Mon, 23 Jul 2012, at 09:03 PM, Don Parris wrote:
> I would like to take something of a straw poll, if that's ok.  I simply
> want to know whether any of you have shared documents using the ODF
> format
> with MS Office users (preferably in a business environment), and what was
> the reaction?  What problems
> 
> I am not seeking advice on how to share documents with MS Office users.
>  Nor am I interested in an in-depth analysis of why one might experience
> problems in sharing such documents.  I simply want to know your
> experience.
> 
> I have been sharing a simple spreadsheet document between LO (at home)
> and
> MSO (at work) in the OD format.  The experience has been interesting on
> the
> MS Office side of it.  I get error messages (that don't seem to be real
> errors), and if I choose the "repair" option, it claims to fix the
> errors,
> and even gives me a link to click to see the list of alleged corrections.
>  The list is just a near-empty XML document.  And to save a document in
>  ODF
> raises a warning *every single time*, with no opportunity to say "stop
> warning me".
> 
> I know most of us still have to deal with both suites.  I just wonder if
> anyone else (how many???) has experienced similar issues.
> 
> Thanks,
> Don
> -- 
> D.C. Parris, FMP, Linux+, ESL Certificate
> Minister, Security/FM Coordinator, Free Software Advocate
> http://dcparris.net/
> 
> GPG Key ID: F5E179BE
> 
> -- 
> 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
> 


-- 
  
  antiso...@myopera.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] Calc regular expression – Cell reference suggestion

[Johnny Rosenberg]

I have a feature suggestion that I want to discuss to see if I'm the
only one that think this is a good idea or not. I'm not sure I write
to the right list though, but I couldn't find a discuss list for
LibreOffice, I only found one for discussing the Document Foundation…

Anyway, as you all know, at least those of you who use regular
expressions in Calc now and then, there is this [::] syntax for
finding some specific kinds of strings, such as [:almum:] for finding
a letter or a number, [:digit:] for finding a number and so on.
My suggestion is to add two more of those, something like (feel free
to suggest other names for them):
[:cellref:]
[:rangeref:]

[:cellref:] would find things like A1, $A$1, AB$125 and so on. I
believe this expression is equivalent:
\<\$?[:alpha:]{1,2}\$?[:digit:]{1,7}\>
At least it seems to work in my tests.

[:rangeref:] would find references for cell ranges, such as A1:B5,
X$3:$AT$32658 and so on. Currently I guess you need to search for
something like:
\<\$?[:alpha:]{1,2}\$?[:digit:]{1,7}\>:\<\$?[:alpha:]{1,2}\$?[:digit:]{1,7}\>

What do you think about this?

I can see some complications, though: This would only work with the
”Calc A1” setting in Tools → Options… → LibreOffice Calc → Formula →
Formula Syntax. For example, it would be complicated to find something
like A:A, which is valid with the Excel A1 syntax:
\<\$?[:alpha:]{1,2}\$?[:digit:]{0,7}\>:\<\$?[:alpha:]{1,2}\$?[:digit:]{0,7}\>
This would find A:A, but also A1:A and A:A1, which I don't think is a
valid syntax… But still, most people use the Calc A1 syntax, don't
they?

Also I didn't include syntax like MyTable.A1:B5 and more, but maybe
that can be done easily. Also references to cells and cell ranges
other files could perhaps be included.



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] Which template categories are built-in, how to name custom ones?

[Tom Davies]

Hi :)
Yes, Regina's answer was much better.  As always.  

There are a few things that are not quite perfect in LibreOffice and people 
have sometimes managed to get so annoyed about a certain thing that they do 
re-write it and that improves the project for a lot of people.  

I thought that this might be one of those times but Regina's answer kinda hints 
that the templates categories is not such a mess after all.  I found it best to 
avoid templates in MS Office and have carried that on into LO but it sounds 
like they are worth trying in LO.  The same was true with styles which are a 
huge help for me in LO.  

Regards from
Tom :)  


--- On Mon, 23/7/12, Friedrich W. H. Kossebau  wrote:

From: Friedrich W. H. Kossebau 
Subject: Re: [libreoffice-users] Which template categories are built-in, how to 
name custom ones?
To: users@global.libreoffice.org
Date: Monday, 23 July, 2012, 23:52

Hi Tom,

Am Sonntag, 22. Juli 2012, 13:26:23 schrieb Tom Davies:
> Hi :)
> I think the Docs Team discussed the issue a couple of years ago but i think
> changing it would be tons of hard work for very little gain. 
> 
> I think the names grew almost organically over the previous decade so i
> don't think there is a coherent and consistent decision about the names
> chosen.  I can't really imagine the devs list being particularly interested
> or if they are their new choices might not be brilliant either. 
> 
> It might be worth contacting the devs list to find out how to change the
> names and then perhaps join the docs team to find out if they have good
> naming schemes or even just a few good general ideas

Well, I have been basically curious how to do my own custom categories, not 
enforcing them on all LO users :)

> Just my 2cents as it sounds like you have a good plan already. 

Yes, and after Regina's reply an even better one. Still thanks for your 2cents 
:)

Cheers
Friedrich

-- 
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: LibO 3.6.0.2 - Calc: date notation

[Tom Davies]

Hi :)
The fact of something appearing in a format dialogue box is not really proof of 
that format being used!  I've never seen nor heard of the USA way being used in 
the UK.  Perhaps it's used in the US airbases.  Wouldn't it be a tad confusing 
if both ways were really being used here?  I think you have found a bug in the 
format dialogue but i would be amazed if those dialogues are really specific to 
a locale setting.  
Regards from
Tom :)  


--- On Tue, 24/7/12, Dan  wrote:

From: Dan 
Subject: Re: [libreoffice-users] Re: LibO 3.6.0.2 - Calc: date notation
To: users@global.libreoffice.org
Date: Tuesday, 24 July, 2012, 0:02

     Let me see: open Calc in LO 3.6.0.2 and format a column selecting the 
Category as Date and the Language as English(UK). It does not seem to matter 
what is selected as the Format. (I selected 31/12/99.) Enter 20-7 in a cell. It 
becomes 20/7/12. When 20/7 is entered in a cell of the column, 20/7/12 is the 
result.
     It is a matter of formatting the column, cell, or row for the type of data 
to be placed in the sheet. With the correct format [English(USA)], I can enter 
20-7 in a cell, and it will become Saturday, July 20,2012 or Saturday, 20 July 
2012 depending upon what format I use. (The last one would require selecting 
User-defined Category and the appropriate entries in the Format code box.)
     Ah yes, the "weird" USA way. While I had the Format dialog open with UK as 
the Language, I noticed something in the list of Format examples: MM-DD! If it 
should be DD/MM/YY, then why should it also be MM/DD? OK so the USA way is 
weird, but then so is the British. Check it out.  Chuckle, Chuckle! (From where 
this is located in the Format example list, I think I know why it is this way. 
(ISO 8601) But I could not resist replying to Tom's comment.

--Dan

Tom Davies wrote:
> Hi :)
> I thought the USA way was the amazingly weird
> mm/dd/yy
> 
> Apparently it's important to use / instead of - in order to make sure it's 
> easier to mis-read.  With some people's handwriting an 11 might look like 1/ 
> or vice-versa.
> Regards from
> Tom :)
> 
> 
> --- On Mon, 23/7/12, Joep L. Blom  wrote:
> 
> From: Joep L. Blom 
> Subject: Re: [libreoffice-users] Re: LibO 3.6.0.2 - Calc: date notation
> To: users@global.libreoffice.org
> Cc: "Andreas Säger" 
> Date: Monday, 23 July, 2012, 22:18
> 
> On 23-07-12 21:02, Andreas Säger wrote:
>> Am 23.07.2012 14:44, Guy Voets wrote:
>>> Hi folks,
>>> 
>>> A LibO spreadsheet, made in LibO, Dutch version (no Excel or OOo past).
>>> 
>>>       - In LibO 3.5.5, I used to give in dates as 20-7 and they were
>>> shown as
>>>       20 Jul 12.
>>>       - In LibO 3.6.0.2, if I enter 20-7, 20-7 is shown in the cell.
>>> 
>>> If I enter 20-7-12, the date is inverted into 12 Jul 2020.
>>> So instead of entering 20-7, I now need to enter 12-7-20 to get the
>>> desired
>>> notation 20 Jul 12.
>>> 
>>> Is this a new feature, or a bug?
>>> 
>> 
>> This is just another anti-feature that has been added to Calc against
>> all reason simply because too many inexperienced users who never really
>> used any spreadsheets insisted loudly enough.
>> I will upgrade my LibreOffice 3.5 to ApacheOpenOffice 3.4.1.
>> 
>> 
> I resent the US way of ISO 8601. We Dutch and other Europeans use the
> more logical sequence of day-month-year instead of the illogical
> year-month-day.(most important first, least important last: very often
> the year can be missed).
> Joep
> 
> 
> 



-- 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: Re: SQL statement in Base query

[Tom Davies]

Hi :)
If only it were possible to somehow communicate with people from the various 
back-end projects perhaps even ask them to write-up a brief sub-chapter on how 
to use their back-end in conjunction with Base.  I wonder if any of them know 
anything about the use of Sql in their projects.  

The BoD want to sit&wait rather than be pro-active about this sort of 
collaboration.  

Regards from
Tom :)  


--- On Mon, 23/7/12, Dan  wrote:

From: Dan 
Subject: Re: [libreoffice-users] Re: Re: SQL statement in Base query
To: users@global.libreoffice.org
Date: Monday, 23 July, 2012, 22:54

Ferry Toth wrote:
> Did you try with another database as a backend? I like postgres as a
> backend a lot.
>
> Ferry

      I am writing a chapter of the Base Guide that includes using SQL 
in the Query Design dialog. Chapter 8 of the Base Guides covers using 
HSQLDB 2.2.8, MySQL, and PostgreSQL as back ends. So, I am not there 
quite yet. It seems that because Base uses HSQLDB 1.8, it does not 
conform with the user guide for the database engine it uses.
      When I get to that point, I will need to research how each of 
these backends use SQL.
--Dan

>
> Dan schreef op wo 18-07-2012 om 16:40 [-0400]:
>
>> Andreas Säger wrote:
>>> On this simple level I would consider HSQLDB as free of bugs whereas the
>>> primitive Base parser fails in many different ways.
>>> Did you try the direct SQL mode (SQL view, menu:Edit>Run SQL directly)? If
>>> you get reasonable result in direct mode, it is one of many bugs in the
>>> Base's SQL parser.
>>>
>>> --
>>> View this message in context: 
>>> http://nabble.documentfoundation.org/SQL-statement-in-Base-query-tp3996273p3996282.html
>>> Sent from the Users mailing list archive at Nabble.com.
>>>
>>
>>       That is the one thing that I forgot to mention: I get the same
>> message when using direct SQL mode. I even tried using Tools > SQL, but
>> with the same message.
>>
>> --Dan
>>
>>
>



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

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