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

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

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

The files were saved as .xls (excel files) forgot to mention it in my earlier mail -- View this message in context: http://nabble.documentfoundation.org/calc-cells-spacing-to-contents-not-working-as-it-should-tp4010934p4010938.html Sent from the Users mailing list archive at Nabble.com. -- F

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

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 L

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

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 subsidia

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

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 mon

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

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 gener

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.

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

[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. 1.43 ertzuiopdfghjklöxcvbnm How wou

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

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

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 >To: users@global.libreoffice.org >Sent: Thursday, 4 October 2012, 13:09 >S

[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. J

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

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

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

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 l

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

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 wrote: > I downloaded the hybrid pdf from here http://blog.** > document

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

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

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

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

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 wrote: > On 10/04/2012 11:04 AM

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

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

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

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

[libreoffice-users] Re: Import XML files?

FoxPro export exports database fields like this: 12345 01/01/2004 123 01 1450 02 2480 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

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 >To: Gordon Burgess-Parker >Cc: Libre Office Us

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

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 Any clue? --~--~-~--~~~

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 >> Any clue? > > If the first three columns (A-C) are 'lastname' (A), 'middle-name'(B), > an

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" >To: "users@global.libreoffice.or

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

Dan, Thanks for your reply. On 04/10/2012 at 01:50, Dan Lewis 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-

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 expor

[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, statin

[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 Date: Thu, Oct 4, 2012 at 3:43 PM Subject: query re. volunteering w/ LO To: users@global.libreoffice.org Cc: Joel Back when I received this response [2

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

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

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

On Thu, Oct 4, 2012 at 2:09 PM, anne-ology 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 th

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

Andreas, On 04/10/2012 at 23:08, Andreas Säger 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 ope

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 wrote: I don't think we need to remove existin

[libreoffice-users] Re: Import XML files?

MySQL can import your : http://dev.mysql.com/doc/refman/5.5/en/load-xml.html If there is any reason why you want 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. XS

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

Joel Madero wrote: 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?" Joel, "ping", another overloaded word: https://en.wikipedia.org/wiki/Ping But those of us in the compute

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

On Thu, Oct 4, 2012 at 4:54 PM, anne-ology wrote: >... how were you able to log-in and get your names posted on that > list? >what am I doing wrong? > > > > From: anne-ology > Date: Thu, Oct 4, 2012 at 3:43 PM > Subject: query re. volunteering w/ LO > To: users@global.lib

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

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

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

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

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

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

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 n

[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

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

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

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

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

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

On Thu, 4 Oct 2012 15:43:34 -0500 anne-ology 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?]