Stel uw vraag

Fede's profiel - activiteit

2019-04-24 13:10:05 +0200 badge ontvangen  Beroemde vraag (bron)
2019-02-25 19:11:20 +0200 badge ontvangen  Beroemde vraag (bron)
2019-02-22 17:20:35 +0200 badge ontvangen  Beroemde vraag (bron)
2019-01-17 20:19:54 +0200 badge ontvangen  Opvallende Vraag (bron)
2018-09-25 09:34:42 +0200 bewerkte een vraag Lock cell with macro

Lock cell with macro Hello! I would like to lock a cell in order to prevent that the user could write in, I use the comm

2018-09-25 09:34:22 +0200 bewerkte een vraag Lock cell with macro

Lock cell with macro Hello! I would like to lock a cell in order to prevent that the user could write in, I use the comm

2018-09-19 11:07:45 +0200 badge ontvangen  Opvallende Vraag (bron)
2018-09-10 17:10:46 +0200 badge ontvangen  Populaire Vraag (bron)
2018-09-10 14:58:33 +0200 reageerde op een antwoord Lock cell with macro

Thank you. Lupp:-D! Only an other question, there is command to pass direcly the password without write it in the code?

2018-09-10 14:20:10 +0200 koos een beste antwoord Lock cell with macro

Hello! I would like to lock a cell in order to prevent that the user could write in, I use the command oCell.cellprotection.isLocked = True/False but don't run,

Can You help me?

Thank you

Have a nice day

P.S. I tried to use the command:

cp = createUnoStruct("com.sun.star.sheet.CellProtection")

Dim cp as new com.sun.star.sheet.CellProtection

but nothing happens

News: I don't understand whi this code don't run :/

