LibreOffice-Forum

Vielen Dank! Das war wirklich sehr hilfreich

Wie kann man mit Summewenn nur die Wert aufsummieren von den Monaten, die in dem Datumsbereich liegen?
Anschließend ziehe ich diese Summe vom Anfangswert ab und erhalte den Rest - siehe Dokument und Screenshot

I would like to have the same legend in Libre office Calc, but I don't know how I could edit a diagram legend in Libre



This is the diagram in Libre, does anyone know how to edit it so I will have text instead of numbers

Solution:

Hello, this code works just fine - I just need to convert my interger number to a currency, but I think it doesn't work like that: My current Solution at the end of the code snippet is: dest.NumberFormat = "€#,##0.00" Dim objDatei as Object Dim objBlaetter As Object Dim objBlatt As Object Dim inputC...

Ja, habes es mittlerweise selbst hinbekommen, aber danke dir!

Wie es aussieht, bist du ein Libre Office Basic Experte - willst du dir etwas dazu verdienen? Da ich noch mehrere Makros hätte, die in Basic übertragen müssten.

We are having an Excel Program, but need it running in Libre Office Calc, so we need to convert the VBA Code to Libre Office basic.
Does someone want to convert VBA Code to Libre Office Basic Code?

He will get paid for sure.

Range("B9").Select Selection.Copy Range("A13").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Range("B6").Select Application.CutCopyMode = False Selection.Copy Range("B13").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=...

Hey, I would like to add data into determined data structure (same table). We have cells for input and once the user wrote data in there and presses the submit button, the data will be written in the table below the table - can you help me with that please?