Re: [libreoffice-users] XML as mailmerge data source?

[Mark Stanton]

> and yes, Google claims to have found more than 65,000 results ;)

Yes, as I said, I've been looking, and I found lots of "results", but

> But bottom-line will be, convert the XML to CSV or Excel or  ;)

You seem to agree with me that, no, there isn't a way.

Since XML is a wau of structuring data, just like a database is, then this 
seems to be a glaring omission, so glaring I couldn't believe it.

Regards
Mark Stanton
One small step for mankind...



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: [libreoffice-documentation] Re: Getting Started 3.4 full book published

[Tom Davies]

Hi :)
People on the docs team are sometimes subscribed to other lists.  Jean fixed 
the problem so the links do work now.  

It's unusual for a team to make a request for help from the wider LinbreOffice 
community but it seems to be working well this time.
Thanks Tim :)
Many regards from
Tom :)



--- On Fri, 30/3/12, webmaster-Kracked_P_P  wrote:

From: webmaster-Kracked_P_P 
Subject: Re: [libreoffice-users] Re: [libreoffice-documentation] Re: Getting 
Started 3.4 full book published
To: users@global.libreoffice.org
Date: Friday, 30 March, 2012, 15:55

On 03/30/2012 10:19 AM, Marc Paré wrote:
> Hi Tim
> 
> Le 2012-03-30 09:49, webmaster-Kracked_P_P a écrit :
>> 
>> Well there is an error there.
>> Instead of 0115GS34-KeyboardShortcuts.odt [.pdf link as well]
>> 
>> The 3.4.x branch version is the same link for the 3.3.x branch:
>> 
>> http://wiki.documentfoundation.org/images/0/00/0115GS3-KeyboardShortcuts.odt 
>> 
>> http://wiki.documentfoundation.org/images/f/fd/0115GS3-KeyboardShortcuts.pdf 
>> 
>> 
>> This
>>  
>> is not the same for any other file listed for the 3.4.x branch. They all
>> are
>> "GS34" instead of "GS3".
>> 
>> It appears that there has been no editing of the file to make it over
>> for 3.4.x.
>> 
>> 
> 
> Should you not be reporting this on the documentation list?
> 
> Marc
> 
> 
I am not on the documentation list.
I just do not need to deal with another list right now.

I did report it on the website list, telling them that the link was wrong, but 
no replies.

I checked the "Full" book for the 3.4.x line and it does not seen to indicate, 
like the separate chapter does, that it was for version 3.3.  But there is no 
link for the Keyboard Shortcuts for the 3.4.x line, just a repeat of the 3.3.x 
one.

SO
I hope that someone would notice my reporting on the website list, and here, 
that there is a problem.  The only thing I deal with for the documentation, is 
download it and add the new/updates to the DVD project list.  Right now I have 
a "red X icon" in the placement of any chapters that have not been published 
for the 3.4.x/3.5.x line.  I hope all those "red X icons" will be removed 
before I am ready to publish the NA-DVD 3.5.2 .iso file.  I am updating as many 
of the "extras" as I can before that happens [extensions, open-source packages, 
and other non-LO-installs].

To be frank, I get 200-500 emails a day to wade through in the various 
Thunderbird in-basket-folders.  I do not need to add LO Documentation list to 
my current daily intake of emails.  80% of what I get now it either spam or not 
something I want to deal with.  Since I am not involved with the documentation 
project, per say, I do not think I should be on that list.



-- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: Fw: [libreoffice-marketing] Open standards and UK gov use of odf

[Andreas Säger]

Am 30.03.2012 12:28, Tom Davies wrote:



--- On Fri, 30/3/12, Ian Lynch  wrote:

It seems Microsoft is lobbying the UK Cabinet office for OOXML in place of
odf
http://www.computerweekly.com/blogs/public-sector/2012/03/microsoft-redeploys-ooxml-in-o.html

Anyone that has a point of view can respond to the consultation at
http://consultation.cabinetoffice.gov.uk/openstandards/how-to-respond/

The more that state odf is the choice if we want proper open standards the
better so please publicise on relevant lists.


Who cares? OOXML is a standard and I've heard of some compatible 
freeware. I think it was named Liber Office or something ...



--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: Fw: 'Open' Standards dependant on a single company?

[Tom Davies]

Hi :)
The UK Government is ostensibly and proudly independent of the US government.  

Although the decision appears to have already been made in the US, (to support 
a US company) the discussion is still open in the UK.  Would the US Government 
have been so quick to support MS if it had been a foreign company?  I think 
that might be one of the crucial differences.  MS is foreign to the UK.  
Hopefully that might make the decision more controversial.  

Back when MSO 2007 came out there were a LOT of people still using the older 
versions.  OOo and the rest had an opportunity to join forces with them to 
petition and make a strong stand against using the newer format.  

For whatever reasons Sun were always shy about promoting OOo and the ODF 
formats in the USA (and in England).  Hopefully if the same thing happened 
today then TDF would be better positioned to seize such opportunities.  

Also the UK's consultation document specifically states things like "reduce 
lock-in to a particular vendor or product".  I think if  people could write in 
and address specific points raised in the consultation document.  Then it might 
go someway towards swaying opinion in favour of ODF as used by LibreOffice and 
OpenOffice and all the rest.  

Now is the time for action, not for grumbling!
Regards from
Tom :)



--- On Fri, 30/3/12, webmaster-Kracked_P_P  wrote:

From: webmaster-Kracked_P_P 
Subject: Re: [libreoffice-users] Re: Fw: 'Open' Standards dependant on a single 
company?
To: users@global.libreoffice.org
Date: Friday, 30 March, 2012, 14:43


When MSO 2007 first came out and they were the only one that could use .docx 
formats, the US government started to produce .docx documents for the Library 
of Congress for public assess for documents.  At that time for whatever reason 
MSO get the US government to REQUIRE the people to upgrade to MSO 2007 if they 
wanted to read public documents.  MS had that much power back then.  I wrote a 
letter to LOC and some other government officials, via email and 
post-office-mail, about that subject.  I stated how much I was concerned that 
the US government no required their people to buy one company's newest software 
to access the documents required by LAW to be FREELY ACCESSIBLE.  The US 
government was producing documents that was no longer freely accessible since 
you were required to buy MSO to use them.  Forget the MSO file readers.  You 
need to be able to read/edit/use those government documents.  You could not do 
that for free at that point.  The
 government was breaking its own laws for freedom of information.

Now there are other office suites that can read/write .docx files, so it is not 
as much of a concern.

But, the US government needs to realize that there are more vendors out there 
that can be used for their office suite needs.  Yes, having them switch to ODF 
formats instead of MSO formats would be challenging, but packages like 
LibreOffice can replace most government users office packages without too many 
problems.  They still will be able to use the .doc and .docx file, along with 
the spreadsheet and presentation files.  Access files may take a little longer 
to get a Base version usable by both types of users.

I really think instead of "open standards", we need "open vendors".  Get people 
to realize that there is more than MSO to be chosen as their office package.  
THEN we can start getting people to look into ODF as a replacement for MSO's 
formats.  Even MSO is now working to read/write ODF, although not up to any 
real quality.  IF their users started to demand MSO to read/write ODF more that 
it does now, then "Open Standards" for office file formats will get a real 
boost.

The US government is pushing open source, but I have not seen nay articles 
about them pushing open source for office packages in the government offices. 
Just think what savings it would be if instead of buying the newest MSO for 
10,000 computers, they install LO's newest business ready version [not 3.5.1 at 
this point, but 3.4.5/3.4.6].  Even with a discount for volume, Free 10,000 
package vs. $50 each for 10,000.  That would give those agencies that get the 
10,000 LO packages a half-million of monies to use for other things in their 
limited budgets [ less the cost of helping the user to realize how easy their 
work is with LO].  This will only work for those who do not use MSO for those 
complex document needs that less than 0.01% of MSO users seem to need.  The 
average office worker, or at least for those agencies I have worked with, do 
not do or need to do complex documents.

YES
we need to get MSO for being the one company in control of the office document 
formats that most governments use, as well as the people who have to deal with 
the government agencies.

We need to have it in the hands of the community who knows better what they 
need than one company telling us we need this and nothing else.

BUT
get the users to realize that MSO is not their only

[libreoffice-users] Re: XML as mailmerge data source?

[Luuk]

On 31-03-2012 10:49, Mark Stanton wrote:
>> and yes, Google claims to have found more than 65,000 results ;)
> 
> Yes, as I said, I've been looking, and I found lots of "results", but
> 
>> But bottom-line will be, convert the XML to CSV or Excel or  ;)
> 
> You seem to agree with me that, no, there isn't a way.
> 
> Since XML is a wau of structuring data, just like a database is, then this 
> seems to be a glaring omission, so glaring I couldn't believe it.
> 

XML is too complex to do this, but how do i explain that in English ;)

Every line in a CSV file can be used for 1 document wit mailmerge.

But in XML you can have one-to-many relations, which are no yet
discoverd in the world of mailmerge..



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: Fw: [libreoffice-marketing] Open standards and UK gov use of odf

[Tom Davies]

Hi Andreas :)
This seems to be a somewhat inconsistent message from you.  I thought you 
wanted people to be allowed to use ODF formats?
Regards from
Tom :)


--- On Sat, 31/3/12, Andreas Säger  wrote:

From: Andreas Säger 
Subject: [libreoffice-users] Re: Fw: [libreoffice-marketing] Open standards and 
UK gov use of odf
To: users@global.libreoffice.org
Date: Saturday, 31 March, 2012, 14:58

Am 30.03.2012 12:28, Tom Davies wrote:
>
>
> --- On Fri, 30/3/12, Ian Lynch  wrote:
>
> It seems Microsoft is lobbying the UK Cabinet office for OOXML in place of
> odf
> http://www.computerweekly.com/blogs/public-sector/2012/03/microsoft-redeploys-ooxml-in-o.html
>
> Anyone that has a point of view can respond to the consultation at
> http://consultation.cabinetoffice.gov.uk/openstandards/how-to-respond/
>
> The more that state odf is the choice if we want proper open standards the
> better so please publicise on relevant lists.

Who cares? OOXML is a standard and I've heard of some compatible 
freeware. I think it was named Liber Office or something ...


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

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

Re: [libreoffice-users] LibreOffice Writer on Multiple Monitors

[Tom Davies]

Hi :)
I sometimes find that happens with all sorts of programs.  It didn't occur to 
me to post bug-reports about it.  It might be good to try posting a bug-report 
and see if it is something that can be fixed within LibreOffice
http://wiki.documentfoundation.org/BugReport
Good luck and regards from
Tom :)


--- On Thu, 15/3/12, peterbayley  wrote:

From: peterbayley 
Subject: [libreoffice-users] LibreOffice Writer on Multiple Monitors
To: users@global.libreoffice.org
Date: Thursday, 15 March, 2012, 0:51

I run three monitors arranged horizontally.  When I run Writer on the
Left-hand monitor the various menus act properly.  When I move the Writer
main window to the Center Monitor, the menus appear on the Right-hand
monitor and even sub-menus are on the hard left edge of the monitor so they
are placed over each other.  When I place the Writer main window on the
Right-hand monitor, the menus appear on the left-hand edge of the right
monitor and are also placed over each other.

I would think the problem lies in an assumption, somewhere in  the code,
that there are, at most, two monitors side by side and menu position
calculations are being made accordingly.  Below are screenshots of the
Writer window on the three monitors. 

System: Ubuntu 11.04 Natty Narwhal
Writer LibreOffice 3.5.0 Build ID 350m1(Build 13)

Regards

Peter

Left:
http://nabble.documentfoundation.org/file/n3827371/writer_01.png 

Center:
http://nabble.documentfoundation.org/file/n3827371/writer_02.png 

Right:
http://nabble.documentfoundation.org/file/n3827371/writer_03.png 

--
View this message in context: 
http://nabble.documentfoundation.org/LibreOffice-Writer-on-Multiple-Monitors-tp3827371p3827371.html
Sent from the Users mailing list archive at Nabble.com.

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


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

Re: [libreoffice-users] Fw: 'Open' Standards dependant on a single company?

[Mark Stanton]

It mentions not getting locked in to one vendor several times.  It 
seems to me that this is the point that needs to be used, repeatedly, 
to avoid, errr, getting locked in to one vendor.

I've responded to the first two chapters, at which point I started to 
gibber and couldn't carry on any further :-(

Mark Stanton
One small step for mankind...



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] XML as mailmerge data source?

[Mark Stanton]

That's a sufficiently good-English explanation.

I've got a very simple XML file that I'd like to use, which is why I 
hadn't thought about the wider issue.

Just need to be a database engine that uses XML files... And package 
it with Base... :-s

Regards
Mark Stanton
One small step for mankind...



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: Fw: [libreoffice-marketing] Open standards and UK gov use of odf

[e-letter]

On 31/03/2012, Andreas Säger  wrote:
> Am 30.03.2012 12:28, Tom Davies wrote:
>>
>>
>> --- On Fri, 30/3/12, Ian Lynch  wrote:
>>
>> It seems Microsoft is lobbying the UK Cabinet office for OOXML in place of
>> odf
>> http://www.computerweekly.com/blogs/public-sector/2012/03/microsoft-redeploys-ooxml-in-o.html
>>
>> Anyone that has a point of view can respond to the consultation at
>> http://consultation.cabinetoffice.gov.uk/openstandards/how-to-respond/
>>
>> The more that state odf is the choice if we want proper open standards the
>> better so please publicise on relevant lists.
>
> Who cares? OOXML is a standard and I've heard of some compatible
> freeware. I think it was named Liber Office or something ...
>

