Frage stellen

JohnSUN's Profil - Aktivität

2019-09-25 22:03:12 +0100 verliehene Abzeichen  Tolle Antwort (Quelle)
2019-04-27 11:39:39 +0100 Beantwortete Frage How to fill right?

Now the Ctrl+R and Ctrl+Shift+R hotkeys are used for other commands (Align Right and Redraw). But you can redefine them.

2019-04-25 16:19:46 +0100 Kommentierte Antwort How to concatenate 50 columns in libreoffice using macros?

Yes that's it! Thank you! IF((LEFT(A1:AX1;4)="Tire")+(LEFT(A1:AX1;11)="Performance");... works correctly

2019-04-25 13:13:38 +0100 Kommentierte Antwort How to concatenate 50 columns in libreoffice using macros?

Of course @m.a.riosv, before writing a macro, I tried a formula with TEXJOIN() and could not make it work properly. {=T

2019-04-25 13:12:59 +0100 Kommentierte Antwort How to concatenate 50 columns in libreoffice using macros?

Of course @m.a.riosv, before writing a macro, I tried a formula with TEXJOINE() and could not make it work properly. {=

2019-04-24 15:25:27 +0100 Beantwortete Frage How to concatenate 50 columns in libreoffice using macros?

If your data does contain a valid number of columns, you can use this function: Function myConcat(aStrings As Variant)

2019-04-24 14:49:16 +0100 Kommentierte Frage How to concatenate 50 columns in libreoffice using macros?

This will not work in LibreOffice Calc. Your code is designed for a table of 1744 columns. Unfortunately, in LibreOffice

2019-04-24 14:23:53 +0100 Überarbeitete Frage How to concatenate 50 columns in libreoffice using macros?

How to concatenate 50 columns in libreoffice using macros? Below the vba code which i want to run in libreoffice Sub pa

2019-02-07 09:49:54 +0100 Kommentierte Antwort Best way to transfer data from one workbook/sheet to another on a reoccurring basis.

This was a wrong change. So the macro will start recording not from the first empty row, but from the last filled row -

2019-01-30 22:52:31 +0100 Kommentierte Antwort Checkbox visible/invisible

See example in my answer

2019-01-30 22:51:03 +0100 Überarbeitete Antwort Checkbox visible/invisible

(Most likely you are trying to EXECUTE a function (run it without parameters), and not CALL it) Write the name of the c

2019-01-29 14:13:33 +0100 Kommentierte Antwort Protect All Formulas

Perhaps string for Find must be ^[=|\{]?

2019-01-29 14:12:44 +0100 Kommentierte Antwort Protect All Formulas

Perhaps string for Find must be ^[=}\{]?

2019-01-29 14:07:51 +0100 Beantwortete Frage Protect All Formulas

Yes, this easy way present

2019-01-29 09:47:17 +0100 Kommentierte Antwort Calc - Index, Match, and Dropdown columns?

About edit array-formula please see here Yes, for a larger number of tables, the formula will be similar, but slightly

2019-01-29 07:47:26 +0100 Beantwortete Frage Calc - Index, Match, and Dropdown columns?

Nick, the easiest way is to solve your problem using the OFFSET() function. Just calculate how many rows below the heade

2019-01-28 17:43:19 +0100 Beantwortete Frage Checkbox visible/invisible

(Most likely you are trying to EXECUTE a function (run it without parameters), and not CALL it) Write the name of the c

2019-01-28 17:12:00 +0100 Überarbeitete Frage Checkbox visible/invisible

Checkbox visible/invisible Libre 6 on Bionic Bunny I found the following code snippet on an OO forum but cant seem to m

2019-01-28 11:40:55 +0100 Beantwortete Frage Slightly complex formula in calc fails

Please try this variant =SUMPRODUCT(MAX(VALUE(RIGHT(A1:C1; 5))))

2019-01-28 07:17:05 +0100 Kommentierte Antwort Best way to transfer data from one workbook/sheet to another on a reoccurring basis.

It seems to me that you are missing two points: the executed macro for the button should be explicitly specified in the

2019-01-27 22:25:39 +0100 Beantwortete Frage How to list all named ranges including those with sheet scope ?

Do you mean something like this? Sub test Dim oRes As Variant, i As Long oRes = getAllNamedRanges(ThisComponent)

2019-01-27 21:16:20 +0100 Beantwortete Frage Best way to transfer data from one workbook/sheet to another on a reoccurring basis.

It seems to me that your task can be solved with the help of a slightly different code: Sub CommandButton1_Click() Dim

2019-01-20 20:51:22 +0100 Kommentierte Frage Macro to copy cells adjacent to matching data from another sheet looping through N rows

I'm sorry, but why macro? Why not VLOOKUP() or INDEX(MATCH())?

2019-01-16 12:11:31 +0100 verliehene Abzeichen  Tolle Antwort (Quelle)
2019-01-16 11:49:22 +0100 Beantwortete Frage HOW DO I TOGGLE CAPITAL LETTERS TO lower case?

What about Shift+F3 or menu Format-Text?

2019-01-16 11:48:20 +0100 Beantwortete Frage HOW DO I TOGGLE CAPITAL LETTERS TO lower case?

What about Shift+F3 or menu Format-Text?

2019-01-16 07:38:47 +0100 Kommentierte Frage Month() in calc returns previous month

@Mike Kaganski I could repeat this behavior too - column A is filled with formulas like = A1 + 1. In this case, changing

2019-01-16 07:15:12 +0100 Kommentierte Frage Month() in calc returns previous month

@Mike Kaganski I could repeat this behavior too - column A is filled with formulas like = A1 + 1. In this case, changing

2019-01-16 07:12:55 +0100 Kommentierte Frage Month() in calc returns previous month

@Mike Kaganski I could repeat this behavior too - column A is filled with formulas like = A1 + 1. In this case, changing

2019-01-16 06:15:27 +0100 Kommentierte Frage Month() in calc returns previous month

I was able to reproduce this behavior. I used your formulas exactly as described. The problem was that the date and thes

2019-01-12 15:33:30 +0100 Kommentierte Frage how to get around white space problem

Expression SUM(G5;K5)*(1+N($M$3)) should do the trick

2019-01-12 13:57:24 +0100 Überarbeitete Antwort How to add custom attributes to a LO Base form

If you use macros then tou can try declare Global variable. Or you can create hidden control in form (popup menu in For

2019-01-12 13:55:53 +0100 Beantwortete Frage How to add custom attributes to a LO Base form

If you use macros then tou can try declare Global variable. Or you can create hidden control in form (popup menu in For

2019-01-02 10:06:05 +0100 Kommentierte Antwort To display two cells contents together in another cell with second cell being in next line

...and set the Row Heights sufficient to display all the content

2018-12-30 09:15:13 +0100 Überarbeitete Frage In Impress, is there a way to move or resize a Group, similar to that which works for pictures?

In Impress, is there a way to move or resize a Group, similar to that which works for pictures? The Group feature is ver

2018-12-30 09:09:40 +0100 Kommentierte Frage Creating a Macro that will run functions in certain columns.

Not sure if you can explain why you use such complex formulas to perform very simple checks. These formulas are difficul

2018-12-30 07:44:50 +0100 Kommentierte Antwort Hi! How do I create a macro to delete an entire row based off of a string within the cell?

There is no error in the code; you make an error when you try to execute the delRowsByTextInColumn procedure directly. T

2018-12-30 07:28:02 +0100 Kommentierte Antwort Setting a Calc Document to Open in Full Screen

I am very glad that I could help. Happy New Year!

2018-12-30 06:44:51 +0100 verliehene Abzeichen  Tolle Antwort (Quelle)
2018-12-29 21:34:37 +0100 Beantwortete Frage In Calc, is there a way to dynamically fill a cell with a color based on a hex code/RGB values/LO color code in an adjacent cell?

Well, you can try this macro: Function crtStylesIfNeed(sColorCode As String, Optional newStylePrefix As String) As Stri

2018-12-29 20:27:41 +0100 Kommentierte Frage In Calc, is there a way to dynamically fill a cell with a color based on a hex code/RGB values/LO color code in an adjacent cell?

This is not difficult to implement - just create 200 cell styles and use the STYLE() function. Of course, I do not propo

2018-12-29 19:37:26 +0100 Kommentierte Antwort Setting a Calc Document to Open in Full Screen

You don't need to take any action in this direction - ignore this message, just click on the Cancel button. This is just

2018-12-29 18:16:58 +0100 Kommentierte Antwort Setting a Calc Document to Open in Full Screen

You don't need to take any action in this direction - ignore this message, just click on the Cancel button. This is just

2018-12-29 18:11:22 +0100 Kommentierte Antwort is it possible, how to see column titles?

So, we can edit this question and remove external links? In this case, the community once again - for the hundredth? for

2018-12-29 17:58:35 +0100 Überarbeitete Antwort Setting a Calc Document to Open in Full Screen

A few years ago, @RoryOF wrote one line: "When OpenOffice opens at the Splash screen, maximise it and close it. It shoul

2018-12-29 17:25:30 +0100 Überarbeitete Antwort Setting a Calc Document to Open in Full Screen

A few years ago, @RoryOF wrote one line: "When OpenOffice opens at the Splash screen, maximise it and close it. It shoul

2018-12-29 16:50:16 +0100 Kommentierte Antwort Setting a Calc Document to Open in Full Screen

Oh yes! I remembered! Please wait a few minutes, I will edit my answer.

2018-12-29 16:22:17 +0100 Überarbeitete Antwort Setting a Calc Document to Open in Full Screen

A few years ago, @RoryOF wrote one line: "When OpenOffice opens at the Splash screen, maximise it and close it. It shoul

2018-12-29 10:48:59 +0100 Überarbeitete Antwort Calc : How to edit formulae in formula bar directly

You can easily do this. Since F2 is the key for editing the cell, and Ctrl+F2 is the hotkey for invoking the Function Wi

2018-12-29 10:48:18 +0100 Beantwortete Frage Calc : How to edit formulae in formula bar directly

You can easily do this. Since F2 is the key for editing the cell, and Ctrl+F2 is the hotkey for invoking the Function Wi