... The pre-set package that PDQ offers in their library ... I am needing help in setting up a custom install that only installs Writer and Calc. I don't know anything about special packages, but since you are on Win 10 as the OS, both my knowledge and my experience suggest the following questions:...

We do the same with dates: 13-04-2024. Thanks for the hint. I actually had that case also in mind, but ... 1. I wouldn't accept your example as a date. 2. The date representation as exemplified in the rectified way "2024-04-13" is explicitly standardised in ISO 8601, and the very strict s...

... when using the imperial measurement system ... That's the fundamental mistake. It's completed in a funny way by misusing the minus sign as a separator where it easily can be misunderstood as an arithmetic operator. BTW: 1. Canada joined the metre convention (negotiated and signed 1875 by many c...

imacanuck wrote: ↑Mon Apr 08, 2024 6:12 pm ...
I just need it to also extract a number such as 3.5 which is written as 3-1/2 in the text string.

(Spoken aside:)
If someone claims that they are transmitting a value of 3.5 as "3-1/2" instead of "3+1/2", I would question their understanding and not trust the information.

... not last cell in a column or last cell in a row -- - last cell on sheet with value ... There isn't such a thing generally. To call a cell the last one regarding one or another property would require a clearly defined linear order of all the cells. Such an order doesn't exist. Only if you can as...

It's a doubtable idea to restart (hitchhike) a thread which slept more than 5 years. General opinionated topics are well placed in the forum's branch "General Discussion". In the given case the plea for an additional tool (function) to repair (remove) unwanted formatting once created by th...

Why is this so difficult? How does one set up an accumulator. A spreadsheet is no pocket calculator which has an accumulating register. Spreadsheets also have no variables usable as accumulators like any general-purpose program. If you want to use a spreadsheet cell as an accumulator you basically ...

A macro can do it, but it must be written and called.
Charts have complicated models, and I'm not sure for which types the proposed (roughly sketched) solution will work. (Tested with AOO V 4.1.7.)

@ svetlanaSG If your "you" is me: Sorry. I obviously expressed myself not precisely enough. I didn't want to tell anybody how to "make different page styles". I thought the ordinary way to create an additional page style is to use the Styles pane (formerly "Stylist"), t...

1. I will not go to google for the purpose. 2. I tested my example with AOO 4.1.7 before I posted it, and it worked as expected. 3. An additionally re-downloaded copy also did just now again. 4. The "sensitive cell" is J2. Depending on settings Ctrl+Click may be needed to activate the link...

Also a related demo (just because I had already made it):

Attach a sheet showing the issue - or post as a minimum the exact formula contained in the cell reporting the error. After all you need to get the target cell correctly first, and there are lots of opportunities to include syntactical errors (and also semantical ones, of course). Attaching an image ...

Are you both aware of the fact that page styles aren't applied to single pages, but to the maximum sequence of pages containing the current ViewCursor position (interactive mode) and being delimited at the beginning by either start of docoument or by a page starting with a first paragraph (or respec...

Can someboy help me to understand? Current OperatingSystems should synchronize their clock with a time server automatically. Generally there should not be any need for a user to address a specific one (or a google "service") explicitly. Calc spreadsheets know the standard function TODAY()....

In pursuit of a badly worded question in the "Macros" forum I used some time to develop a solution for which now the problem (question) is missing. Possibly there are a few visitors interested in the code. I will also attach a demonstrating .odt. Note (1): The currently fresh LibO version ...

To be clear: I didn't comment on JeJe's posts. The ViewCursor wasn't a means for me to get a grip on any textfield. I went through all the textfields, jumped over different subtypes, and selected the ...textfield.Annotation objects to be able to get positioning information ( page, position.Y, positi...

I took the time to go a bit deeper into this, and must report that it wasn't just fun. There are versions that accept anchors with non-empty strings, others do not. With the most recent version of LibO (24.2) you cannot even select the anchor of an annotation, by user code, and therefore you cant't ...

To collect all the annotations contained in a Writer document (even if nested into any textcontent objects there) is simple. A next solution using the Basic object 'Collection' you find in the attached example: annotationExperiments.odt An open question is how to make reasonable use of the result. A...

I don't need the trick myself, but it was somehow interesting. See attached demo. It was created with a recent LibreOffice (7.6 or 24.2) and needed a few changes to also run in AOO 4.1.7. The code pasted into the first page of the Writer doc does not contain these changes. aoo111317HideShapeGroupsIn...

Recent versions of LibreOffice Calc allow a setting >Anchor>To Cell (resize with cell) for any shape. For shapes anchored to cells (instead of "To Sheet") there is also a tool named Fit to Cell Size available from the context menu. Having used the tool, and having set the anchor type, the ...

Compound names are a mess from the beginning and should never be considered data. See https://www.kalzumeus.com/2010/06/17/falsehoods-programmers-believe-about-names/ 1. through 40. and the statements below. (An exception could be if all your contacts have names of type John Doe that are syntactical...

¡¿aha?!
Since the number of downloads of my first attachment shows some interest, i attacfh also an enhanced example containig a working solution based on the group/ungroup idea:

I never work with Draw documents unambiguously belonging one of your "cases". Or are you talking of a currently selected shape? Or... In what way, precisely, would you distinguish the cases? Anyway: Simply select your case with a helper function, and set the DrawPage index you actually nee...

I probably can't understand the subject "Insert File ...", but: 1. The CurrentController of a Draw document can select a DrawPage (all its shapes as a "temporary group"). 2. Draw doesn't support the macro recorder. 3. AOO is under very slow (if any) development. Better shift to L...

Are there geodata assigned to your zip codes? These could be, for example, geographical coordinates of the area centers. If so you might use distances calculated as known from ordinary trigonometry (small total area) or distances calculated by means of spherical geometry (large area). The zip-codes ...

It seems you didn't read my explanation concerning the difference between SEARCH() and FIND(). I rely daily on two or more commercial softwares using DD.MMSS, and a several of my self-created spreadsheets. Perhaps there are types of software that already use a ";" instead of "."....

One final post by me: 1. I would like to ask the OriginalQuestioner to replace in his first post (the question) the subject by something like "Why doesn't my macro show the expected result?". 2. There is a serious suggestion how to replace entries misusing an ordinary decimal format by usi...

=MID("4.3000);SEARCH(".";E23)+1;2) isn't a correct formula at all and the reference to E23 doesn't make sense. Did you mean =MID(4.3000;SEARCH(".";4.3000)+1;2) If so you should get the string ".3" returned. I assume you accepted the setting >Tools>Options>LibreOff...

To get recorded code to adapt its working better to your needs, you have to edit it introducing substantial changes and enhancements. On the other hand some wanted adaptions of action are better supported by some .uno: commands than by standard API means. This seems to be the case of "pasting s...

@4joey1, as this seems to be your first post, welcome to the forum. And a few remarks: 1. The OO.o version your signature is showing is very old. So is the Win version. There may not still be many ucontributors knowing any special problems related to that combination. 2. The subject of your post men...