[libreoffice-users] Re: How to put Basic IDE code completion to work

Hi Fernand, On Tue, Mar 18, 2014 at 10:26:08PM +0100, Fernand Vanrie wrote: > Found new Basic IDE options in 4.2 , but where to find some > documentation how this new stuff works ? In worst case, https://speakerdeck.com/vmiklos/gsoc-students-panel starting from slide 53 talks about this topic.

[libreoffice-users] Re: Clarification about ODF Extended

italovignoli wrote > Somewhere in the wiki there is a list of the extended features ... For those interested, these can be found in the ODF Implementor Notes . Best wishes, Owen. -- View this m

[libreoffice-users] Turning spreadsheet data into legible report?

Hello A friend is a school teacher and needs to publish a report from the data she keeps in an Excel document. In addition, she only has access to Word/Excel, while Access is not available (she doesn't know databases, anyway.) I originally thought Word's mail merge would do, but without programmi

Re: [libreoffice-users] Turning spreadsheet data into legible report?

The real question is what sort of report she needs. It's all good and well showing us a screenshot of a document with two sheets, but without knowing what you want to do with that data, there's really no advice we can give. On Wed, 19 Mar 2014 05:54:51 -0700 (PDT) Gilles wrote: > Hello > > A f

[libreoffice-users] Re: Turning spreadsheet data into legible report?

Sorry about that. The spreadsheet 1) has too many columns to fit on a document, even in Landscape mode (she wants Portrait), and 2) data are spread on multiple sheets, one by year. She needs to print the data thusly: = Last Name: Doe First Name : Jane Date of Birth: 12/12/2000 Ye

[libreoffice-users] Re: Turning spreadsheet data into legible report?

Here's a better illustration of what I mean: http://postimg.org/image/hw6kh9vx1/ -- View this message in context: http://nabble.documentfoundation.org/Turning-spreadsheet-data-into-legible-report-tp4102146p4102157.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe

[libreoffice-users] Re: Turning spreadsheet data into legible report?

Le 19/03/2014 15:24, Gilles a écrit : Hi, In theory, a LibreOffice Database report should be able to do something like that, but : - if you bind a Calc or Excel file, you will not be able to write/edit any of the data in the bound Calc or Excel file, as these become read-only - in order to updat

Re: [libreoffice-users] Re: Turning spreadsheet data into legible report?

On 03/19/2014 10:24 AM, Gilles wrote: Here's a better illustration of what I mean: http://postimg.org/image/hw6kh9vx1/ -- View this message in context: http://nabble.documentfoundation.org/Turning-spreadsheet-data-into-legible-report-tp4102146p4102157.html Sent from the Users mailing list a

[libreoffice-users] Mail merge with custom fields in LibreOffice 4.2

At my job we currently use Lotus Symphony and we use the Open Document format exclusively. We're currently in the process of migrating to LibreOffice 4.2. We have a lot of documents we use with the mail merge feature. All of the data sources are from spreadsheets. In Symphony, the spreadsheet colum

Re: [libreoffice-users] Re: Turning spreadsheet data into legible report?

How about using a single sheet for the data, and add an extra column for year? Something like: Year Last NameFirst Name... 2012-2013Doe John ... 2013-2014Doe Jane ... Then mail merge on that. I don't know about Word, but in LO Wri

Re: [libreoffice-users] Mail merge with custom fields in LibreOffice 4.2

On 2014-03-20 07:12, Jeff Prater wrote: At my job we currently use Lotus Symphony and we use the Open Document format exclusively. We're currently in the process of migrating to LibreOffice 4.2. We have a lot of documents we use with the mail merge feature. All of the data sources are from sprea

Re: [libreoffice-users] Re: Turning spreadsheet data into legible report?

Hi :) Would the optimal thing to do be to import that Excel tables into Base and then export into an external back-end? Then enter data using some Form in Base. For the reporting set-up a Report in Writer or Calc? It sounds like it would be a lot of hassle but possibly would end-up with somethin

Re: [libreoffice-users] Re: Turning spreadsheet data into legible report?

On 2014-03-20 02:55, Gilles wrote: Sorry about that. The spreadsheet 1) has too many columns to fit on a document, even in Landscape mode (she wants Portrait), and 2) data are spread on multiple sheets, one by year. She needs to print the data thusly: = Last Name: Doe First Nam

Re: [libreoffice-users] Mail merge with custom fields in LibreOffice 4.2

Yeah--I guess I could do that. But I already have all these fields created. I have probably 50+ documents where I would need to make these manual changes. Plus, the spreadsheets get updated regularly and I don't want to have to reimport/reattach the spreadsheet all the time. I guess I'll have to st

[libreoffice-users] Re: How to put Basic IDE code completion to work

