[libreoffice-users] calc cells spacing to contents not working as it should

2012-10-04 Thread hormuzd Irani
http://nabble.documentfoundation.org/file/n4010934/calc_cell_padding_%28spacing_to_contents_under_borders%29.jpg After typing content inside cells and changing spacing to contents under format cells and border (tab), the size of the cell increased if the synchronise check-box was checked, and

Re: [libreoffice-users] calc cells spacing to contents not working as it should

2012-10-04 Thread Tom Davies
Hi :) I would post it as a bug-report but make it clear that it's the xls format that is affected.  Actually the screen-shots show it's xls if you look up at the title-bar in the screen-shots.  The taskbar at the bottom shows it's running on Xp.  It would be interesting to know if you get the

Re: [libreoffice-users] documentation for LO base

2012-10-04 Thread Mark Stanton
As well as existing guides by Andrew Pitonyak and others. 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

Re: [libreoffice-users] Import XML files?

2012-10-04 Thread Mark Stanton
Have you tried with a recent release of LibO? 3.4.6 is pretty old It's the current release from the Fedora repo. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] Update SQL does nothing using Run SQL directly button

2012-10-04 Thread Mark Stanton
And, as a stylistic suggestion, don't use a separate field for transaction year, calculate it from transaction date. The reason is that you've created a new classs of issue for yourself by doing this, keeping two fields in step. In general it's best to store basic data and calculate

Re: [libreoffice-users] Import XML files?

2012-10-04 Thread Mark Stanton
Thanks for that Steve. It looks like this is saying that OO/LO needs a specific template for a specific input, is that the case? I hope not, XML is supposed to be a self defining file format surely? A general importer ought to be easy, no? Regards Mark Stanton One small step for mankind...

Re: [libreoffice-users] Import XML files?

2012-10-04 Thread Tom Davies
Hi :) Yes, but LO develops so fast that even a version just a couple of months old is 'ancient'.  I think it would be nice to see an LTS that has all security and bug-fixes back-ported to it so that people could stick to one version for a year or more rather than having to re-install every

Re: [libreoffice-users] documentation for LO base

2012-10-04 Thread Tom Davies
Hi :) Some 3rd party guides can be found listed on the LO Publications page https://wiki.documentfoundation.org/Documentation/Publications#Base but i agree with Dan that the Getting Started chapter about Base, the first 2 chapters of the official guide

Re: [libreoffice-users] Update SQL does nothing using Run SQL directly button

2012-10-04 Thread Jay Lozier
On 10/04/2012 06:29 AM, Mark Stanton wrote: And, as a stylistic suggestion, don't use a separate field for transaction year, calculate it from transaction date. The reason is that you've created a new classs of issue for yourself by doing this, keeping two fields in step. In general it's

Re: [libreoffice-users] errors in file translation

2012-10-04 Thread webmaster-Kracked_P_P
On 10/03/2012 03:48 PM, Roland Graham wrote: Please read the attached file in both Excel and Libre Office. The (what I assume are) hard coded integers in the cells are coming out with grossly inflated values, almost 10 time as big as they are in Excel. I am using a Ubuntu supplied version

[libreoffice-users] Re: documentation for LO base

2012-10-04 Thread Andreas Säger
The ultimate guide by Mariano Casanova: http://www.scribd.com/doc/48635562/Base-Tutorial-OOo -- View this message in context: http://nabble.documentfoundation.org/documentation-for-LO-base-tp4010907p4010986.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe

[libreoffice-users] Re: Import XML files?

2012-10-04 Thread Andreas Säger
Mark Stanton wrote I hope not, XML is supposed to be a self defining file format surely? It's a meta-file format. You (who defines all the XML tags) are the one and only person able to develop import and export software for your particular flavour of XML. xml BLAH foo=bar blub x=121.43/blub

[libreoffice-users] Can someone on OS X verify a writer bug? (bugzilla-link inside)

