Fai la tua domanda

ago_med's profile - attività

2018-06-14 14:22:18 +0200 received badge  Domande famose (source)
2018-05-14 11:33:13 +0200 received badge  Domande famose (source)
2017-02-27 19:24:36 +0200 received badge  Domanda notevole (source)
2017-02-27 19:19:44 +0200 received badge  Domande famose (source)
2017-02-27 19:18:28 +0200 received badge  Domanda gettonata (source)
2017-02-27 19:18:28 +0200 received badge  Domanda notevole (source)
2016-10-24 20:44:13 +0200 ha risposto a una domanda Button in Macro to Print a Sheet

Thank You so much!!!

It worked ....

2016-10-22 13:11:58 +0200 received badge  Domande famose (source)
2016-10-19 07:46:59 +0200 received badge  Domanda notevole (source)
2016-10-18 19:16:27 +0200 received badge  Domanda gettonata (source)
2016-10-18 02:00:10 +0200 ha posto una domanda Button in Macro to Print a Sheet

Good Night..

I need a macro code to associate a button in order to Print a sheet, in Libreoffice Calc...

Can someone help me ?

Thanks a lot!

2016-10-17 19:51:14 +0200 received badge  Domanda notevole (source)
2016-10-17 19:21:54 +0200 ha risposto a una domanda Open Libreoffice Calc in FullScreen...

I found a code that worked perfectly....

sub startFullScreen()

   dim document   as object
   dim dispatcher as object

   document   = ThisComponent.CurrentController.Frame
   dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")

   dim args(0) as new com.sun.star.beans.PropertyValue
   args(0).Name = "FullScreen"
   args(0).Value = True

   dispatcher.executeDispatch(document, ".uno:FullScreen", "", 0, args())

end sub
2016-10-17 18:59:46 +0200 ha commentato una domanda Open Libreoffice Calc in FullScreen...

don't work... i need a new code to do this... can someone help me ?

2016-10-17 18:59:11 +0200 ha commentato una risposta Open Libreoffice Calc in FullScreen...

i need a new code to do this...

2016-10-17 18:58:59 +0200 ha commentato una risposta Open Libreoffice Calc in FullScreen...

can you help me ???

2016-10-17 18:58:43 +0200 ha commentato una risposta Open Libreoffice Calc in FullScreen...

don't work....

2016-10-03 00:50:53 +0200 received badge  Entusiasta
2016-10-01 21:51:33 +0200 received badge  Domande famose (source)
2016-09-30 23:01:15 +0200 ha commentato una domanda Move list box items to a specific sheet

Ok... Thanks....

2016-09-30 22:56:57 +0200 ha commentato una risposta Open Libreoffice Calc in FullScreen...

I'll test the macro in a few minutes

2016-09-30 21:54:57 +0200 received badge  Domanda gettonata (source)
2016-09-30 20:28:45 +0200 received badge  Commentatore
2016-09-30 20:28:45 +0200 ha commentato una risposta Open Libreoffice Calc in FullScreen...

I'll test at night... but i think that won't work because My initial code didn't work...

2016-09-30 19:53:56 +0200 received badge  Sostenitore (source)
2016-09-30 18:33:12 +0200 ha accettato una risposta Move list box items to a specific sheet

(See also : https://forum.openoffice.org/en/forum...; edited by @Lupp )

Good Afternoon.

I'm realizing a program in libreoffice calc...

At the moment, i want to move list box ("ListBox_Previa") items to a specific area ("D60 - D71") of a sheet ("EVOLUCAO").

i need to a macro to do this work when i click in a button in a dialog...

someone can i help me ? please.. urgent!!!

Edit: moved from answer posted by @ago_med

i'll explain with pictures...

The first image show the dialog that contains, at the right, the "ListBox_Previa" named ("PREVIA DA PRESCRICAO MEDICA").

image description

In the Listbox exists 4 itens... This itens, i need to move, when i click at the button "Finalizar Prescriçao", to a specific sheet named "EVOLUCAO" between D60 - D71, how show the seoond image below...

image description

Thanks for everything...

2016-09-30 18:33:12 +0200 received badge  Studioso (source)
2016-09-30 18:17:59 +0200 received badge  Domanda gettonata (source)
2016-09-30 04:34:22 +0200 ha commentato una domanda Open Libreoffice Calc in FullScreen...

fullscreen.. i don't want to show menus.. only the cells of the sheet...

2016-09-30 04:32:08 +0200 ha commentato una risposta Search In Dialog with Listbox

it's work perfectly...

thanks a lot mark_t....

you're help me a lot...

2016-09-30 03:34:11 +0200 ha commentato una risposta Initialize Dialog Selecting First Item to Listbox...

Thanks mark_t...

it's working...

2016-09-30 03:06:11 +0200 ha commentato una domanda Search In Dialog with Listbox

there is between ("A1:A400") at the ("Plan1")....

2016-09-30 03:00:26 +0200 ha posto una domanda Open Libreoffice Calc in FullScreen...

I need to open the File ("01_MODELO_PRESCRICAO_UEM") in fullscreen...

Who can help me ???

I have this macro, but don't working..

Sub AbreTelaInteira
    oSheet = ThisComponent.Sheets.getByName("01_MODELO_PRESCRICAO_UEM")
    oController = ThisComponent.CurrentController

    With oController
        .setActiveSheet(oSheet)
        .ColumnRowHeaders = False
        .SheetTabs = False
        .Frame.LayoutManager.HideCurrentUI = True
    End With
End Sub

Edit to place code inside a code block

2016-09-30 02:55:58 +0200 ha commentato una domanda Search In Dialog with Listbox

the list of items is in the spreadsheet ("Plan1")...

2016-09-30 02:55:23 +0200 ha commentato una domanda Search In Dialog with Listbox

yes... mark_t

2016-09-30 02:29:36 +0200 ha posto una domanda Search In Dialog with Listbox

Good night..

I created a dialog ("Dialogo") with two listbox and a textbox....

I need to when i initiate a search on textbox ("TextField_Pesquisa"), automatically show in the listbox ("ListBox_Itens") below the results of the search...

The images below show what i need...

Example 1: image description

Example 2: image description

Thanks!

.

2016-09-30 01:46:26 +0200 ha posto una domanda Initialize Dialog Selecting First Item to Listbox...

good evening..

I created a dialog ("Dialogo") with two listbox..

And i need to when i initialize this dialog, the first item to "ListBox_Itens" automaticaly can be selected...

this image below show what i need...

image description

2016-09-30 01:04:50 +0200 ha commentato una domanda Move list box items to a specific sheet

Thanks a lot ... mark_t

It's exactly what i needed..

2016-09-30 01:04:19 +0200 ha risposto a una domanda Move list box items to a specific sheet

Thanks a lot ... mark_t

It's exactly what i needed..

2016-09-28 09:27:12 +0200 received badge  Domanda notevole (source)
2016-09-28 03:11:30 +0200 ha commentato una domanda Move list box items to a specific sheet

the listbox don't exist in a sheet... the listbox is in a dialog box...