hallo Miklos thanks but only """ and "(" are auto clossing dot operator is not functioning at all (maybe a keyboard problem ?) tab do nothing sub and Function not closing do i something wrong ? using Windows 7 (4.2.2.1) On Tue, Mar 18, 2014 at 10:26:08PM +0100, Fernand Vanrie wrote: Found n

Re: [libreoffice-users] Mail merge with custom fields in LibreOffice 4.2

Hi, I did my database in OO about 10 years ago, maybe more. I haven't fiddled with the fields since then, but they were custom fields. I moved to LO as soon as it was released. I use mail merge extensively, and had no problems having custom named fields working to pull the data from. So there

Re: [libreoffice-users] Mail merge with custom fields in LibreOffice 4.2

That's the problem. Whenever I attempt to do the mail merge, it doesn't list any of the custom fields in my document. It only list "canned" fields. I don't see how I can match my existing fields within this interface. [image: Inline image 2][image: Inline image 1] - Jeff Prater On Wed, Mar

Re: [libreoffice-users] Re: How to put Basic IDE code completion to work

That is the behavior that I have seen :-) On 03/19/2014 04:23 PM, Fernand Vanrie wrote: hallo Miklos thanks but only """ and "(" are auto clossing dot operator is not functioning at all (maybe a keyboard problem ?) tab do nothing sub and Function not closing do i something wrong ? using Window

Re: [libreoffice-users] Mail merge with custom fields in LibreOffice 4.2

Not sure if I've missed the point here - Create a spreadsheet .ods file with 3 columns each column headed - col1, col2, col3 Add two rows populating respective columns my first row contained 1, 2, 3 and the 2nd row a, b ,c so I had a spreadsheet .ods file that looked like this - col1col2

Re: [libreoffice-users] Inserting DRAW file as linked OLE in WRITER file?

Hi Mucip, Is there a good reason for using OLE objects? I have used such for putting tables (Writer) in Draw documents, simply because Writer has much better table handling than Draw, but position control was a bit hit-and-miss. When you add the arrows to the picture, where is the arrow bein

[libreoffice-users] Writer "changes" feature

Anyone know how to "turn on" the "changes" feature of Writer? I can't seem to get it to work. Someone sent me a .doc file. I saved it as .odt because I was unable to get basic features such as color highlighting and other tools normally on that particular toolbar. Now that I have the .odt t

Re: [libreoffice-users] Writer "changes" feature

Click Edit->Changes->Show If you want a running record, click Edit->Changes->Record. On Wed, Mar 19, 2014 at 5:07 PM, A wrote: > Anyone know how to "turn on" the "changes" feature of Writer? I can't seem > to get it to work. > > Someone sent me a .doc file. I saved it as .odt because I was un

Re: [libreoffice-users] Writer "changes" feature

On 2014-03-20 13:07, A wrote: Anyone know how to "turn on" the "changes" feature of Writer? I can't seem to get it to work. Someone sent me a .doc file. I saved it as .odt because I was unable to get basic features such as color highlighting and other tools normally on that particular tool

Re: [libreoffice-users] Writer "changes" feature

On 20/03/2014 11:07 am, A wrote: Anyone know how to "turn on" the "changes" feature of Writer? I can't seem to get it to work. Edit->Changes->Record This setting is saved in the document, so if you or someone else subsequently opens the document, the same settings are used. and if you wan

[libreoffice-users] Re: Inserting DRAW file as linked OLE in WRITER file?

Mucip wrote > I import this DRAW file as linked OLE object. But I can not center the > picture in OLE container/frame? When I adjust it once than it may change > later?! I can not fix the main picture region of the DRAW object in OLE > container/frame? You will need to rescale the ODG prior to ins

Re: [libreoffice-users] Mail merge with custom fields in LibreOffice 4.2

Yes--that does work. However, I already have a bunch of .odt documents mapped with the fields from the .ods spreadsheets. I don't want to have to delete all of the existing fields and reinsert them. I was hoping this would just "work." Also, is there any way to not have LO "cache" (if that's the r

Re: [libreoffice-users] Mail merge with custom fields in LibreOffice 4.2

Okay--I think I found the problem. When I opened one of my .odt documents and hovered over one of the fields, LO didn't seem to recognize it as a field. After going back to Insert > Fields > Other and manually reinserting the fields, the mail merge works correctly. I was hoping I wouldn't have to r

Re: [libreoffice-users] Mail merge with custom fields in LibreOffice 4.2

I have not been following the discussion so I can't comment on anything that's gone before, but one thing I recently learned is that you can keep the fields window open while inserting all your fields. There are arrow buttons/icons that In some cases you can simply click those and it will move

Re: [libreoffice-users] Mail merge with custom fields in LibreOffice 4.2

And thanks to the discussion I think I have a much better understanding and can iron out the problems our users are having with the merge. We keep getting new lists to merge, all the same format. The secret to simplification is, once set up, to have an ods named mergesource.ods or something and