2012-10-04 Thread SteveBell
https://bugs.freedesktop.org/show_bug.cgi?id=53924 Very annoying bug. Testing document is in the ticket. Would be great if someone could verify and confirm the bug. -- View this message in context:

[libreoffice-users] Re: errors in file translation

2012-10-04 Thread Tom
Hi :) Errr you can upload files to Nabble of course. Just use the links in this email or navigate to Nabble from the official LO website, something like Get Help - Nabble and then navigate through to the right thread. Most recent thread replied to tends to bubble-up to the top of the list.

Re: [libreoffice-users] documentation for LO base

2012-10-04 Thread Dan Lewis
On 10/04/2012 06:29 AM, Mark Stanton wrote: As well as existing guides by Andrew Pitonyak and others. Mark Could we have some links for the locations for these please. I personally would like to have a list of these resources for personal references. Perhaps others would also. --Dan

Re: [libreoffice-users] Re: documentation for LO base

2012-10-04 Thread webmaster-Kracked_P_P
I think one of the guys who is writing the Base documentation for OpenOffice, and converting it to LO, is a very busy person and it is taking him a lot of time to do the work for OpenOffice and does not have as much time to convert each finished chapter to LO. It also takes other people to

[libreoffice-users] Opening hybrid pdf in LO 3.6.0.2 results in gibberish

2012-10-04 Thread Gordon Burgess-Parker
I downloaded the hybrid pdf from here http://blog.documentfoundation.org/2012/07/17/libreoffice-infographics/ and tried to open in LO as it said at the bottom of the page. All I get is a load of gibberish. The hybrid pdf opens OK in a PDF reader -- Registered Linux User no 240308 GBP's

Re: [libreoffice-users] Opening hybrid pdf in LO 3.6.0.2 results in gibberish

2012-10-04 Thread John Clegg
I did exactly what it says - ie downloaded it, then ran LO and did File Open and selected the downloaded file. It opened in Draw and was all there and legible. LO 3.6.1 on Win7 On 4 October 2012 15:02, Gordon Burgess-Parker gbpli...@gmail.com wrote: I downloaded the hybrid pdf from here

Re: [libreoffice-users] Import XML files?

2012-10-04 Thread Mark Stanton
Ok, I'll put it on the list. Visual FoxPro (for example) has a built in function, XMLTOCURSOR, which takes a string or filename and produces a table. Mark Stanton One small step for mankind... -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?

Re: [libreoffice-users] documentation for LO base

2012-10-04 Thread Mark Stanton
Question: How many people do you know use Base, or have tried to use Base? Whilst there is some quite valid criticism of Base, I don't think answering this question says as much about Base as it does about the general usage of databases. They are less familiar than word processors,

Re: [libreoffice-users] documentation for LO base

2012-10-04 Thread Ken Brucker
thanks to all for your answers and consideration K -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive:

Re: [libreoffice-users] documentation for LO base

2012-10-04 Thread Jay Lozier
On 10/04/2012 11:04 AM, Mark Stanton wrote: Question: How many people do you know use Base, or have tried to use Base? Whilst there is some quite valid criticism of Base, I don't think answering this question says as much about Base as it does about the general usage of databases. They

Re: [libreoffice-users] documentation for LO base

2012-10-04 Thread Joel Madero
I'm only catching bits and pieces of this conversation but if someone is interested in doing documentation on base I'd recommend joining the documentation mailing list. I'm sure they could use some help :) Regards, Joel On Thu, Oct 4, 2012 at 9:49 AM, Jay Lozier jsloz...@gmail.com wrote: On

Re: [libreoffice-users] documentation for LO base

2012-10-04 Thread Tom Davies
Hi :) i think the point was that if more people use a thing then more people care about how well it works.  If we start with the premise that only a fraction of people that use a thing are likely to be involved with fixing it (or even just reporting a problem) then it helps to have more

[libreoffice-users] loadComponentfromUrl

