![]() ![]() You may need hsqldb2-java AUR to use some modules in LibreOffice Base. ![]() ![]() If you use HSQLDB Embedded in LibreOffice Base, you must install a Java Runtime Environment. For the SDK install libreoffice-fresh-sdk.Ĭheck the optional dependencies pacman displays.The British English language pack ( libreoffice-fresh-en-gb) should not be confused with the pack for Ukranian ( libreoffice-fresh-uk) or Breton ( libreoffice-fresh-br). ![]() Currently, LibreOffice detects your system defaults and sets as locale setting manual installation of a language pack is no longer mandatory, required only for localized user interface. In the past, the installation of at least 1 language pack was required.Rem dispatcher.executeDispatch(document, ".uno:DataFilterStandardFilter", "", 0, Array())ĭispatcher.executeDispatch(document, ". Rem -ĭocument = ĭispatcher = createUnoService(".DispatchHelper")ĭim args1(0) as new .PropertyValueĭispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args1())ĭim args2(0) as new .PropertyValueĪrgs2(0).Value = "=TEXT(TODAY() "+CHR$(34)+"YYYY-MM-DD"+CHR$(34)+")"ĭispatcher.executeDispatch(document, ".uno:EnterString", "", 0, args2())ĭispatcher.executeDispatch(document, ".uno:JumpToNextCell", "", 0, Array())ĭim args4(0) as new .PropertyValueĪrgs4(0).Value = "=IF(AI$1=LEFTB(C2 10) "+CHR$(34)+"1"+CHR$(34)+" "+CHR$(34)+"0"+CHR$(34)+")"ĭispatcher.executeDispatch(document, ".uno:EnterString", "", 0, args4())ĭim args6(0) as new .PropertyValueĭispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args6())ĭim args7(0) as new .PropertyValueĪrgs7(0).Value = "$AI" & +1ĭispatcher.executeDispatch(document, ".uno:AutoFill", "", 0, args7())ĭim args8(0) as new .PropertyValueĭispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args8())ĭim args9(0) as new .PropertyValueĭispatcher.executeDispatch(document, ".uno:GoToCell", "", 0, args9()) Here is a picture of a part of the table. What I have so far is, that I check every line and add 1 to the last row if it matches or add a 0 if the day won't be today.Īctually I recorded my actions, so my current macro is not optimal, that's why I'm not posting it. What I need this file to do on opening, is filtering for all the appointments of today. I have CSV-file with a couple of appointments, dates etc. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |