The question is, is it possible to adapt a formula from MS Word here. Or is it possible to solve this problem with a macro?

Please help me make a formula for the text field of a page, so that only odd (or even) pages are numbered sequentially, in increments of 1. That is: page 1 - number 1, page 2 - "", page 3 - number 2, page 4 - "", page 5 - number 3, and so on, if you number the odd pages. Sometime...

Example-pivottable:

Posted a question on Ask. Maybe someone here can help me, too, who doesn't look there. https://ask.libreoffice.org/t/calc-getpivotdata-through-macro/90758 For those who want a better understanding of the formula GETPIVOTDATA, I uploaded an example (I don't claim authorship, and I forgot the owner's ...

...but is it seems be impossible with string generated as a formula result. Skip it. OP put the question correctly. And it's not really an unnecessary feature. I'm trying to solve the issue on my own. Everything is looked for and colored, but in general the module is not finished, not enough time. ...

Remove the ambiguity in the example. It is unclear how generalized the example is. Give a fragment of real data.

@Noobian, an error has been corrected:
Technikus: Cyber tech. This skill has not been highlighted.

Test. Excel INDIRECT() test to work with named formula expressions fails. It does not work either. The question is closed.
All that I suggested to the author is the solution.

Use my way. @karolus refused to use INDIRECT() because it is volatile (gets updated whenever something changes). But my solution is simpler, and the overhead caused by using INDIRECT() is negligible because you have little data. You cannot use named formula expressions. Only in the way I suggested (...

karolus wrote: ↑Sat Jun 25, 2022 3:51 pm No need for INDIRECT

There is a need. Calc is being tested for strength.
These are variations (your solution). The problem has already been solved. There is a tutorial attempt to remove the auxiliary sheet. But there was no way...

I just tried to point out that someone who calls himself "Noobian" may not be able to transfer a given solution. Perhaps Noobian in the game, not in Calc. And that's none of our business. I don't play at all. But it was offered quite a ready-made solution. Problems will arise in editing t...

Named ranges can also be created directly in the formula expression, but then it is inconvenient to view and edit it. @Villeroy, as I said above, assuming this was possible, I converted the named range to a named formula expression instead of referring to a range of cells, but this doesn't work in ...

But now you have a working example to investigate on your own. ISNUMBER(MATCH(C6;INDIRECT($B$2);0)) C6 is RC in Excel R1C1 formula syntax (relative notation), which means: in the current R ow of the current C olumn. The difficulty of understanding is exactly that. But $C$6 is really cell C6. But thi...

Yes, it’s conditional formatting.

Named ranges can also be created directly in the formula expression, but then it is inconvenient to view and edit it. However, this is possible if the skill set is fixed (complete list).

Something is not in the Szerep drop-down list: Rocker Szóló Hacker Technikus OrvTechnikus Média Zsaru Céges Fixer Nomád What are the characteristics of Hacker? So what i would like to make is that some cells from the "Képzettség" gets highlighted when a role is selected from the "Szer...

It is not clear. Translate into English and explain what needs to be done.

I agree with @Villeroy.
See another example where a pivot table is used.

Try this. I basically solved your problem, although I don't like this solution either. A partial implementation of Excel's FILTER() function is required, so that it spills (fills) the data starting from the top left cell where the "not an array" formula is entered. But no one wants to impl...

See AGGREGATE() with 2nd arg set to 5

BTW, all holidays have been SHADED and BOLDED.
I can't understand, how did you achieve this? I don't see any set font properties.

Change COUNTIFS() with SUMPRODUCT() =SUMPRODUCT($A$2:$P$75=A2;$A$2:$P$75="PM") =COUNTIFS($A$2:$P$75; A2 ;$A$2:$P$75;" PM ") But when I put them together I just get 0 Because these two conditions must be met simultaneously, and cell A2 must contain "PM" for the condition...

You have deviated somewhat from the stated topic. But the moderators advise to start a new topic in this case, so it is better to create it. I don't quite understand what needs to be done. I am not an English-speaking user. Attach a sample file. I wrote a simple function to convert a column number t...

I try to insert a formula in a cell... oSheet.getCellByPosition(24, 2).Formula = "=RC[4]" BTW is any calc-function usable in Basic? @djbierman, your problem is that you are using a different notation (not supported directly, Calc A1 syntax is supported only) and do not know about the exis...

Cross-posting
I can't get a cell range in the macro by the named range specified by the formula expression (named formula). And everything works well on the sheet.

Can I create my own formula in the Pivot table? Unfortunately, you can't. Formulas should be added to the data source. In MS Excel, you can create calculated fields in the pivot table. Is it possible to name the headlines according to my wishes? There are examples of solving this problem on this fo...

Cross-posting
https://ask.libreoffice.org/t/calc-crea ... 5?u=eeigor

Yes! (But I have no idea how it was solved - I do not succeed myself) Three pivot tables have been added. They are refreshed by a macro on the content change event. Still, there is some problem here. The first two tables act synchronously (linked), and the third works independently . The data sourc...

Documents in english - Date - Version Backup/Restore the Standard library of My Macros and Dialogs. The document contains the macros. - March 2012 - 1.2en ← Download https://berma.pagesperso-orange.fr/index2.html The StandardExportImport_en.odt file will be downloaded. How to use Click on Backup . T...

It is all complex. Could not find a link, but look for Bernard Marcelly (author of Xray Tool) library backup odt file.