2012-10-04 Thread Walther Koehler
Hi, When I open a document in writer (by menu/open or recently used or new), it opens a frame with full window size. bingo. When I open the same document via a basic makro using loadComponentfromUrl(sURL, _blank, 0, args()) it opens in a frame maximised vertically but not horizontally. All

Re: [libreoffice-users] documentation for LO base

2012-10-04 Thread Wolfgang Keller
Is there any documentation for LibreOffice Base? In german language, yes. http://wiki.documentfoundation.org/images/d/d4/06_BH_Gesamtband_V35_einseitig.pdf It's probably in the process of being translated. Sincerely, Wolfgang -- For unsubscribe instructions e-mail to:

[libreoffice-users] Help in LibreOffice 3.5.6

2012-10-04 Thread Eliane Domingos de Sousa
Hi all, I have a situation under LibreOffice 3.5.6 with a dialog that has several steps. In the LibreOffice IDE, I see only the last page of the dialog. The module that invokes the dialog uses the property Step as oDialog.Model.Step = 1 ' (...2,...3, or whatever page number) How do I edit the

[libreoffice-users] Re: Import XML files?

2012-10-04 Thread Andreas Säger
FoxPro export exports database fields like this: ?xml version=1.0?Document OrderUpdate OrderId12345/OrderId OrderDate01/01/2004/OrderDate Confirmation123/Confirmation Storage StorageId01/StorageId Quantity1450/Quantity /Storage Storage

Re: [libreoffice-users] Opening hybrid pdf in LO 3.6.0.2 results in gibberish

2012-10-04 Thread Tom Davies
Hi :) Did work for me on Win Xp Sp3, LO 3.5.4 Not working on Ubuntu 12.04, LO 3.5.4 = asks for Utf encoding and defaults to 8 and guesses at font = Times New Roman.  Regards from Tom :)  From: John Clegg john.cl...@nailsea.net To: Gordon Burgess-Parker

Re: [libreoffice-users] loadComponentfromUrl

2012-10-04 Thread Tom Davies
Hi :) Hopefully someone more experienced will give a decent answer but until then it might be worth acquiring Andrew Pitonyak's Macro Guide https://wiki.documentfoundation.org/Documentation/Publications#Programmers There are a few chapters and things in official documentation (and therefore

Re: [libreoffice-users] Extracting info from calc cell

2012-10-04 Thread Dan Lewis
On 10/04/2012 02:23 PM, Daniel A. Rodriguez wrote: Have a huge users list with the form 'lastname', 'middle-name' 'first-name'. I need to extract initials and I can't figure out how to do that. Following the example, expected result should be mflastname Any clue?

Re: [libreoffice-users] Extracting info from calc cell

2012-10-04 Thread Daniel A. Rodriguez
Have a huge users list with the form 'lastname', 'middle-name' 'first-name'. I need to extract initials and I can't figure out how to do that. Following the example, expected result should be mflastname Any clue? If the first three columns (A-C) are 'lastname' (A), 'middle-name'(B), and

Re: [libreoffice-users] Re: ZOOM: strange or bug??

2012-10-04 Thread Tom Davies
Hi :) Did this ever get solved?  It took me so long to work out what the problem was that i didn't even notice whether a decent answer solved it in the end! Apols and regards from Tom :)  From: manuel_songo...@yahoo.it manuel_songo...@yahoo.it To:

Re: [libreoffice-users] [Writer] Data to Fields is not working

2012-10-04 Thread Mirosław Zalewski
Dan, Thanks for your reply. On 04/10/2012 at 01:50, Dan Lewis elderdanle...@gmail.com wrote: You need to use both Data to Text and Data to Fields buttons for the later to work. 1. Open new Writer document 2. Press F4 (or View ? Data Sources) 3. Select bibliography table biblio 4.

Re: [libreoffice-users] Re: Import XML files?

2012-10-04 Thread Steve Edmonds
On 2012-10-05 02:22, Jay Lozier wrote: On 10/04/2012 08:11 AM, Andreas Säger wrote: Mark Stanton wrote I hope not, XML is supposed to be a self defining file format surely? It's a meta-file format. You (who defines all the XML tags) are the one and only person able to develop import and

