Frage stellen

JohnSUN's Profil - Aktivität

2020-10-25 06:12:31 +0100 Kommentierte Frage match when data is not on the same sheet? - got match/index worked out if the data is all on the same sheet but not if on different sheets - is this possible?

Oh, what a bad term you used! Kindly correct your comment before no one sees it. That guy really wanted to help. But as

2020-10-24 08:19:33 +0100 Kommentierte Frage match when data is not on the same sheet? - got match/index worked out if the data is all on the same sheet but not if on different sheets - is this possible?

If you are still not very confident in writing formulas, use the Function Wizard - this avoids many mistakes FYI Help c

2020-10-24 07:47:55 +0100 Kommentierte Frage How to get data from specific cell in multiple sheets?

Hello @Anjsacs327 and welcome! Please bear in mind that you know much more about your spreadsheet than we do. Be more de

2020-10-23 12:38:43 +0100 Beantwortete Frage mode to click cells to enter pre-defined values

Hi @harsha and welcome! If you ask "Is this possible?" then answer is "Yes, of course!" If you know cell address of yo

2020-10-23 09:10:00 +0100 Überarbeitete Antwort Which colours are available for use in Format Codes?

I would really like to be wrong, but it seems to me that you can only use eight words - WHITE, BLACK, CYAN, MAGENTA, RED

2020-10-23 08:17:44 +0100 Überarbeitete Antwort Which colours are available for use in Format Codes?

I would really like to be wrong, but it seems to me that you can only use eight words - WHITE, BLACK, CYAN, MAGENTA, RED

2020-10-23 08:00:59 +0100 Beantwortete Frage Which colours are available for use in Format Codes?

I would really like to be wrong, but it seems to me that you can only use eight words - WHITE, BLACK, CYAN, MAGENTA, RED

2020-10-23 07:48:30 +0100 Beantwortete Frage Calc+BASIC: In the same Library, how to call function in different Module?

If this is a joke, then this is a very funny joke :-) Nobody forbids you to use such a good name for your function - Is

2020-10-22 12:59:09 +0100 Kommentierte Frage Libreoffice calc : search based on delimiter from cells, with multiple values

I don’t want to disappoint you, but binding to separators will not give 100% result either - sometimes spaces may appear

2020-10-22 12:45:06 +0100 Kommentierte Antwort Libreoffice calc : search based on delimiter from cells, with multiple values

There is no need to bind to delimiters - you have to add delimiters at the beginning and end of a string to catch words

2020-10-22 12:32:46 +0100 Kommentierte Frage Libreoffice calc : search based on delimiter from cells, with multiple values

@newusr879 Don't you think that the spelling of "FeMale" is somewhat different from the grammatically correct form? Does

2020-10-22 11:46:35 +0100 Beantwortete Frage Libreoffice calc : search based on delimiter from cells, with multiple values

Hello and welcome! The Standard filter is perfect for your task.

2020-10-22 09:07:51 +0100 Kommentierte Antwort Libre Office Excel supports both TEXTJOIN and SEQUENCE?

This should not be inserted into the Excel file, it is better to put it into your Standard macro library. It is difficul

2020-10-21 15:31:51 +0100 Beantwortete Frage Libre Office Excel supports both TEXTJOIN and SEQUENCE?

