karolus's profiel - activiteit

Hallo ich nehme an PiOS meint Raspberry PiOS?? sudo apt-get update sudo apt-get upgrade sudo apt-get install libreoffi

for serious reasons it isnt possible to run more than one instance on the same $user_configuration so you need for an se

proably the real question is about: how to update... ??

edited Example-data for readability

extract a value from a text string Is there a way I can extract the cost value from a string of characters to give me a

Avoid evil INDIRECT use for Example: =INDEX(Contrib.A:A;16)

I did not like perl but anyway i search for oodoc.pl and find this one and read there the script should be executed with

Searching for words in single column that are similar, not exact duplicates Trying to search for duplicates of company n

Bei mir auf einem Raspberry-Pi mit Debian-basierttem OS wird der nlp-solver unter dem Namen "´libreoffice-nlpsolver´" ge

Ergänzend zu @Opaque und @RobertG: Vielleicht solltest du die Daten schlicht sortieren…anstatt zu versuchen Länge auf Fl

something like =SUM((A1:A8)^8) enter with strg shift enter

The Problem is the .dot'in Sheetname, because .dots are reserved for delimit between Sheet- and Celladdress. Replace t

it seems your in wrong forum, but anyway: x = [ [1, 2, 3], [4, 5, 6], [7, 8, 9], [10, 11, 12]]

Exactly that: Type =Sales into upper-right cell of TargetRange and hit ctrl shift enter at same time

Hallo Du kannst doch gleich komplett auf python umsteigen, dann erübrigt sich die Frage …

calc+basic+python: use python-Sub within basic Hier nun die deutsche Version meiner Frage: Ich habe einige Python-Routi

Hallo Zunächst mal hast du großzügig ganze Codeblöcke kopiert und lediglich Namen angepasst, nicht jedoch die eigentlic

Ich hab die Kommentarzeilen ergänzt damit das Syntaxhightlighting der Seite nicht durcheinanderkommt.

Alle Zellen eines Bereiches mit faktorieren | Fehler: Datentypen unverträglich Hallo, habe mir aus Bruchstücken Makros z

edit for better Code-Syntaxhighlight. Karolus

Calc basic: deleting row below the one I was expecting Hi I'm starting to migrate from Excel VBA to LibreOffice Calc Ba

ok ;-) just realize the original thread starts August/2017

@librebel… a kind of nobrainer in python: def sort_rows_individually(*_): """ sorts row by row individua

Hallo See my Comment, if so - try something like: =SUMPRODUCT(B1:B10=A1, C1:C10="EX",S1:S10,IFERROR(Z1:Z10,0)) …o

Hallo See my Comment, if so - try something like: =SUMPRODUCT(B1:B10=A1, C1:C10="EX",S1:S10,IFERROR(Z1:Z10,0))

My guess: there is somewhere in [B|C|S|Z]1…10 a #div/0-error which goes straight into return of SUMPRODUCT

single Cells have already the Property .String respective the Method .getString()… print thisComponent.CurrentSelection

-1 I dont see any advance in that proposal, there are enough pdf-viewers available no reason to reinvent the wheel.

Put in B1 the formula =FORMULA(A1) pull down to B10 and c&p this into Notepad++

If so please tick the ✓-mark left near my answer.

This resolved the problem! Thanks!

Hallo Wäre das nicht auch mit einem simplen Schaltjahrtest möglich, aka: SELECT 365 + (("Jahr" % 100 != 0 AND

Hallo Wäre das nicht auch mit einem simplen Schaltjahrtest möglich, aka: SELECT 365 - (("Jahr" % 100 != 0 AND

Hallo Wäre das nicht auch mit einem simplen Schaltjahrtest möglich, aka: SELECT (("Jahr" % 100 != 0 AND "Jahr"

Ok sorry… youre need also to insert a additional line : source.Sheet = 1

please dont ask that stupid! its obviously either in menu > Sheet > Insert Sheets or in the Contextmenu of the She

Yes, of course, change for Example: identifiers = sheet1.getCellRangeByName("A1:A1000").getDataArray() used_entrys

@Opaque: …as well the Standardfilter does!

have a look on >Data > Filter > Standardfilter …

Maybe youre about something like: Sub CopyPasteworking range_address = CreateUnoStruct("com.sun.star.table.

Maybe youre about something like: Sub CopyPasteworking range_address = CreateUnoStruct("com.sun.star.table.

How Can I Delete Data with Macro Hello! I try to write macro in Libre Office Macro. I want to delete data by using Libr

How Can I Delete Data with Macro Hello! I try to write macro in Libre Office Macro. I want to delete data by using Libr