There is no magic in this formula. Just like your spreadsheet lacks formulas in the ZY and ZZ columns (I'm not mistaken, you didn't do anything in the ZY and ZZ columns of your "organic" spreadsheet, right?)

Most of code is what I wrote before posting my last post, added a little today. Didn't want to show before @songdove made its own attempt. But circumstances are developing in such a way that at any moment Ukraine will be under attack. Even if I survive, the means of communication will most likely su...

I am hoping someone has a way where this can be done in a one-click macro. Yes, it can be done with a macro. And yes, it's not a very complex macro. And once again, yes - there is a person who will do it, it is you. Suppose a macro needs to sort a range around the active cell. That is, you select a...

Best Game is

Yes, there is - a person who knows VBA and StarBasic at the same time. In most cases, translation turns into reading the VBA source code, understanding the meaning of the algorithm, and writing new code. In a small percentage of cases, the original VBA code can work using LibreOffice with the additi...

I can't manage to understand why there's such a diffference. A "" value seems to be different from the contents of a cell pointing to the same value ! This is easy to understand: Calc is not Excel. VBA, when assigning a variable, such as Cells(40, 2), actually uses the cell's .Value prope...

Welcome to the forum! Activate the Drawing toolbar (choose View-Toolbars-Drawing). Click the Select tool. Outline the area with the image (resizing handles will appear around the edges of the image - a signal that the object is selected). Now use the context menu to bring the drawing back to front. ...

Please take a look at this solution. Pivot tables are not used here, everything is done using formulas. For each of the tables, values without duplicates were selected from the original data. Used a trick that @MrProgrammer demonstrated five years ago Everything else is the most common, "everyd...

Just a hint : Do you know about Named Ranges? Try creating one or more with CTRL+F3 ( Insert-Names... ) and after that check the contents of the drop-down list under "Copy results to" . I'll sit down with this later to play with it. Yes, this is a great idea! As a result, you will receive ...

I'm not sure about the values of cells G24 and M24 - is "1999" a typo?

The creation of the .CSV I've got. Yes, maybe you think so and I'm not going to dissuade you. I just got confused by this action: and I could then select all those records (ctrl A the "new" page) and save them to the .CSV file It seems completely superfluous to me, but if you are already ...

Welcome Michael! Before answering your questions (I saw two questions in your post: "how to copy selected rows to another sheet" and "how to correctly create a csv-file from spreadsheet data"), I would like to clarify: when you wrote A1, A2 , A3, and so on, did you mean A2, B2, C...

What about ?

M.Teich wrote:I can't assign the macro, because there are no objects to assign it to. Any suggestions what to do?

Are you asking how to change the array formula? Select any cell and press CTRL+/. This will highlight all the cells with the formula. After that press F2, change the ranges and finish editing with the keyboard shortcut Ctrl + Shift + Enter.

Of course, you are right - there are many solutions to this problem. Even manually reviewing all the data and writing out a long string of values through the plus sign is also a solution. Accountants have been doing this for many years on paper, long before the advent of computers (and have done it ...

It's time to start upgrading the software. We do not know what circumstances the topikstarter has. Perhaps he does not have the ability to change the composition of the software. (I came across organizations - for example, banks - where they take security so seriously that any innovation is coordin...

Yes, for LibreOffice it would work.
However, for OpenOffice 4.1.9 (let alone 3.1) you will get =MULTIPLE.OPERATIONS(G$37;$I$37;$I38) with result #NAME? - CONCAT() function is not available here (as well as TEXTJOIN())

{=TEXTJOIN("+";1;IF((YEAR(A2:A143)=$H$21)*(MONTH(A2:A143)=I21);D2:D143);"")} Believe it or not, I was too lazy to write a macro and first of all I thought about TEXTJOIN(). But then I read the signature of @gokulwadghule "Windows 10 & Open Office Version 3.1" and r...

I am often reproached for using macros when it is enough to think a little and use ready-made built-in tools. What can I do, I'm lazy, I don't always want to think, so I take some old macro and slightly rewrite it for a new task

Yes. And besides, a timestamp will be automatically added to the recording. This will allow to have a second-by-second protocol of the process for, for example, subsequent verification with video recording in case of disputable situations.

@Villeroy You probably haven't noticed what all this fuss is about. It's about fast data entry from a tablet in the field (waist-deep in water). Not about saving, but about speed change values, not in the usual version of the office, but in the "adapted" for Android ... Unusual conditions ...

Oh, sorry, I completely forgot that I promised to explain step by step how to do this. There are lines in the main procedure onChngSelected() REM Size and position oBtnGroup.setSize(oCell.Size) Here oCell.Size is the size of the current cell. Actually .Size is a property, which is a simple com.sun.s...

Yes, that's right, it will work. Just in the form ThisComponent.getCurrentController().ComponentWindow.invalidateRect(oBtnGroup.FrameRect, com.sun.star.awt.InvalidateStyle.UPDATE) (no constant 0 in constants group InvalidateStyle ) and not at the end ShowOrHideGroup sub but after the line ShowOrHide...

@JeJe Yes, I saw that sometime it's not visible. Everything is fine in LibreOffice Calc, in OpenOffice there is a problem. I didn't bother trying to fix it. Firstly, the button is there anyway (just click on the white square where it should be and it will work and become visible). Secondly, this lef...

Ok, try this option

use "text strings of digits" where 12345678901123456789012345678901234567890 is a text string of 40 characters. In fact, there are 41 digits, in the second ten there are two "ones". But this, of course, is not a reason to deny the enslavement of the horse and the inversion of ca...

Okay, rgwade323 , let's agree that you are not the first to come up with this problem and tried to talk about it. Five years ago a guy with the nickname Brokenfingers asked for something similar . You have not shown your example of a Christmas tree, nor the formula for which you have a question. Tak...

During the execution of the function, the sheet in which it is located, is blocked from any changes. This avoids many potential errors - for example, computational loops or office crashes due to memory overflows. This restriction does not apply to procedures, for example, to the "Selection chan...

Those under (say) 40 years of age fail to appreciate how unretentive the memory becomes as you get older. It becomes difficult to learn new things. (After these words, the forum veterans looked at each other and shrugged their shoulders. The most cynical of them whispered "At least we are stil...