Nice irony. :)

The consultation document itself was created using LO34, yet
classified with the government organisation as a "word template"! This
proves the strategic fallacy of using LO as an m$ clone to create m$
documents. As long as users are encouraged to create m$ documents
using LO, m$ will remain dominant.

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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: XML as mailmerge data source?

[Ferry Toth]

A long time ago (before I abandoned windows) I used MSDAC and oledb. M$
had a connector thingy to use XML as a row source.

A simpler way to say this is that XML get converted into a table, with
the deeper nested tags stored in a cell. So you could drill down in the
data by getting the XML data from a cell and use that again to get a
table.

I guess that might work with ODBC and thus with LO on windows.

Ferry

Mark Stanton schreef op za 31-03-2012 om 20:38 [+0100]:

> That's a sufficiently good-English explanation.
> 
> I've got a very simple XML file that I'd like to use, which is why I 
> hadn't thought about the wider issue.
> 
> Just need to be a database engine that uses XML files... And package 
> it with Base... :-s
> 
> Regards
> Mark Stanton
> One small step for mankind...
> 
> 
> 

-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Fw: 'Open' Standards dependant on a single company?

[Tom Davies]

Hi :)
I don't suppose you would be willing to copy your answer to this list or the 
marketing list or perhaps to Ian?
Regards from
Tom :)


--- On Sat, 31/3/12, Mark Stanton  wrote:

From: Mark Stanton 
Subject: Re: [libreoffice-users] Fw: 'Open' Standards dependant on a single 
company?
To: users@global.libreoffice.org
Date: Saturday, 31 March, 2012, 20:38

It mentions not getting locked in to one vendor several times.  It 
seems to me that this is the point that needs to be used, repeatedly, 
to avoid, errr, getting locked in to one vendor.

I've responded to the first two chapters, at which point I started to 
gibber and couldn't carry on any further :-(

Mark Stanton
One small step for mankind...



-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Impress full screen question

[Renaud (Ron) Olgiati]

I have created a presentation, and want to display as a slide show in full 
screen (projector) without the window border or title bar or meny bar showing.

I suspect Impress can do it, since that is how it displays the .pps 
presentations I get by email; how do I get Impress to do this for MY 
presentation ?
 
TIA,
 
Ron.

PS Ctrl Shift J does nothing for me !
-- 
  Personne n'aime les missionnaires armés;
 et le premier conseil que donnent la nature et la prudence,
  c'est de les repousser comme des ennemis.
   -- Maximilien Robespierre

   -- http://www.olgiati-in-paraguay.org --


-- 
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.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] Impress full screen question

[Mirosław Zalewski]

On 31/03/2012 at 23:07, "Renaud (Ron) Olgiati"  wrote:

> I suspect Impress can do it, since that is how it displays the .pps
> presentations I get by email; how do I get Impress to do this for MY
> presentation ?

F5?
View → Slide Show?

> PS Ctrl Shift J does nothing for me !

What should it do?
-- 
Best regards
Mirosław Zalewski

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

Re: [libreoffice-users] XML as mailmerge data source?

[Steve Edmonds]

On 2012-03-31 21:49, Mark Stanton wrote:

and yes, Google claims to have found more than 65,000 results ;)

Yes, as I said, I've been looking, and I found lots of "results", but


But bottom-line will be, convert the XML to CSV or Excel or  ;)

You seem to agree with me that, no, there isn't a way.

Since XML is a wau of structuring data, just like a database is, then this
seems to be a glaring omission, so glaring I couldn't believe it.

Regards
Mark Stanton
One small step for mankind...

Hi.
I import XML into calc with an import filter, then it is possible to use 
it as a data source.
The import filter is not hard to configure but if there was a wizard for 
the import it would open XML import to a much wider audience.

Steve

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

Re: [libreoffice-users] Impress full screen question

[Rev. Nick Sharp]

On 31 March 2012 22:07, Renaud (Ron) Olgiati
 wrote:
> I have created a presentation, and want to display as a slide show in full
> screen (projector) without the window border or title bar or meny bar showing.
>
I've had this problem in the past, never solved it, but as a work
around managed to set my projector not to show the top and bottom of
the image, thus chopping off the unwanted borders.

Nick Sharp

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