Sub test(pPass$, kj#)

oSheet = ThisComponent.getSheets().getbyname("Prova")
oSheet.UnProtect(pPass)
oCellRange = oSheet.GetcellRangebyname("Data")
oCell   = oCellRange.getCellByPosition(2,6)


select case kj

    case 1
        oCell.cellbackcolor = RGB(255,255,0)
        hh = oCell.CellProtection
        hh.IsLocked = False
        oCell.CellProtection = hh


    case 2
        oCell.clearContents(1)
        oCell.cellbackcolor = RGB(255,255,255)
        hh = oCell.CellProtection
        hh.IsLocked = True
        oCell.CellProtection = hh

end select

oSheet.Protect(pPass)

End Sub
2018-09-10 11:24:29 +0200 bewerkte een vraag Lock cell with macro

Lock cell with macro Hello! I would like to lock a cell in order to prevent that the user could write in, I use the comm

2018-09-10 11:24:13 +0200 bewerkte een vraag Lock cell with macro

Lock cell with macro Hello! I would like to lock a cell in order to prevent that the user could write in, I use the comm

2018-09-10 11:09:45 +0200 stelde een vraag Lock cell with macro

Lock cell with macro Hello! I would like to lock a cell in order to prevent that the user could write in, I use the comm

2018-08-10 19:57:03 +0200 badge ontvangen  Populaire Vraag (bron)
2018-08-10 15:04:55 +0200 koos een beste antwoord Hide combobox in starbasic with Macro

Hello, Do you know the command to hide a combobox with macro?

oMyCombo = oSheet.DrawPage.Forms.getByName("Formulario").getByName("Type_Struct") oMyCombo.removeAllItems() oMyCombo.hide = True

or

oMyCombo.hidden = True

or

oMyCombo.visible = True

All these comands are incorrect

Thank you

have a nice day

LO 6.0.02 SO Win7

2018-08-10 14:32:56 +0200 bewerkte een vraag Hide combobox in starbasic with Macro

Hide combobox in starbasic with Macro Hello, Do you know the command to hide a combobox with macro? oMyCombo = oSheet.

2018-08-10 14:32:41 +0200 bewerkte een vraag Hide combobox in starbasic with Macro

Hide combobox in starbasic with Macro Hello, Do you know the command to hide a combobox with macro? oMyCombo = oSheet.

2018-08-10 14:29:23 +0200 badge ontvangen  Beroemde vraag (bron)
2018-08-10 14:11:40 +0200 stelde een vraag Hide combobox in starbasic with Macro

Hide combobox in starbasic with Macro Hello, Do you know the command to hide a combobox with macro? I remembered oMyCom

2018-08-07 22:43:14 +0200 badge ontvangen  Populaire Vraag (bron)
2018-08-07 14:54:22 +0200 stelde een vraag Fourier3 function in star basic

Fourier3 function in star basic Hello, I defined la function "Fourier3" but I don't understand becouse the results ( in

2018-08-07 12:22:55 +0200 reageerde op een vraag Fourier Series in Calc with Basic

Done, Thank you

2018-08-07 12:22:35 +0200 bewerkte een vraag Fourier Series in Calc with Basic

Fourier Series in Calc with Basic Hello, it is correct this relation in Star Basic? function fourier3(a0, a1, b1, a2, b

2018-08-07 12:13:29 +0200 reageerde op een vraag Fourier Series in Calc with Basic

Sorry, it is not very simple to explain... I have interpolated a series data con Matlab with the above equation, but whe

2018-08-07 11:14:36 +0200 bewerkte een vraag Fourier Series in Calc with Basic

Fourier Series in Calc with Basic Hello, it is correct this relation in Star Basic? function fourier3(a0, a1, b1, a2, b

2018-08-07 11:14:01 +0200 stelde een vraag Fourier Series in Calc with Basic

Fourier Series in Calc with Basic Hello, it is correct this relation in Star Basic? function fourier3(a0, a1, b1, a2, b

2018-07-12 10:47:01 +0200 badge ontvangen  Opvallende Vraag (bron)
2018-07-12 09:19:39 +0200 reageerde op een antwoord Variable name Vs Value variable

Thank you Lupp, P.S. After clicking "Retag" and modifing it, how to conferm?

2018-07-12 09:17:03 +0200 bewerkte een vraag Variable name Vs Value variable

Variable name Vs Value variable Hello, I have 3 variables: var1 = 10; var2 = 20; var3 = 30 I would like to print on sc

2018-07-12 09:15:59 +0200 reageerde op een antwoord Variable name Vs Value variable

Thank you Lupp

2018-07-12 09:15:38 +0200 koos een beste antwoord Variable name Vs Value variable

Hello, I have 3 variables: var1 = 10; var2 = 20; var3 = 30

I would like to print on screen the variable with for cycle

sub prova
dim var1#
dim var2#
dim var3#

var1 = 10
var2 = 20
var3 = 30   
for i = 1 to 3
    print "var" & i
next
end sub

But in this way obtain the of variable, not the value

Can you help me?

Thank you

2018-07-12 03:36:17 +0200 badge ontvangen  Populaire Vraag (bron)
2018-07-11 17:50:52 +0200 stelde een vraag Variable name Vs Value variable

Variable name Vs Value variable Hello, I have 3 variables: var1 = 10; var2 = 20; var3 = 30 I would like to print on sc

2018-05-22 21:36:17 +0200 badge ontvangen  Populaire Vraag (bron)
2018-05-20 19:25:14 +0200 badge ontvangen  Populaire Vraag (bron)
2018-05-16 17:52:50 +0200 bewerkte een vraag Search combobox value in a range with macro in libreoffice

Search combobox value in a range with macro in libreoffice Hello, I would like to search a text of a combobox in a ran

2018-05-16 17:52:50 +0200 badge ontvangen  Mede-redacteur (bron)
2018-05-16 17:52:39 +0200 stelde een vraag Search combobox value in a range with macro in libreoffice

Search combobox value in a range with macro in libreoffice Hello, I would like to searc a text of a combobox in a rang

2018-05-16 11:59:31 +0200 koos een beste antwoord Filling combobox problem

Hello, I would like to filling the combobox with the elements in range "E7:E48", but I don't understand the problem....

    oSheet = ThisComponent.getSheets().getbyname("Prova")
    oMyCombo = oSheet.DrawPage.Forms.getByName("Formulario").getByName("Id_model")

    oMyCombo.removeAllItems()

    odata = ThisComponent.getSheets().getbyname("Database").getCellRangeByName("E7:E48").DataArray

   oRow = odata(0)

    For i = LBound(oRow) to UBound(oRow)

        oMyCombo.insertItemText (i, oRow(i))

    Next i

Can you help me? Thank you

Libreoffice 6

SO Win10