Re: [libreoffice-users] OEditModel - set focus pre-select all text?
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, and Libre Basic to manipulate them. So far I have had success, pulling test from a text box, pulling text from cells on the sheet, changing the list of strings shown in a list box and handling button clicks. Now I would like to improve the UI (from my point of view), such that once the button click handler has done its job, the code sets the focus back to the initial text box I was typing in and preselects all text, so that I can immediately start typing the next name to work with. I've Googled the heck out of it with various terms, looked through the SDK docs and I'm using XRAY to see the properties and methods of the controls, which is how I got this far... but none of them are helping now. I see no property or method relating to selection or focus. I *do* see a Start and End property, which are text ranges, but I don't quite understand what they represent; I would have expected just one range representing the first and last selected character positions - if they are even related to selection. I read somewhere that there's a SetFocus() method but that it is on the *view* aspect of the edit box. No problem... but I can't find a way to access the view portion either :( There are lots of examples out there - many are even for forms - but none seem to deal with focus or selection. Can anyone point me towards some information on how to access such things? I can't even get the selected text if I needed to. Thanks. -- View this message in context: http://nabble.documentfoundation.org/OEditModel-set-focus-pre-select-all-text-tp4150087.html Sent from the Users mailing list archive at Nabble.com. -- Andrew Pitonyak My Macro Document: http://www.pitonyak.org/AndrewMacro.odt Info: http://www.pitonyak.org/oo.php -- To unsubscribe e-mail to: users+unsubscr...@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] LOOKUP with 2 values in 2 columns
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 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 title2 C2 297 b title3 C3 298 1 title4 C1 298 2 title5 C3 A B xx 299 title6 C2 This is in the lab Mainlist. In another tab (performed) I just want to reference number and subnumber, and get the title, composer, arranger, etc. from the Main list. How can I lookup 2 values set in Performed E1 and F1 in the main list? Insert an extra column - I'll call it C - between the subnumbers and the titles. In Cn, enter =AnBn This will concatenate the values in the first two columns, to give 297a, 2982, etc. You can hide that column if you prefer, so it does not need to display or print. To harvest the title, use: =VLOOKUP(E1F1;Mainlist.C1:H999;2;0) To harvest the composer: =VLOOKUP(E1F1;Mainlist.C1:H999;3;0) and so on . I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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: LOOKUP with 2 values in 2 columns
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 (have 3 columns) or a single column with just the combined code e.g. 297_b and do the lookup from the Mainlist If someone knows a more elegant/efficient way I would also be interested in learning. Hope this helps. Pedro -- View this message in context: http://nabble.documentfoundation.org/LOOKUP-with-2-values-in-2-columns-tp4150874p4150884.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@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: LOOKUP with 2 values in 2 columns
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? 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] LOOKUP with 2 values in 2 columns
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 298 1 title4 C1 298 2 title5 C3 A B xx 299 title6 C2 This is in the lab Mainlist. In another tab (performed)I just want to reference number and subnumber, and get the title, composer, arranger, etc. from the Main list. How can I lookup 2 values set in Performed E1 and F1 in the main list? -- To unsubscribe e-mail to: users+unsubscr...@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] LOOKUP with 2 values in 2 columns
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 a sub-number or letter in col B. Something like: 296 title1 ComposerArr.textpublisher 297 a title2 C2 297 b title3 C3 298 1 title4 C1 298 2 title5 C3 A B xx 299 title6 C2 This is in the lab Mainlist. In another tab (performed) I just want to reference number and subnumber, and get the title, composer, arranger, etc. from the Main list. How can I lookup 2 values set in Performed E1 and F1 in the main list? Insert an extra column - I'll call it C - between the subnumbers and the titles. In Cn, enter =AnBn This will concatenate the values in the first two columns, to give 297a, 2982, etc. You can hide that column if you prefer, so it does not need to display or print. To harvest the title, use: =VLOOKUP(E1F1;Mainlist.C1:H999;2;0) To harvest the composer: =VLOOKUP(E1F1;Mainlist.C1:H999;3;0) and so on . I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@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 -- To unsubscribe e-mail to: users+unsubscr...@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] LOOKUP with 2 values in 2 columns
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 title2 C2 297 b title3 C3 298 1 title4 C1 298 2 title5 C3 A B xx 299 title6 C2 This is in the lab Mainlist. In another tab (performed) I just want to reference number and subnumber, and get the title, composer, arranger, etc. from the Main list. How can I lookup 2 values set in Performed E1 and F1 in the main list? Insert an extra column - I'll call it C - between the subnumbers and the titles. In Cn, enter =AnBn This will concatenate the values in the first two columns, to give 297a, 2982, etc. You can hide that column if you prefer, so it does not need to display or print. To harvest the title, use: =VLOOKUP(E1F1;Mainlist.C1:H999;2;0) To harvest the composer: =VLOOKUP(E1F1;Mainlist.C1:H999;3;0) and so on . I trust this helps. Brian Barker -- To unsubscribe e-mail to: users+unsubscr...@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] GraphicProvider FilterData
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 Graphic takes the size asked by the Filterdata the result of my sub storeGraphicToURL gives a graphic 500x1000 pixels Can someone confirm this behaviour or I am doing something wrong. of course the work around is simple, query first, store to a temp location and query again Thanks for any hint Fernand function getGraphFromUrl(sFileUrl as String) as Object oProvider = createUnoService(com.sun.star.graphic.GraphicProvider) 'creating filter data Dim aFilterData (1) as new com.sun.star.beans.PropertyValue 'properties valid for all filters aFilterData(0).Name = PixelWidth' aFilterData(0).Value = 500 'pixels aFilterData(1).Name = PixelHeight aFilterData(1).Value = 1000 Dim oPropsIN(1)as new com.sun.star.beans.PropertyValue oPropsIN(0).Name = URL oPropsIN(0).Value = sFileUrl oPropsIN(1).Name = FilterData oPropsIN(1).Value = aFilterData() getGraphFromUrl = oProvider.queryGraphic(oPropsIN()) end function sub storeGraphicToURL(xgraphic,exportURL) gProvider = createUnoService(com.sun.star.graphic.GraphicProvider) Dim bArgs(2) as new com.sun.star.beans.PropertyValue 'creating filter data Dim aFilterData (1) as new com.sun.star.beans.PropertyValue 'properties valid for all filters aFilterData(0).Name = PixelWidth' aFilterData(0).Value = 500 aFilterData(1).Name = PixelHeight aFilterData(1).Value = 1000 bArgs(0).Name = URL bArgs(0).Value = exportURL bArgs(1).Name = MimeType bArgs(1).Value = image/jpeg 'geen jpg wel jpeg bArgs(2).Name = FilterData bArgs(2).Value = aFilterdata gProvider.storeGraphic(xgraphic,bArgs()) end sub -- To unsubscribe e-mail to: users+unsubscr...@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