Since we know that Asc("A") + Asc("Z") = 155 and Asc("a") + Asc("z") = 219, the solution is trivial: Function MYSKU(s

2020-10-21 10:58:15 +0100 Überarbeitete Antwort How to Export cell range to images

Hello and welcome! Just try to record the sequence File - Export... - File type - Selection:ON with the macro recorder.

2020-10-21 10:57:23 +0100 Überarbeitete Antwort How to Export cell range to images

Hello and welcome! Just try to record the sequence File - Export... - File type - Selection:ON with the macro recorder.

2020-10-21 10:57:02 +0100 Überarbeitete Antwort How to Export cell range to images

Hello and welcome! Just try to record the sequence File - Export... - File type - Selection:ON with the macro recorder.

2020-10-21 10:31:14 +0100 Überarbeitete Antwort How to Export cell range to images

Hello and welcome! Just try to record the sequence File - Export... - File type - Selection:ON with the macro recorder.

2020-10-21 10:26:28 +0100 Kommentierte Antwort How to Export cell range to images

Yes, in this form, the code calls an additional window of parameters. That is why I wrote about the need for "remove the

2020-10-21 09:51:11 +0100 Kommentierte Antwort How to Export cell range to images

Can you click "Edit" under your original question and add the code that you got to your question? It's hard to talk abou

2020-10-20 22:51:23 +0100 verliehene Abzeichen  Tolle Antwort (Quelle)
2020-10-20 16:48:17 +0100 Kommentierte Antwort IDK why FIND() gives me this value when comparing these two tables on LO Calc

Why not TRIM() ?

2020-10-20 14:05:56 +0100 Kommentierte Antwort IDK why FIND() gives me this value when comparing these two tables on LO Calc

This can happen if in one of the columns the value ends with a space - you do not see it, but it is there. And for VLOOK

2020-10-20 13:10:35 +0100 Beantwortete Frage IDK why FIND() gives me this value when comparing these two tables on LO Calc

It was a bad idea to use the FIND() function for this task, it is meant to find a substring in text, not a cell in a ran

2020-10-20 11:05:39 +0100 Beantwortete Frage CALC-search text in column

This is not difficult. The MATCH() function will find the required row in the CONDITIONS column, and the INDEX() functio

2020-10-20 10:54:20 +0100 Überarbeitete Frage CALC-search text in column

CALC-search text in column Hi, I have a table like this: ID-CATEGORY-CONDITIONS 1-workstation-laptop,desktop 2-printers

2020-10-20 07:53:27 +0100 Beantwortete Frage How to Export cell range to images

Hello and welcome! Just try to record the sequence File - Export... - File type - Selection:ON with the macro recorder.

2020-10-20 06:36:28 +0100 Kommentierte Frage Query On LibreOffice Spreadsheet?

Yes, you are absolutely right - a correctly written request will return the required set of data almost instantly. If yo

2020-10-20 06:29:17 +0100 Kommentierte Frage I use L.O. 7.0.2.2. And 5 min ago start screen flashed over & over.

What OS are you using? Look in the task manager - are there any hung soffice.bin processes? Perhaps a simple restart of

2020-10-20 05:51:22 +0100 Kommentierte Frage Conditional formatting in Calc applying to too many cells

Just use absolute address - MIN($E$2:$E$9999)

2020-10-17 18:01:03 +0100 verliehene Abzeichen  Tolle Antwort (Quelle)
2020-10-16 07:42:52 +0100 Beantwortete Frage I have a data full of labels. I want to plot on the X-axis, the labels. And the number of times each label occurred on the Y-axis. How to do this in Libre Office calc?

It's simple, fast and easy to do with the PivotTable:

2020-10-14 17:13:02 +0100 Kommentierte Antwort How to call ,macro on column edit extremely urgent please help

I supplemented my answer with a file, which contains two options for solving the problem.

2020-10-14 17:11:57 +0100 Überarbeitete Antwort How to call ,macro on column edit extremely urgent please help

You will need a handler of event Content changed: Events pass information to the handler about the object that called

2020-10-13 08:16:10 +0100 Kommentierte Frage Why does Format Cells take so long to Open?

This is just a guess, version. The richest section of this form is the Date category, with many different date represent

2020-10-12 16:21:04 +0100 Kommentierte Frage Why old question are being closed? (see SO)

@Berry You should be prepared for your question "can I jump to a specific worksheet via keyboard shortcuts?" will also b

2020-10-12 06:35:03 +0100 Kommentierte Antwort How to call ,macro on column edit extremely urgent please help

You did everything right. There are three steps left to win. Remove REM ***** BASIC ***** from the last line of th

2020-10-10 08:39:12 +0100 Beantwortete Frage How to call ,macro on column edit extremely urgent please help

You will need a handler of event Content changed: Events pass information to the handler about the object that called

2020-10-07 08:40:33 +0100 Kommentierte Frage comments in calc

Ctrl+Shift+C?

2020-10-07 07:46:26 +0100 Kommentierte Frage writer: macro or quick way to uncapitalise first letter of a line

first letter of a line By "line" do you mean a paragraph or a sentence? If a paragraph, then Find&Replace - Fin

2020-09-30 20:57:03 +0100 Beantwortete Frage HOW TO CHANGE WORKSHEET NAME

Use any of three methods: From Menu Sheet From the context menu Usual double click