Re: [libreoffice-users] OEditModel - set focus pre-select all text?

2015-06-08 Thread Andrew Douglas Pitonyak
Sorry for the late reply, but, does this help https://forum.openoffice.org/en/forum/viewtopic.php?f=45t=20279 On 05/31/2015 07:28 AM, JTeagle wrote: If this is not the best list for this question, please let me know of a more appropriate one. I'm using a few simple controls on a Calc sheet,

Re: [libreoffice-users] LOOKUP with 2 values in 2 columns

2015-06-08 Thread Rob Jasper
Agree with that! I have no experience with base in combination with the built-in or other dbms's. I do have quite some xperience with various dbms's and SQL though. So, one of these days I'll try it.. Thanks, Rob. On 8 jun. 2015, at 14:58, Brian Barker wrote: At 13:56 08/06/2015 +0200, Rob

[libreoffice-users] Re: LOOKUP with 2 values in 2 columns

2015-06-08 Thread Pedro
Hi Rob Rob wrote How can I lookup 2 values set in Performed E1 and F1 in the main list? I believe it is not possible to lookup in two columns. The best way is to create a combined search field in column C of the Mainlist something like =A1_B1 On the Performed tab you can either do the same

[libreoffice-users] Re: LOOKUP with 2 values in 2 columns

2015-06-08 Thread Andreas Säger
Am 08.06.2015 um 15:03 schrieb Rob Jasper: Agh, I should have thought of this myself. Simple and elegant... A database would be simple and elegant. A spreadsheet lookup is a dirty work-around at best. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org Problems?

[libreoffice-users] LOOKUP with 2 values in 2 columns

2015-06-08 Thread Rob Jasper
Hi, I have a list of music numbers for our choir in calc. Each number is identified by a number in col A, and sometimes a sub-number or letter in col B. Someting like: 296 title1 ComposerArr.textpublisher 297 a title2 C2 297 b title3 C3

Re: [libreoffice-users] LOOKUP with 2 values in 2 columns

2015-06-08 Thread Rob Jasper
Agh, I should have thought of this myself. Simple and elegant... Thanks Brian, Rob. On 8 jun. 2015, at 14:58, Brian Barker wrote: At 13:56 08/06/2015 +0200, Rob Jasper wrote: I have a list of music numbers for our choir in calc. Each number is identified by a number in col A, and sometimes

Re: [libreoffice-users] LOOKUP with 2 values in 2 columns

2015-06-08 Thread Brian Barker
At 13:56 08/06/2015 +0200, Rob Jasper wrote: I have a list of music numbers for our choir in calc. Each number is identified by a number in col A, and sometimes a sub-number or letter in col B. Something like: 296 title1 ComposerArr.textpublisher 297 a

[libreoffice-users] GraphicProvider FilterData

2015-06-08 Thread SOS
When querying a XGraphic from a URL, the size of the Graphic is always the original size coming from the URL, the FilterData seems to been ignored. The result from my function getGraphFromUrl returns always the orginal graphic size and not the demanded 500x1000 pixels When Storing to a URL the