[libreoffice-users] query re. volunteering w/ LO

2012-10-04 Thread anne-ology
Back when I received this response [2nd below], I attempted to follow these steps - but found that #1 is impossible; there is no 'math' problem which is to be answered in order to log-in [WHERE is this to be found?] Therefore, the log-in merely goes round and round,

[libreoffice-users] help needed ...

2012-10-04 Thread anne-ology
... how were you able to log-in and get your names posted on that list? what am I doing wrong? From: anne-ology lagin...@gmail.com Date: Thu, Oct 4, 2012 at 3:43 PM Subject: query re. volunteering w/ LO To: users@global.libreoffice.org Cc: Joel jmadero@gmail.com

[libreoffice-users] Re: [Writer] Data to Fields is not working

2012-10-04 Thread Andreas Säger
You can not do anything useful with a blank new document. 1. Open your letter template with fields. 2. Hit F4 and get your row set (query or table) 3. Click a grey row selector left of the first column to select the record that represents the receipient of your letter. 4. Click data-to-fields

[libreoffice-users] attempting to find an answer and instead ...

2012-10-04 Thread anne-ology
... merely receive this :-( I don't believe I deserve to be ignored ... nor to be abused - therefore I think this list should be made aware of this person's behaviour - because if he's treating me in this manner, I'm sure others have received and/or will be

Re: [libreoffice-users] attempting to find an answer and instead ...

2012-10-04 Thread Joel Madero
On Thu, Oct 4, 2012 at 2:09 PM, anne-ology lagin...@gmail.com wrote: ... merely receive this :-( I don't believe I deserve to be ignored ... nor to be abused - therefore I think this list should be made aware of this person's behaviour - because if he's

Re: [libreoffice-users] Re: [Writer] Data to Fields is not working

2012-10-04 Thread Mirosław Zalewski
Andreas, On 04/10/2012 at 23:08, Andreas Säger ville...@t-online.de wrote: 1. Open your letter template with fields. What fields do you refer to? How do I place them? I know I can place fields from database using Insert → Fields → Other → Database → Mail merge fields. But after placing

Re: [libreoffice-users] MS renting office products

2012-10-04 Thread anne-ology
Exactly. But for some reason, common sense seems to be dead; and with it disappeared learning from the past ;-( With hope, maybe folks will listen to your well-phrased message ;-) On Tue, Oct 2, 2012 at 1:38 PM, Tim Deaton t...@timdeaton.org wrote: I don't think we

[libreoffice-users] Re: Import XML files?

2012-10-04 Thread Andreas Säger
MySQL can import your customer-visibility-groups: http://dev.mysql.com/doc/refman/5.5/en/load-xml.html If there is any reason why you want customer-visibility-groups in a calculator software, connect a registerd Base document to your MySQL server and dump the imported data from the data source

Re: [libreoffice-users] attempting to find an answer and instead ...

2012-10-04 Thread Girvin R. Herr
Joel Madero wrote: snip A ping is just a quick email (or IRC message, etc...) that says hey, any updates, some users even just say ping in IRC basically saying hey, you around? snip Joel, ping, another overloaded word: https://en.wikipedia.org/wiki/Ping But those of us in the

Re: [libreoffice-users] help needed ...

2012-10-04 Thread Mas
On Thu, Oct 4, 2012 at 4:54 PM, anne-ology lagin...@gmail.com wrote: ... how were you able to log-in and get your names posted on that list? what am I doing wrong? From: anne-ology lagin...@gmail.com Date: Thu, Oct 4, 2012 at 3:43 PM Subject: query re. volunteering

Re: [libreoffice-users] [Writer] Data to Fields is not working

2012-10-04 Thread Dan Lewis
On 10/04/2012 03:55 PM, Mirosław Zalewski wrote: Dan, Thanks for your reply. On 04/10/2012 at 01:50, Dan Lewis elderdanle...@gmail.com wrote: You need to use both Data to Text and Data to Fields buttons for the later to work. 1. Open new Writer document 2. Press F4 (or View ? Data

Re: [libreoffice-users] Re: Import XML files?

2012-10-04 Thread Steve Edmonds
On 2012-10-05 10:27, Andreas Säger wrote: MySQL can import your customer-visibility-groups: http://dev.mysql.com/doc/refman/5.5/en/load-xml.html If there is any reason why you want customer-visibility-groups in a calculator software, connect a registerd Base document to your MySQL server and

[libreoffice-users] Re: Import XML files?

2012-10-04 Thread Andreas Säger
Am 03.10.2012 20:54, Mark Stanton wrote: I've got an XML file (I've generated myself, programmatically). I thought it ought to be easy to import it in LO (3.4.6), somehow. I thougth Calc would be a good bet, but it just gives me General I/O error. Base does the same. The website

[libreoffice-users] Re: Import XML files?

2012-10-04 Thread Alexander Thurgood
Le 03/10/12 20:54, Mark Stanton a écrit : Hi Mark, I've got an XML file (I've generated myself, programmatically). I thought it ought to be easy to import it in LO (3.4.6), somehow. I thougth Calc would be a good bet, but it just gives me General I/O error. Base does the same.

Re: [libreoffice-users] attempting to find an answer and instead ...

2012-10-04 Thread anne-ology
Thanks for this explanation. Just thinking ... before the 'phone, folks would ring the doorbell ... after the 'phone, folks would ring the 'phone ... so I guess ping is the cross between ring and pc -

Re: [libreoffice-users] help needed ...

2012-10-04 Thread anne-ology
Ok, thanks, I'll try it using Chrome - I've been using FireFox. The problem has been some box which does not seem to appear anywhere - some 'math problem' with a 'box for an answer' to prove I'm not a robot [I've encountered these on other sites, but have

[libreoffice-users] seperatiors between cross reference elements

2012-10-04 Thread rost52
When making a cross reference in a WRITER document I typically use [heading number] [space] [heading text] {heading number] is called in LO number and I choose always number (full context) {heading text] is called LO Reference. I am looking for a setting that the space (or another character) is

Re: [libreoffice-users] Re: MS raised prices so people will now start renting their office products instead

2012-10-04 Thread rost52
On 2012-10-03 11:41, Gordon Burgess-Parker wrote: On 02/10/12 19:38, Tim Deaton wrote: I don't think we need to remove existing features. But I DO think we need to focus on the 90% of average users. Basically, I think LO should be making sure it can do everything that MS Office 97

[libreoffice-users] Re: calc cells spacing to contents not working as it should

2012-10-04 Thread hormuzd Irani
Firstly i would like to apologize for having bothered all of you, for if the file is stored as an .ods file the formatting is retained (xls looses it). from the .ods file i created a new .xlsx file. The .xlsx file (word 2007-2010 format) also lost the formatting. I think it is excel's inadequacy

Re: [libreoffice-users] attempting to find an answer and instead ...

2012-10-04 Thread Felmon Davis
On Thu, 4 Oct 2012, anne-ology wrote: Thanks for this explanation. Just thinking ... before the 'phone, folks would ring the doorbell ... after the 'phone, folks would ring the 'phone ... so I guess ping is the

[libreoffice-users] Help request on CALC charts' features

2012-10-04 Thread Viral Orpe
Hi, I am new to Open source *.* (OS, environment, office, Banshee, wvdial, the works) I recently moved my excel spread-sheets to calc. I am still going through files/features-check post the translation. Most of the data, formula, and formatting are okay, fonts are better. In the charts I

Re: [libreoffice-users] query re. volunteering w/ LO

2012-10-04 Thread Thomas Taylor
On Thu, 4 Oct 2012 15:43:34 -0500 anne-ology lagin...@gmail.com wrote: Back when I received this response [2nd below], I attempted to follow these steps - but found that #1 is impossible; there is no 'math' problem which is to be answered in order to log-in [WHERE is this