Ask Your Question

Fenix17's profile - activity

2019-04-09 13:28:42 +0200 received badge  Notable Question (source)
2019-02-08 05:59:06 +0200 received badge  Enthusiast
2019-02-07 20:56:50 +0200 received badge  Popular Question (source)
2019-02-07 17:45:56 +0200 edited answer Formattazione condizionale su festività

Mitico! Avevo già usato il solo CONTA.SE ma sempre applicandolo alle intere colonne.... questo perchè avanzando col cale

2019-02-07 17:45:32 +0200 answered a question Formattazione condizionale su festività

Mitico! Avevo già usato il solo CONTA.SE ma sempre applicandolo alle intere colonne.... questo perchè avanzando col cale

2019-02-07 17:37:32 +0200 received badge  Supporter (source)
2019-02-07 17:37:28 +0200 marked best answer Formattazione condizionale su festività

Buonasera a tutti, chiedo aiuto in quanto sto diventando pazzo a creare una formattazione condizionale che mi permetta, su un calendario turni, di colorare in rosso le festività nazionali e locali.

Nel file allegato troverete 3 fogli: il primo è la turnazione e nel secondo sono ricavate le festività per anno. Il terzo foglio potete bellamente ignorarlo, è la turnazione vecchia.

A logica dovrei semplicemente verificare se la data contenuta ogni cella delle colonne tra B e H si trova nel foglio "Festività" nella colonna C ed applicare la colorazione rossa allo sfondo.

Nelle colonne L e M trovate delle prove che ho fatto con le formule per verificare che il confronto di date funzioni, infatti in corrispondenza della cella C16 "22 Aprile" (Pasquetta) viene restituito "VERO".... peccato che applicandola alla formattazione condizionale mi vengono colorati in rosso celle che non dovrebbero centrare nulla di nulla.... evidentemente la formula è applicata male ma io non capisco dove sia l'errore.

Vi prego SALVATEMI!

Grazie C:\fakepath\Turni.ods

2019-02-07 17:37:28 +0200 received badge  Scholar (source)
2019-02-06 20:49:45 +0200 asked a question Formattazione condizionale su festività

Formattazione condizionale su festività Buonasera a tutti, chiedo aiuto in quanto sto diventando pazzo a creare una form

2017-04-04 14:10:27 +0200 commented answer Libreoffice basic equivalent of VBA's "GET" url

Indeed Python way will be (as soon as i get time XD)! I've just posted code for any noob like me looking for something l

2017-04-04 13:22:00 +0200 edited answer Libreoffice basic equivalent of VBA's "GET" url

Thanks to everyone for the replies, will deeply check the links as soon as i can! @Lupp: yes adding "Option VBAsupport

2017-04-04 11:57:50 +0200 edited answer Libreoffice basic equivalent of VBA's "GET" url

Thanks to everyone for the replies, will deeply check the links as soon as i can! @Lupp: yes adding "Option VBAsupport

2017-04-04 11:56:45 +0200 edited answer Libreoffice basic equivalent of VBA's "GET" url

Thanks to everyone for the replies, will deeply check the links as soon as i can! @Lupp: yes adding "Option VBAsupport

2017-04-04 11:55:51 +0200 edited answer Libreoffice basic equivalent of VBA's "GET" url

Thanks to everyone for the replies, will deeply check the links as soon as i can! @Lupp: yes adding "Option VBAsupport

2017-04-04 11:54:33 +0200 edited answer Libreoffice basic equivalent of VBA's "GET" url

Thanks to everyone for the replies, will deeply check the links as soon as i can! @Lupp: yes adding "Option VBAsupport

2017-04-04 11:54:33 +0200 received badge  Editor (source)
2017-04-03 21:29:23 +0200 edited answer Libreoffice basic equivalent of VBA's "GET" url

Thanks to everyone for the replies, will deeply check the links as soon as i can! @Lupp: yes adding "Option VBAsupport

2017-03-31 10:19:16 +0200 received badge  Self-Learner (source)
2017-03-31 10:19:16 +0200 received badge  Teacher (source)
2017-03-28 05:28:20 +0200 received badge  Famous Question (source)
2017-03-28 03:53:15 +0200 received badge  Student (source)
2017-03-27 16:12:19 +0200 commented answer Libreoffice basic equivalent of VBA's "GET" url

Thx for the infos Mike! i've stumbled into that post yesterday while looking around for a solution, but even if tempting, learning another language (even in very basic form) has been placed as last resource. Guess anyway i will go towards it if can't make it work in couple days. (also the data fetched are in json format and for what i've read around python can handlke it easily) :P

2017-03-27 13:09:50 +0200 answered a question Libreoffice basic equivalent of VBA's "GET" url

Thanks to everyone for the replies, will deeply check the links as soon as i can!

@Lupp: yes adding "Option VBAsupport 1" to the macro make it run in LO too, but looking forward to further improvements i want a LO basic native code to avoid eventual not support VBA related trouble later.

Update 4rd april: it's first time i can touch the macro since last post... (RL is killing my freetime) and found some links very useful (expecially pityonak guide is awesome!) and after a bit of reading and googleing i came up with this:

oSimpleFileAccess = com.sun.star.ucb.SimpleFileAccess
n = freefile()
Open CRESTlinkBuy For input As #n
    Do While not eof(n)     'execute while not at the end of file (eof)'
        input #n, buyquery 
        l = len(buyquery) 
        Numbers = "0123456789."    'tells to code what i`m seeking (#s including decimals)'
        Value = ""
        For i = 1 To l    'from first character till end of readed file chunk'  

            ActChar = mid(buyquery,i,1)   'mid function read each character'
                 ' of the file chunk (buyquery)...'

            If instr(Numbers,ActChar)<>0 Then Value = Value & ActChar   '...and instr'
                'function checks if Numbers contains then selected character, '
                'if so adds it to Value variable'  

            position = seek(n) 'return position of cursor in opened file'
            seek(n, position)

        Next i
    Loop
Close #n

Since json text uses commas to separate each data, i wrongly thought i could use the "input" function (that also stops reading at first comma) in conjunction with the "seek" function to move cursor within json and read next chunk of text :P Even if this is a failure i've learned a lot ! I didn't check all the links you gave me, hope to have time for that soon. Thx all again

2017-03-27 07:31:52 +0200 received badge  Notable Question (source)
2017-03-26 17:04:00 +0200 received badge  Popular Question (source)
2017-03-26 10:14:10 +0200 asked a question Libreoffice basic equivalent of VBA's "GET" url

Hello everybody, i've (very recently) swapped to open source world (linux & libreoffice 5) and i'm now looking to convert some very simple macros i did with VBA but even after quite a bit of hours passed to search on web i can't find the LO's basic equivalent of the VBA's "get" url fuction.

I need to fetch datas from a sever (the link is dynamical and i've alredy sorted it's creation in LO's basic) that replies with json format text. Now with VBA i used the following:

 Set query = CreateObject("WinHttp.WinHttpRequest.5.1")

 RESTlink = "Dynamic link"

 query.Open "GET", RESTlink
 query.send

Could anyone point me in the right direction?

Please note i've very basic knowledge of VBA too :P