[libreoffice-users] calc cells spacing to contents not working as it should
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 the contents of the cells were repositioned inside the cell as shown above. after saving and opening the file the cell size remains enlarged but the contents of the cell are positioned as if no change was made: Format cells - border -spacing to contents all setting retain default spacing of 2.0pt as shown below in image http://nabble.documentfoundation.org/file/n4010934/calc_cell_padding_%28spacing_to_contents_under_borders%29after_saving.jpg if synchronise check-box was unchecked and only right value was changed, the cell size remained unchanged but the contents of the cell were repositioned as shown below: http://nabble.documentfoundation.org/file/n4010934/calc_cell_padding_%28spacing_to_contents_under_borders%29-2.jpg after saving the file (synchronise unchecked), and opening it the contents showed up as if no formatting was done using: format cell - border - spacing to contents http://nabble.documentfoundation.org/file/n4010934/calc_cell_padding_%28spacing_to_contents_under_borders%29_-_2_after_saving.jpg I am using libreOffice Version 3.6.0.4 (Build ID: 932b512) under windows XP is it a bug ?? should i post this as a bug ?? -- View this message in context: http://nabble.documentfoundation.org/calc-cells-spacing-to-contents-not-working-as-it-should-tp4010934.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] calc cells spacing to contents not working as it should
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 same results using the native format, .ods for spreadsheets. Gimp or something could be used to edit the image to crop out bits you don't want to pass on but actually you seem to have quite a nice layout and nothing embarrassing open and showing in the taskbar. I found it awkward to take screen-shots in Windows. In most GnuLinux you just press the PrtScn button and doing that gives a Save As ... type dialogue-box offering to save a Png in your Pictures folder. No messing around pasting the copied picture into Paint or something. Regards from Tom :) From: hormuzd Irani hormuzdir...@gmail.com To: users@global.libreoffice.org Sent: Thursday, 4 October 2012, 10:45 Subject: [libreoffice-users] calc cells spacing to contents not working as it should 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 the contents of the cells were repositioned inside the cell as shown above. after saving and opening the file the cell size remains enlarged but the contents of the cell are positioned as if no change was made: Format cells - border -spacing to contents all setting retain default spacing of 2.0pt as shown below in image http://nabble.documentfoundation.org/file/n4010934/calc_cell_padding_%28spacing_to_contents_under_borders%29after_saving.jpg if synchronise check-box was unchecked and only right value was changed, the cell size remained unchanged but the contents of the cell were repositioned as shown below: http://nabble.documentfoundation.org/file/n4010934/calc_cell_padding_%28spacing_to_contents_under_borders%29-2.jpg after saving the file (synchronise unchecked), and opening it the contents showed up as if no formatting was done using: format cell - border - spacing to contents http://nabble.documentfoundation.org/file/n4010934/calc_cell_padding_%28spacing_to_contents_under_borders%29_-_2_after_saving.jpg I am using libreOffice Version 3.6.0.4 (Build ID: 932b512) under windows XP is it a bug ?? should i post this as a bug ?? -- View this message in context: http://nabble.documentfoundation.org/calc-cells-spacing-to-contents-not-working-as-it-should-tp4010934.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] documentation for LO base
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 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] Import XML files?
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? 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] Update SQL does nothing using Run SQL directly button
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 subsidiary data from it, don't store subsidiary data. 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] Import XML files?
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... -- 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] Import XML files?
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 month or so. Unfortunately the BoD are fairly committed to making sure we don't get one. Regards from Tom :) From: Mark Stanton m...@vowleyfarm.co.uk To: users@global.libreoffice.org Sent: Thursday, 4 October 2012, 11:29 Subject: Re: [libreoffice-users] Import XML files? 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? 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] documentation for LO base
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 https://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Base_Guide and the Faq https://wiki.documentfoundation.org/Faq are probably the best places to start. I think the guide that you are thinking of, by Andrew Pitonyak, is his excellent macro guide? I'm not sure he has done one for Base but if he has and if we haven't listed it then it would be excellent to add or if there are other guides by other people then they might be good to add too. Some 3rd party guides cost money and/or if you want to buy the official LO guides in printed form then they can be bought from Lulu (as linked to from the Publications page). Regards from Tom :) From: Mark Stanton m...@vowleyfarm.co.uk To: users@global.libreoffice.org Sent: Thursday, 4 October 2012, 11:29 Subject: Re: [libreoffice-users] documentation for LO base 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 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] Update SQL does nothing using Run SQL directly button
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 best to store basic data and calculate subsidiary data from it, don't store subsidiary data. Regards Mark Stanton One small step for mankind... The function is Year(name) = year. For best results store the date in -mm-dd format, Typical use is Selectcolumn list From table list WhereYear(column) = AND month = mm There are other date/time functions available. -- 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] errors in file translation
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 3.5.4.2 BuildID:350m1(Build:2). Thanks, Roland Graham Sorry, but there is no ability to attach files with this list. Which Ubuntu? 10.xx, 11.xx, 12.04? -- 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: documentation for LO base
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 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: Import XML files?
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 scramble crucifix=Trueertzuiopdfghjklöxcvbnm/scramble /BLAH /xml How would you translate this into a spreadsheet? Is BLAH a row, a column? What is scramble? How to deal with the attributes? Nobody ever tells us anything about his/her user-defined file formats such as CSV or XML. So most of the topics becaome lengthy and some remain unsolved. A general importer ought to be easy, no? Google reveals plenty of examples about how to write XLST scritpts to import/export user-defined XML formats into/from ODF. This is development work just like writing macros or setting up a database. In all those years since OOo 1.0 nobody wrote a generic XML-to-Calc tool. I would search in the database world for existing XML tools for database engines. Once you have the data in a connectable database, you have it it in Calc and Writer as well. -- View this message in context: http://nabble.documentfoundation.org/Import-XML-files-tp4010875p4010988.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Can someone on OS X verify a writer bug? (bugzilla-link inside)
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: http://nabble.documentfoundation.org/Can-someone-on-OS-X-verify-a-writer-bug-bugzilla-link-inside-tp4010999.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: errors in file translation
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. Just reply to a post in the right thread and then click the More button. E, i always make this sound much more complicated than it really is. Really it's just a couple of obvious clicks. I can make opening a door sound complicated too by going into too much detail. Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/errors-in-file-translation-tp4010886p4011013.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] documentation for LO base
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 -- 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: documentation for LO base
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 look over the work and proofread and test out what is stated. There seems not to be enough Base people who are able/willing to help with this hard process. It seems that Draw and Base are the two more difficult modules to write guides for, with Base being the hardest. Question: How many people do you know use Base, or have tried to use Base? Then ask the same for Writer, Calc, Impress, Draw, and then Math. I rarely use anything other than Writer or Calc, for LO's suite. On 10/04/2012 09:01 AM, Tom Davies wrote: Hi :) Thanks :) I just added it to the list in the Publications page https://wiki.documentfoundation.org/Documentation/Publications#Base Regards from Tom :) From: Andreas Säger ville...@t-online.de To: users@global.libreoffice.org Sent: Thursday, 4 October 2012, 13:09 Subject: [libreoffice-users] Re: documentation for LO base 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 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] Opening hybrid pdf in LO 3.6.0.2 results in gibberish
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 alternative computing:http://gbplinuxfoss.blogspot.com/ Say No to OOXMLhttp://www.linuxjournal.com/article/9594#mpart8 I only accept odf or pdf documents by email -- 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] Opening hybrid pdf in LO 3.6.0.2 results in gibberish
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 http://blog.** documentfoundation.org/2012/**07/17/libreoffice-**infographics/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 alternative computing:http://gbplinuxfoss.**blogspot.com/http://gbplinuxfoss.blogspot.com/ Say No to OOXMLhttp:// www.linuxjournal.**com/article/9594#mpart8http://www.linuxjournal.com/article/9594#mpart8 I only accept odf or pdf documents by email -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/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] Import XML files?
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? 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] documentation for LO base
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, spreadsheets or drawing packages. 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] documentation for LO base
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: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] documentation for LO base
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 are less familiar than word processors, spreadsheets or drawing packages. Mark I use databases at work, primarily MS SQL Server. My observation is to be good at using databases (Base included) takes more time and effort up front than most realize. Most people have a very rudimentary understanding, if any, of databases. Often, they think of and use spreadsheets as databases, which only works at a very rudimentary and simple level (table of contact information for mailing list generation). Any marginally more sophisticated use and spreadsheets fail as databases. Database design is less obvious to most. I think most people do not understand that databases are a type of model of the real world. The accuracy of the model for the user's needs is what is important and this not always easy to determine or model. Beyond the conceptual problems with databases, they use a querying language. Most (all?) relational databases like Base use a variant of SQL. So to move beyond the wizards and have more control and understanding one eventually needs to learn some SQL, another level learning with more time and effort. Word processors, spreadsheets, presentation packages, drawing packages, etc. conceptually tend to follow how one would do the task manually. Fundamentally, writing a document in Write at its most basic level is a much nicer way of typing it than on typewriter. Because the program can do more than just display the text, such spell check, auto format, auto number lists, etc., the program adds considerable value beyond simply typing. The early word processing programs had one feature that typewriter could never do; save the document for later editing without have to retype it in part or in entirety. -- 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] documentation for LO base
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 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 are less familiar than word processors, spreadsheets or drawing packages. Mark I use databases at work, primarily MS SQL Server. My observation is to be good at using databases (Base included) takes more time and effort up front than most realize. Most people have a very rudimentary understanding, if any, of databases. Often, they think of and use spreadsheets as databases, which only works at a very rudimentary and simple level (table of contact information for mailing list generation). Any marginally more sophisticated use and spreadsheets fail as databases. Database design is less obvious to most. I think most people do not understand that databases are a type of model of the real world. The accuracy of the model for the user's needs is what is important and this not always easy to determine or model. Beyond the conceptual problems with databases, they use a querying language. Most (all?) relational databases like Base use a variant of SQL. So to move beyond the wizards and have more control and understanding one eventually needs to learn some SQL, another level learning with more time and effort. Word processors, spreadsheets, presentation packages, drawing packages, etc. conceptually tend to follow how one would do the task manually. Fundamentally, writing a document in Write at its most basic level is a much nicer way of typing it than on typewriter. Because the program can do more than just display the text, such spell check, auto format, auto number lists, etc., the program adds considerable value beyond simply typing. The early word processing programs had one feature that typewriter could never do; save the document for later editing without have to retype it in part or in entirety. -- 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 -- *Joel Madero* LibO QA Volunteer jmadero@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] documentation for LO base
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 people using it because that may lead to more people being involved in fixing it. Once you start adding in extra factors such as average skill level of the different users of the different apps then Base is still heavily out-gunned by Writer and Calc. I kinda disagree about Draw tho. I think Impress needs a lot more help than Draw. Draw has some quite fancy features and i've been really happy using on the rare occasions i've needed something other than Gimp. Impress is embarrasing. Base is more important than either of those imo but gets a LOT less attention, except on this list 'recently'. Regards from Tom :) From: Mark Stanton m...@vowleyfarm.co.uk To: users@global.libreoffice.org Sent: Thursday, 4 October 2012, 16:04 Subject: Re: [libreoffice-users] documentation for LO base 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, spreadsheets or drawing packages. 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 -- 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] loadComponentfromUrl
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 further open commands (menu/open AND basic) give the same reduced window frame. I assume that somehow an internal variable has been changed by the loadComponentfromUrl command. of course I fiddled around with the parameters/args() of loadComponentfromURL and the KDE windows configuration, does _blank start a new (wrong) parent frame?, never Problem up to 3.4. Any idea? Walther -- 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] documentation for LO base
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: 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] Help in LibreOffice 3.5.6
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 dialog pages in the IDE? . Is there a trick to see all the dialog pages? If not how do I change them? Thank you Eliane Domingos -- 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: Import XML files?
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 StorageId02/StorageId Quantity2480/Quantity /Storage /OrderUpdate /Document It might be comparatively easy to write a Base driver for structures like this one. A spreadsheet does not imply any such structure. As far as I know, Excel imports arbitrary flavours of tabular XML through a wizard analog to a CSV import wizard. You specify the column tags, the row tags and get raw data in a spreadsheet. In the following example each record represents one consecutive spreadsheet row (starting at row#1) and each value represents a consecutive column value within that row (starting at column A). First row has column labels. xml record value type=StringID/value value typ=StringOrder Date/value value typ=StringValue/value /record record value type=Number13/value value type=Date2010-12-28/value value type=StringSome Text/value /record record value type=Number14/value value type=Date2010-12-31/value value type=StringSome Other Text/value /record /xml This one represents the very same data in German tags: xml zeile wert typ=ZeichenID/wert wert typ=ZeichenOrder Date/wert wert typ=ZeichenValue/wert /zeile zeile wert typ=Zahl13/wert wert typ=Datum2010-12-28/wert wert typ=ZeichenSome Text/wert /zeile zeile wert typ=Zahl14/wert wert typ=Datum2010-12-31/wert wert typ=ZeichenSome Other Text/wert /zeile /xml Other flavours of xml may describe rows within columns, railway connections in time tables, articles and clients in invoices, ... Any tool to import arbitrary XML into sheets needs to import text, numbers, special numbers and blanks into columns and rows even if there is no rectangular structure of records and fields. If there is a database structure (like the above FoxPro XML) it needs to import each value (number, text, date, blank) under its given field name. Most people who ask for XML import into Calc mean the XML flavour produced by Excel 2003. But they do not know that this particular flavour of XML is specifically made for that particular application. Other applications to read Excel-XML can be written easily but they need to be written. XML is not a file format on its own right. XML lets you define your own file formats. -- View this message in context: http://nabble.documentfoundation.org/Import-XML-files-tp4010875p4011079.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] Opening hybrid pdf in LO 3.6.0.2 results in gibberish
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 gbpli...@gmail.com Cc: Libre Office Users users@global.libreoffice.org Sent: Thursday, 4 October 2012, 15:31 Subject: Re: [libreoffice-users] Opening hybrid pdf in LO 3.6.0.2 results in gibberish 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 http://blog.** documentfoundation.org/2012/**07/17/libreoffice-**infographics/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 alternative computing:http://gbplinuxfoss.**blogspot.com/http://gbplinuxfoss.blogspot.com/ Say No to OOXMLhttp:// www.linuxjournal.**com/article/9594#mpart8http://www.linuxjournal.com/article/9594#mpart8 I only accept odf or pdf documents by email -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.** org users%2bh...@global.libreoffice.org Problems? http://www.libreoffice.org/**get-help/mailing-lists/how-to-** unsubscribe/http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.**documentfoundation.org/** Netiquette http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.**libreoffice.org/global/users/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] loadComponentfromUrl
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 free) but i suspect you have already gone through those. Regards from Tom :) From: Walther Koehler w.koeh...@onlinemed.de To: users@global.libreoffice.org Sent: Thursday, 4 October 2012, 17:42 Subject: [libreoffice-users] loadComponentfromUrl 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 further open commands (menu/open AND basic) give the same reduced window frame. I assume that somehow an internal variable has been changed by the loadComponentfromUrl command. of course I fiddled around with the parameters/args() of loadComponentfromURL and the KDE windows configuration, does _blank start a new (wrong) parent frame?, never Problem up to 3.4. Any idea? Walther -- 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] Extracting info from calc cell
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? --~--~-~--~~~---~--~~ Escuelas Libres :: Porque la educación es mucho mejor cuando es libre www.escuelaslibres.org.ar --- LiberTICs Cooperativa Ltda. www.libertics.com.ar --- Para entrenar, cualquier programa sirve. Para educar, sólo Software Libre. (Federico Heinz) --- If the first three columns (A-C) are 'lastname' (A), 'middle-name'(B), and 'first-name(C) and column D contains that the initials plus the last name, the equation for this is: =CONCATENATE( LEFT(B1),LEFT(C1),A1). --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: [libreoffice-users] Extracting info from calc cell
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 'first-name(C) and column D contains that the initials plus the last name, the equation for this is: =CONCATENATE( LEFT(B1),LEFT(C1),A1). that's why I love LibO, things are easier than what we can see some users --~--~-~--~~~---~--~~ Escuelas Libres :: Porque la educación es mucho mejor cuando es libre www.escuelaslibres.org.ar --- LiberTICs Cooperativa Ltda. www.libertics.com.ar --- Para entrenar, cualquier programa sirve. Para educar, sólo Software Libre. (Federico Heinz) --- -- 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: ZOOM: strange or bug??
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: users@global.libreoffice.org users@global.libreoffice.org Cc: Tom tomdavie...@yahoo.co.uk Sent: Monday, 1 October 2012, 16:04 Subject: Re: [libreoffice-users] Re: ZOOM: strange or bug?? I wanted to say this: normally, when you go near zoom horizontal bar on the bottom of the screen with the arrow of your mouse, without clicking on it, it does nothing. In my situation, it is sufficient to go near horizontal bar and commands behave as if i'm clicking and moving it on the left or right side, but I'm absolutely not requesting the function in that moment. Is as if the function is activated all the times I interact with the horizontal bar, but without clicking on it. How can I solve the problem? My doubt is that it is specifically associated to touch-screen monitor features. So, perhaps I need to (de)activate some hidden option? Da: Tom tomdavie...@yahoo.co.uk A: users@global.libreoffice.org Inviato: Sabato 29 Settembre 2012 14:41 Oggetto: [libreoffice-users] Re: ZOOM: strange or bug?? Hi :) Ok, so you are using LO 3.5.4(?) definitely 3.5.something on openSUSE. I'm not sure how to record your desktop on openSUSE, it's probably the same way i would do it on Ubuntu but i don't know that either. I'm still not clear what the problem is. 1. Is it that when you move the mouse arrow over the screen it gets stuck over the zoom controls at the bottom right of the screen? or does it move away from there but stay stuck with the same controls? Is the problem that once you start zooming then you can't do anything except zoom? 2. Is it that the zoom goes rapidly from minimum to max or vice-versa without allowing you to just zoom in (or out) just a small amount? Regards from Tom :) -- View this message in context: http://nabble.documentfoundation.org/ZOOM-strange-or-bug-tp4008583p4010023.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 -- 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] [Writer] Data to Fields is not working
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. Press left-most cell of any row to select entire row (without this step Data to Text nor Data to Fields button is not clickable). 5. Click the Data to Text button to select what will be copied from the selected row in the Data Sources window to the text documents. 6. A dialog opens giving three choices: paste the data in table format, as fields, or as text. The first and third choices are result in text being pasted. 7. The Data to Fields button works only if you have selected Fields in the dialog. To change the data showing in the fields in the text document, select another row. Then click this button. In other words, you have to use Data to Text button to create the fields before you can put any other data in these fields using the Data to Text button. I am afraid it still does not work as described. When I click Data to Text, new window appears. I check Fields and then move (using arrow button) field from left column to right one. When I click OK, this window disappears, but field appears right in my document. Clicking Data to Fields still does not do anything visible. What version of LO are you using? It might be that mine is buggy or your outdated and that's why we see different behaviors. -- 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] Re: Import XML files?
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 export software for your particular flavour of XML. xml BLAH foo=bar blub x=121.43/blub scramble crucifix=Trueertzuiopdfghjklöxcvbnm/scramble /BLAH /xml How would you translate this into a spreadsheet? Is BLAH a row, a column? What is scramble? How to deal with the attributes? Nobody ever tells us anything about his/her user-defined file formats such as CSV or XML. So most of the topics becaome lengthy and some remain unsolved. A general importer ought to be easy, no? Google reveals plenty of examples about how to write XLST scritpts to import/export user-defined XML formats into/from ODF. This is development work just like writing macros or setting up a database. In all those years since OOo 1.0 nobody wrote a generic XML-to-Calc tool. I would search in the database world for existing XML tools for database engines. Once you have the data in a connectable database, you have it it in Calc and Writer as well. -- View this message in context: http://nabble.documentfoundation.org/Import-XML-files-tp4010875p4010988.html Sent from the Users mailing list archive at Nabble.com. Andreas, My understanding the problem with importing a generic XML file is that the document definition does not a (defacto) standard that one can write an import script for? If the XML file uses a known definition (ODF for example) then it is easier to write an import script because there is a standard defining the document internals. The extension of this is, if the file format is well documented, even if it is proprietary, then writing an import script is possible because there exists a specification for the format. The only issue then is whether one has the complete format specification. Some of the XML files I import have nested lists, i.e not flat. I like to define how these are imported. The file also has a lot of fields I don't want imported (not shown). So by using a filter I get what I want displayed how I want. ?xml version=1.0 encoding=UTF-8? customers type=array customer saltc9bf86ac97d3f742f85e9811d338a594af727dbc/salt updated-at type=datetime2010-02-16T17:03:57-05:00/updated-at valid-access-count type=integer0/valid-access-count customer-visibility-groups type=array customer-visibility-group id type=integer10/id nameAll Customers/name the-parent-record-id type=NilClass1/the-parent-record-id /customer-visibility-group customer-visibility-group id type=integer11/id nameOIML customers/name the-parent-record-id type=NilClass1/the-parent-record-id /customer-visibility-group customer-visibility-group id type=integer258/id nameAE-United Arab Emirates/name the-parent-record-id type=NilClass1/the-parent-record-id /customer-visibility-group customer-visibility-group id type=integer21/id nameMNA-Middle East amp; N Africa/name the-parent-record-id type=NilClass1/the-parent-record-id /customer-visibility-group /customer-visibility-groups /customer /customers Steve -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] query re. volunteering w/ LO
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, stating this error, yet never explaining HOW to correct this error ;-( After trying - and with the same results - half a dozen times, I wrote this Joel back - [1st below] a few days later, he finally responded but ONLY to having received my e-mail, rather than responding to HOW to log-in. When I initially offered to help, I did so in good faith, yet now I'm thinking that either that initial letter and/or his response was some joke; I'm asking this list for their thoughts and possibly an explanation to this; I happened to notice that some from this list, were listed on that log-in page ;-) From: anne-ology lagin...@gmail.com Date: Tue, Sep 25, 2012 at 10:04 AM Subject: Re: Triaging To: Joel Madero jmadero@gmail.com I've been attempting to sign in - clicking on the URL in #1 below only to uncover various problems: the latest and most consistent is probably due to not answering some math question - I've clicked on each link on this page yet have not located the problem nor the blank to fill in??? I don't understand. On Mon, Sep 24, 2012 at 12:50 PM, Joel Madero jmadero@gmail.com wrote: Hi! First thanks for responding to our call for volunteers, we really appreciate the help :) I was hoping that you could start by doing two things: 1. Go here, https://wiki.documentfoundation.org/QA/QA_Team#QA_Team_volunteers_in_alphabetic_order, and add your name and what not to the list so that we can easily see who is volunteering 2. Go here, https://docs.google.com/spreadsheet/ccc?key=0ApS-XtOUGGH5dDIwaXN1YnNsM0h4RXFKdVhvb2RRb0E#gid=1, pick a sheet, and start triaging as much as possible. Right now our biggest project in QA is getting FDO under control, starting with the backlog of about 850 bugs that are older than 30 days and haven't been touched. I update that sheet somewhat regularly so at times you'll see your sheet gone and you'll have to reassign yourself another one. I'll hopefully be doing that this afternoon at some point but feel free to start whenever you have the time. If you have any questions don't hesitate to email me or add me on gchat/skype/etc... Thanks again, Joel -- 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] help needed ...
... 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 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, stating this error, yet never explaining HOW to correct this error ;-( After trying - and with the same results - half a dozen times, I wrote this Joel back - [1st below] a few days later, he finally responded but ONLY to having received my e-mail, rather than responding to HOW to log-in. When I initially offered to help, I did so in good faith, yet now I'm thinking that either that initial letter and/or his response was some joke; I'm asking this list for their thoughts and possibly an explanation to this; I happened to notice that some from this list, were listed on that log-in page ;-) From: anne-ology lagin...@gmail.com Date: Tue, Sep 25, 2012 at 10:04 AM Subject: Re: Triaging To: Joel Madero jmadero@gmail.com I've been attempting to sign in - clicking on the URL in #1 below only to uncover various problems: the latest and most consistent is probably due to not answering some math question - I've clicked on each link on this page yet have not located the problem nor the blank to fill in??? I don't understand. On Mon, Sep 24, 2012 at 12:50 PM, Joel Madero jmadero@gmail.com wrote: Hi! First thanks for responding to our call for volunteers, we really appreciate the help :) I was hoping that you could start by doing two things: 1. Go here, https://wiki.documentfoundation.org/QA/QA_Team#QA_Team_volunteers_in_alphabetic_order, and add your name and what not to the list so that we can easily see who is volunteering 2. Go here, https://docs.google.com/spreadsheet/ccc?key=0ApS-XtOUGGH5dDIwaXN1YnNsM0h4RXFKdVhvb2RRb0E#gid=1, pick a sheet, and start triaging as much as possible. Right now our biggest project in QA is getting FDO under control, starting with the backlog of about 850 bugs that are older than 30 days and haven't been touched. I update that sheet somewhat regularly so at times you'll see your sheet gone and you'll have to reassign yourself another one. I'll hopefully be doing that this afternoon at some point but feel free to start whenever you have the time. If you have any questions don't hesitate to email me or add me on gchat/skype/etc... Thanks again, Joel -- 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: [Writer] Data to Fields is not working
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 which fills out the fields with actual data. 5. Print and deny printing a serial letter. -- View this message in context: http://nabble.documentfoundation.org/Writer-Data-to-Fields-is-not-working-tp4010898p4011129.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] attempting to find an answer and instead ...
... 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 receiving this same treatment? BTW - just what is a ping??? On Thu, Oct 4, 2012 at 3:50 PM, Joel Madero jmadero@gmail.com wrote: I'm sorry but this is completely inappropriate. An email directly to me would have been much better. I've tried to figure out what the problem is and as I have mentioned, I work full time and am getting ready for law school, I also do about 10 other things for LibO so my time is stretched. I honestly have no idea what the problem is, every other volunteer has had no problem following the instructions. You specifically told you I couldn't figure out what you were facing, a screenshot, or something, would have been a helpful thing to give me. Furthermore, you could have sent me a ping to ask if there was an update. A few of the things in the email that particulary were not written well. This Joel, you didn't say that I EXPLAINED that I am incredibly busy, that I emailed the list as a joke or a ruse also isn't okay. Regards, Joel On Thu, Oct 4, 2012 at 1:43 PM, 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 to be found?] Therefore, the log-in merely goes round and round, stating this error, yet never explaining HOW to correct this error ;-( After trying - and with the same results - half a dozen times, I wrote this Joel back - [1st below] a few days later, he finally responded but ONLY to having received my e-mail, rather than responding to HOW to log-in. When I initially offered to help, I did so in good faith, yet now I'm thinking that either that initial letter and/or his response was some joke; I'm asking this list for their thoughts and possibly an explanation to this; I happened to notice that some from this list, were listed on that log-in page ;-) From: anne-ology lagin...@gmail.com Date: Tue, Sep 25, 2012 at 10:04 AM Subject: Re: Triaging To: Joel Madero jmadero@gmail.com I've been attempting to sign in - clicking on the URL in #1 below only to uncover various problems: the latest and most consistent is probably due to not answering some math question - I've clicked on each link on this page yet have not located the problem nor the blank to fill in??? I don't understand. On Mon, Sep 24, 2012 at 12:50 PM, Joel Madero jmadero@gmail.comwrote: Hi! First thanks for responding to our call for volunteers, we really appreciate the help :) I was hoping that you could start by doing two things: 1. Go here, https://wiki.documentfoundation.org/QA/QA_Team#QA_Team_volunteers_in_alphabetic_order, and add your name and what not to the list so that we can easily see who is volunteering 2. Go here, https://docs.google.com/spreadsheet/ccc?key=0ApS-XtOUGGH5dDIwaXN1YnNsM0h4RXFKdVhvb2RRb0E#gid=1, pick a sheet, and start triaging as much as possible. Right now our biggest project in QA is getting FDO under control, starting with the backlog of about 850 bugs that are older than 30 days and haven't been touched. I update that sheet somewhat regularly so at times you'll see your sheet gone and you'll have to reassign yourself another one. I'll hopefully be doing that this afternoon at some point but feel free to start whenever you have the time. If you have any questions don't hesitate to email me or add me on gchat/skype/etc... Thanks again, Joel -- 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] attempting to find an answer and instead ...
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 treating me in this manner, I'm sure others have received and/or will be receiving this same treatment? BTW - just what is a ping??? Again not appropriate and you'll find a hard time getting involved with ANY open source project if you make clearly private messages public. I apologize that you are struggling so much with getting a wiki account BUT there are generally accepted ways of going about communicating and one of those is not making private conversations public. Since you went ahead and did so I'll keep it public so that you aren't spamming users with my personal replies. 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? I hope you find the assistance you need from another user and or volunteer. Regards, Joel On Thu, Oct 4, 2012 at 3:50 PM, Joel Madero jmadero@gmail.com wrote: I'm sorry but this is completely inappropriate. An email directly to me would have been much better. I've tried to figure out what the problem is and as I have mentioned, I work full time and am getting ready for law school, I also do about 10 other things for LibO so my time is stretched. I honestly have no idea what the problem is, every other volunteer has had no problem following the instructions. You specifically told you I couldn't figure out what you were facing, a screenshot, or something, would have been a helpful thing to give me. Furthermore, you could have sent me a ping to ask if there was an update. A few of the things in the email that particulary were not written well. This Joel, you didn't say that I EXPLAINED that I am incredibly busy, that I emailed the list as a joke or a ruse also isn't okay. Regards, Joel On Thu, Oct 4, 2012 at 1:43 PM, 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 to be found?] Therefore, the log-in merely goes round and round, stating this error, yet never explaining HOW to correct this error ;-( After trying - and with the same results - half a dozen times, I wrote this Joel back - [1st below] a few days later, he finally responded but ONLY to having received my e-mail, rather than responding to HOW to log-in. When I initially offered to help, I did so in good faith, yet now I'm thinking that either that initial letter and/or his response was some joke; I'm asking this list for their thoughts and possibly an explanation to this; I happened to notice that some from this list, were listed on that log-in page ;-) From: anne-ology lagin...@gmail.com Date: Tue, Sep 25, 2012 at 10:04 AM Subject: Re: Triaging To: Joel Madero jmadero@gmail.com I've been attempting to sign in - clicking on the URL in #1 below only to uncover various problems: the latest and most consistent is probably due to not answering some math question - I've clicked on each link on this page yet have not located the problem nor the blank to fill in??? I don't understand. On Mon, Sep 24, 2012 at 12:50 PM, Joel Madero jmadero@gmail.com wrote: Hi! First thanks for responding to our call for volunteers, we really appreciate the help :) I was hoping that you could start by doing two things: 1. Go here, https://wiki.documentfoundation.org/QA/QA_Team#QA_Team_volunteers_in_alphabetic_order , and add your name and what not to the list so that we can easily see who is volunteering 2. Go here, https://docs.google.com/spreadsheet/ccc?key=0ApS-XtOUGGH5dDIwaXN1YnNsM0h4RXFKdVhvb2RRb0E#gid=1 , pick a sheet, and start triaging as much as possible. Right now our biggest project in QA is getting FDO under control, starting with the backlog of about 850 bugs that are older than 30 days and haven't been touched. I update that sheet somewhat regularly so at times you'll see your sheet gone and you'll have to reassign yourself another one. I'll hopefully be doing that this afternoon at some point but feel free to start whenever you have the time. If you have any questions don't hesitate to email me or add me on gchat/skype/etc... Thanks again, Joel -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems?
Re: [libreoffice-users] Re: [Writer] Data to Fields is not working
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 these fields I can open Mail merge and go directly to last step and generate final document. So, Mail merge will be able to use these fields without ever clicking Data to Fields button, which purpose I am failing to understand. -- 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] MS renting office products
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 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 (15-year-old software) could do, and do it just as well and just as easily. If LO could do THAT, it would eat Microsoft's lunch. -- Tim Deaton === On 10/2/2012 2:45 AM, Marcello Romani wrote: Il 24/09/2012 17:15, Mirosław Zalewski ha scritto: On 24/09/2012 at 16:48, webmaster-Kracked_P_P webmas...@krackedpress.com wrote: We need to keep it with the needed options for the 90% average users and not for those that are in the last 10% or even those in the last 1% or less users that do so complex work that the average user could not figure out why this is being done or even how to do such a thing even with the needed documentation. I totally disagree. If user is unable to do something he wants with open documentation, then this is documentation fault. It should be fixed (made clear, verbose, use screenshots or anything), not feature should be disabled. There are many ways to speed up opening of programs. Some features may be delayed or loaded on request. Application can be modularized - core features are loaded by default, other are loaded only if user wants them (take a look at LaTeX, GNU R, Miranda (instant messenger), even Mozilla Firefox to some avail). *Removing* features is total no-go, because it will drive away these users who need them. And I don't think that LO is application only for 90% of it's current users. As much as I hate me too! e-mails... ;P -- 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: Import XML files?
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 pane into a sheet which creates a refreshable link. XSLT and ODF office suites: http://www.ibm.com/developerworks/xml/library/x-oocalc/ http://www.ibm.com/developerworks/xml/tutorials/x-xsltopenoff/index.html [9 pages] There are various topics on the OOo forums: http://www.oooforum.org/forum/viewtopic.phtml?t=67906 http://forum.openoffice.org/en/forum/viewtopic.php?t=3490f=45 -- View this message in context: http://nabble.documentfoundation.org/Import-XML-files-tp4010875p4011135.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] attempting to find an answer and instead ...
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 computer networking field assume: Ping, a computer network tool used to test whether a particular host is reachable across an IP network Colloquially, it is used as you define it - to send a quick message to someone to see what's going on in their life. As in I haven't heard from him for a while - I'm going to ping him to see what he's up to. Girvin Herr -- 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] help needed ...
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 w/ LO To: users@global.libreoffice.org Cc: Joel jmadero@gmail.com 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, stating this error, yet never explaining HOW to correct this error ;-( After trying - and with the same results - half a dozen times, I wrote this Joel back - [1st below] a few days later, he finally responded but ONLY to having received my e-mail, rather than responding to HOW to log-in. When I initially offered to help, I did so in good faith, yet now I'm thinking that either that initial letter and/or his response was some joke; I'm asking this list for their thoughts and possibly an explanation to this; I happened to notice that some from this list, were listed on that log-in page ;-) From: anne-ology lagin...@gmail.com Date: Tue, Sep 25, 2012 at 10:04 AM Subject: Re: Triaging To: Joel Madero jmadero@gmail.com I've been attempting to sign in - clicking on the URL in #1 below only to uncover various problems: the latest and most consistent is probably due to not answering some math question - I've clicked on each link on this page yet have not located the problem nor the blank to fill in??? I don't understand. On Mon, Sep 24, 2012 at 12:50 PM, Joel Madero jmadero@gmail.com wrote: Hi! First thanks for responding to our call for volunteers, we really appreciate the help :) I was hoping that you could start by doing two things: 1. Go here, https://wiki.documentfoundation.org/QA/QA_Team#QA_Team_volunteers_in_alphabetic_order , and add your name and what not to the list so that we can easily see who is volunteering 2. Go here, https://docs.google.com/spreadsheet/ccc?key=0ApS-XtOUGGH5dDIwaXN1YnNsM0h4RXFKdVhvb2RRb0E#gid=1 , pick a sheet, and start triaging as much as possible. Right now our biggest project in QA is getting FDO under control, starting with the backlog of about 850 bugs that are older than 30 days and haven't been touched. I update that sheet somewhat regularly so at times you'll see your sheet gone and you'll have to reassign yourself another one. I'll hopefully be doing that this afternoon at some point but feel free to start whenever you have the time. If you have any questions don't hesitate to email me or add me on gchat/skype/etc... Thanks again, Joel You will need to sign into the wiki and add your name to the list on the page https://wiki.documentfoundation.org/QA/QA_Team#QA_Team_volunteers_in_alphabetic_order Once you have done this , please open the Google Docs spreadsheet and select a tab to add your name to it. I recommend using Google Chrome to access the google docs page hope this helps -- -- Masekela Walls Web Security Analyst | Senior Server Administrator Powserve.com / Gemini ISP Networks -- 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] [Writer] Data to Fields is not working
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 Sources) 3. Select bibliography table biblio 4. Press left-most cell of any row to select entire row (without this step Data to Text nor Data to Fields button is not clickable). 5. Click the Data to Text button to select what will be copied from the selected row in the Data Sources window to the text documents. 6. A dialog opens giving three choices: paste the data in table format, as fields, or as text. The first and third choices are result in text being pasted. 7. The Data to Fields button works only if you have selected Fields in the dialog. To change the data showing in the fields in the text document, select another row. Then click this button. In other words, you have to use Data to Text button to create the fields before you can put any other data in these fields using the Data to Text button. I am afraid it still does not work as described. When I click Data to Text, new window appears. I check Fields and then move (using arrow button) field from left column to right one. When I click OK, this window disappears, but field appears right in my document. Clicking Data to Fields still does not do anything visible. What version of LO are you using? It might be that mine is buggy or your outdated and that's why we see different behaviors. Question: Did you click a different row to highlight the whole row before clicking Data to Text button? (Click the rectangle at the left end of the row.) Unless you select another row, you will see no changes. Step 4 of your original email is the process you need to use here. My LO versions in which it works: 3.4.6, 3.5.6, AND 3.6.2.2. All of them are Debian 64 bit downloaded and installed from the LO website. (I don't use the versions found in Linux distribution repositories.) -- 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: Import XML files?
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 dump the imported data from the data source pane into a sheet which creates a refreshable link. XSLT and ODF office suites: http://www.ibm.com/developerworks/xml/library/x-oocalc/ http://www.ibm.com/developerworks/xml/tutorials/x-xsltopenoff/index.html [9 pages] There are various topics on the OOo forums: http://www.oooforum.org/forum/viewtopic.phtml?t=67906 http://forum.openoffice.org/en/forum/viewtopic.php?t=3490f=45 Hi Andreas. The file with that XML snippit is uploaded to a MySQL database behind Rails every 15 minutes. From time to time I load it into calc to provide quick lists of extracted data to our sales guys who cope fare easier with a spread sheet. Steve -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: Import XML files?
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 (help.libreoffice.org/Common/About_Import_and_Export_Filters) suggests it ought to be doable but gives no details whatsoever. Anyone got any pointers I could use? Regars Mark Stanton Well, if you implemented your own XML format then you should know the appropriate software for your particular data structures. If there is some reason why you want to open your file format in this office suite then you have to write an XSLT script translating your specific XML flavour into ODF for import and possibly vice versa for export. -- 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: Import XML files?
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. Without a filter to transform it into something readable/formattable by one of the apps of the suite, at best you could possibly open it in Writer as plain text. The installed XML/XSLT filters that come with LO are : Docbook from SXW (old binary StarOffice/OOo format) - import/export MediaWiki - export Mediawiki_web - export MS Excel 2003 XML - import/export MS Word 2003 XML - import/export UOF Presentation - import/export UOF Spreadsheet - import/export UOF Text - import/export XHTML Calc - export XHTML Writer - export XHTML Draw - export XHTML Impress - export Alex -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [libreoffice-users] attempting to find an answer and instead ...
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 - interesting that's it's ping rather than p-ring p-ring p-ring ... On Thu, Oct 4, 2012 at 5:10 PM, Girvin R. Herr girvin.h...@sbcglobal.netwrote: 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/**Pinghttps://en.wikipedia.org/wiki/Ping But those of us in the computer networking field assume: Ping, a computer network tool used to test whether a particular host is reachable across an IP network Colloquially, it is used as you define it - to send a quick message to someone to see what's going on in their life. As in I haven't heard from him for a while - I'm going to ping him to see what he's up to. Girvin Herr -- 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] help needed ...
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 not been able to locate it on this site ;-( ] On Thu, Oct 4, 2012 at 5:43 PM, Mas tier3supp...@gmail.com wrote: 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 w/ LO To: users@global.libreoffice.org Cc: Joel jmadero@gmail.com 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, stating this error, yet never explaining HOW to correct this error ;-( After trying - and with the same results - half a dozen times, I wrote this Joel back - [1st below] a few days later, he finally responded but ONLY to having received my e-mail, rather than responding to HOW to log-in. When I initially offered to help, I did so in good faith, yet now I'm thinking that either that initial letter and/or his response was some joke; I'm asking this list for their thoughts and possibly an explanation to this; I happened to notice that some from this list, were listed on that log-in page ;-) From: anne-ology lagin...@gmail.com Date: Tue, Sep 25, 2012 at 10:04 AM Subject: Re: Triaging To: Joel Madero jmadero@gmail.com I've been attempting to sign in - clicking on the URL in #1 below only to uncover various problems: the latest and most consistent is probably due to not answering some math question - I've clicked on each link on this page yet have not located the problem nor the blank to fill in??? I don't understand. On Mon, Sep 24, 2012 at 12:50 PM, Joel Madero jmadero@gmail.com wrote: Hi! First thanks for responding to our call for volunteers, we really appreciate the help :) I was hoping that you could start by doing two things: 1. Go here, https://wiki.documentfoundation.org/QA/QA_Team#QA_Team_volunteers_in_alphabetic_order , and add your name and what not to the list so that we can easily see who is volunteering 2. Go here, https://docs.google.com/spreadsheet/ccc?key=0ApS-XtOUGGH5dDIwaXN1YnNsM0h4RXFKdVhvb2RRb0E#gid=1 , pick a sheet, and start triaging as much as possible. Right now our biggest project in QA is getting FDO under control, starting with the backlog of about 850 bugs that are older than 30 days and haven't been touched. I update that sheet somewhat regularly so at times you'll see your sheet gone and you'll have to reassign yourself another one. I'll hopefully be doing that this afternoon at some point but feel free to start whenever you have the time. If you have any questions don't hesitate to email me or add me on gchat/skype/etc... Thanks again, Joel You will need to sign into the wiki and add your name to the list on the page https://wiki.documentfoundation.org/QA/QA_Team#QA_Team_volunteers_in_alphabetic_order Once you have done this , please open the Google Docs spreadsheet and select a tab to add your name to it. I recommend using Google Chrome to access the google docs page hope this helps -- 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] seperatiors between cross reference elements
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 added automatically between [heading number] and [heading text] . Any hint is welcome. I am using LO 3.5.6.on XP. If such a possibility is not given, where can send an enhancement request to? Thanks in advance. ROSt -- 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: MS raised prices so people will now start renting their office products instead
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 (15-year-old software) could do, and do it just as well and just as easily. If LO could do THAT, it would eat Microsoft's lunch. Absolutely agree. Most of the functionality that MS has added to Office 2007/2010 has been geared towards the corporate collaborative user, which certainly in my experience (and I have to say my last corporate job was over ten years ago so the playing field may well have changed in this respect) wasn't a key factor in usage, and certainly has never been in the SOHO sector. I believe that Office 2013 is even more aimed at cloud and collaborative usage - although it's highly probable that I shan't ever find out! One of the problems that I've come across is that my daughter uses LO and sends as MS Office 97-2003 documents when emailing. It appears that her recipients get gobbledy-gook so I need to find out what's happening there because that shouldn't happen. IMHO LO is every bit as good as MS Office 97, but then that wasn't a particularly good iteration of MS Office! I think the aim should be to match Office 2003, which still seems to be the current standard by which Office suites are measured. (The very large international company my Wife works for are still on 2003..) Both comments (Tim, Gorden) are valuable. I switched to LO about 6 months ago and like it also I am missing (compared to MSO) a few features in IMPRESS badly I am not the expert to really compare LO features with MSO 97 and 2003. Which version ever is used to be the comparison standard is not that important to me. But what is IMHO important is that all MSO97 features in and all bugs out. But don't take out features which are beyond MSO97 only get the bugs out. LO must become a very solid bug free production tool. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
[libreoffice-users] Re: calc cells spacing to contents not working as it should
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 (does not support cell spacing) Free software has gone beyond MS, Viva Libre Office -- View this message in context: http://nabble.documentfoundation.org/calc-cells-spacing-to-contents-not-working-as-it-should-tp4010934p4011165.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] attempting to find an answer and instead ...
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 cross between ring and pc - interesting that's it's ping rather than p-ring p-ring p-ring ... quotation from List of computer term etymologies http://en.wikipedia.org/wiki/List_of_computer_term_etymologies 'The author of ping, Mike Muuss, named it after the pulses of sound made by a sonar called a ping. Later Dave Mills provided the backronym Packet Internet Groper.' probably better to look things up than speculate. although not sure how reliable wikipedia is. I recall WWII movies where the crew of submarines suffered silently through 'pings' from enemy warships on the surface trying to locate them. F. On Thu, Oct 4, 2012 at 5:10 PM, Girvin R. Herr girvin.h...@sbcglobal.netwrote: 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/**Pinghttps://en.wikipedia.org/wiki/Ping But those of us in the computer networking field assume: Ping, a computer network tool used to test whether a particular host is reachable across an IP network Colloquially, it is used as you define it - to send a quick message to someone to see what's going on in their life. As in I haven't heard from him for a while - I'm going to ping him to see what he's up to. Girvin Herr -- Felmon Davis There are no failures at a class reunion. -- 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] Help request on CALC charts' features
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 observed: 1. The full worksheet as chart in excel are converted to embedded charts in those sheets (no full charts). 2. Legends are peculiar. They are named as column? and not any text string that I would like to give. Is this the way Libre Calc is implemented or I can get back to chart as worksheet in itself and legends of my liking without being restricted to the first column/ first row? Also, is the system info below sufficient for posting here or anything more is advised? Any pointers would be great help. Thanks, Viral Orpe -- Processor : Intel(R) Pentium(R) Dual Core E6600 CPU 3.00GHz Memory: 4GB, DDR3 Operating System: Linux Mint 12 Lisa - Kernel Linux 3.0.0-13-generic (i686) LibreOffice Version : LibreOffice 3.4.3 OOO340m1 (Build:302) -- 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] query re. volunteering w/ LO
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 to be found?] Therefore, the log-in merely goes round and round, stating this error, yet never explaining HOW to correct this error ;-( After trying - and with the same results - half a dozen times, I wrote this Joel back - [1st below] a few days later, he finally responded but ONLY to having received my e-mail, rather than responding to HOW to log-in. When I initially offered to help, I did so in good faith, yet now I'm thinking that either that initial letter and/or his response was some joke; I'm asking this list for their thoughts and possibly an explanation to this; I happened to notice that some from this list, were listed on that log-in page ;-) From: anne-ology lagin...@gmail.com Date: Tue, Sep 25, 2012 at 10:04 AM Subject: Re: Triaging To: Joel Madero jmadero@gmail.com I've been attempting to sign in - clicking on the URL in #1 below only to uncover various problems: the latest and most consistent is probably due to not answering some math question - I've clicked on each link on this page yet have not located the problem nor the blank to fill in??? I don't understand. On Mon, Sep 24, 2012 at 12:50 PM, Joel Madero jmadero@gmail.com wrote: Hi! First thanks for responding to our call for volunteers, we really appreciate the help :) I was hoping that you could start by doing two things: 1. Go here, https://wiki.documentfoundation.org/QA/QA_Team#QA_Team_volunteers_in_alphabetic_order, and add your name and what not to the list so that we can easily see who is volunteering 2. Go here, https://docs.google.com/spreadsheet/ccc?key=0ApS-XtOUGGH5dDIwaXN1YnNsM0h4RXFKdVhvb2RRb0E#gid=1, pick a sheet, and start triaging as much as possible. Right now our biggest project in QA is getting FDO under control, starting with the backlog of about 850 bugs that are older than 30 days and haven't been touched. I update that sheet somewhat regularly so at times you'll see your sheet gone and you'll have to reassign yourself another one. I'll hopefully be doing that this afternoon at some point but feel free to start whenever you have the time. If you have any questions don't hesitate to email me or add me on gchat/skype/etc... Thanks again, Joel Have you attempted to create an account per the first link? (Upper right hand corner) And do you have cookies enabled? This is under Firefox 15.0 on linux. Where are you getting this math from? There is no math involved and no mathematical answer required. I am just an end user without the knowledge required for QA work but had no trouble joining the list. Just followed the directions!. Tom -- “What we do for ourselves dies with us. What we do for others and the world remains and is immortal.” Albert Pine -- Tom Taylor - retired penguin AMD Phenom II x4 955 -- 4GB RAM -- 2x1.5TB sata2 openSUSE 12.1x86_64openSUSE 12.2x86_64 KDE 4.7.2, FF 7.0 KDE 4.8.4, FF 13.0 claws-mail 3.8.0 registered linux user 263467 linxt-At-comcast-DoT-net -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted