Search found 3535 matches
- Thu Apr 18, 2024 2:18 pm
- Forum: MS Windows
- Topic: PDQ install
- Replies: 7
- Views: 483
Re: PDQ install
... 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:...
- Sat Apr 13, 2024 1:42 pm
- Forum: Calc
- Topic: [Solved] Extract numbers from a string of alphanumeric text
- Replies: 27
- Views: 94121
Re: Extracting the numbers from a string of alphanumeric tex
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...
- Sat Apr 13, 2024 12:14 am
- Forum: Calc
- Topic: [Solved] Extract numbers from a string of alphanumeric text
- Replies: 27
- Views: 94121
Re: Extracting the numbers from a string of alphanumeric tex
... 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...
- Wed Apr 10, 2024 10:51 am
- Forum: Calc
- Topic: [Solved] Extract numbers from a string of alphanumeric text
- Replies: 27
- Views: 94121
Re: Extracting the numbers from a string of alphanumeric tex
(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.
- Wed Apr 03, 2024 11:21 pm
- Forum: Calc
- Topic: Revisit an old topic - find last
- Replies: 6
- Views: 868
Re: Revisit an old topic - find last
... 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...
- Mon Apr 01, 2024 12:17 am
- Forum: Writer
- Topic: [Solved] Errant double horizontal line: can't delete
- Replies: 47
- Views: 47363
Re: [Solved] Errant double horizontal line: can't delete
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...
- Sat Mar 30, 2024 7:11 pm
- Forum: Calc
- Topic: [Solved] Running total in accumulator
- Replies: 6
- Views: 994
Re: Running Total
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 ...
- Sat Mar 23, 2024 8:26 pm
- Forum: Macros and UNO API
- Topic: [Solved] Use cell reference for chart's scale maximum
- Replies: 6
- Views: 950
Re: Use cell reference for chart's scale maximum
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.)
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.)
- Fri Mar 22, 2024 2:59 pm
- Forum: Macros and UNO API
- Topic: [Solved] Applying a new style to a page in Writer using Java code
- Replies: 7
- Views: 1129
Re: Applying a new style to a page in Writer using Java code
@ 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...
- Thu Mar 21, 2024 9:34 pm
- Forum: Calc
- Topic: Hyperlink to today's date
- Replies: 18
- Views: 1567
Re: Hyperlink to today's date
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...
- Thu Mar 21, 2024 8:31 pm
- Forum: Calc
- Topic: Hyperlink to today's date
- Replies: 18
- Views: 1567
Re: Hyperlink to today's date
Also a related demo (just because I had already made it):
- Thu Mar 21, 2024 8:03 pm
- Forum: Calc
- Topic: Hyperlink to today's date
- Replies: 18
- Views: 1567
Re: Hyperlink to today's date
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 ...
- Thu Mar 21, 2024 7:02 pm
- Forum: Macros and UNO API
- Topic: [Solved] Applying a new style to a page in Writer using Java code
- Replies: 7
- Views: 1129
Re: Applying a new style to a page in Writer using Java code
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...
- Thu Mar 21, 2024 6:36 pm
- Forum: Calc
- Topic: Hyperlink to today's date
- Replies: 18
- Views: 1567
Re: Help with Hyperlink to today's date
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()....
- Tue Mar 12, 2024 3:24 pm
- Forum: Code Snippets
- Topic: Getting a sorted overview of all the annotations contained in a Writer document
- Replies: 1
- Views: 707
Getting a sorted overview of all the annotations contained in a Writer document
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 ...
- Mon Mar 11, 2024 11:28 pm
- Forum: Macros and UNO API
- Topic: Get all Annotations/Comments/Notes
- Replies: 17
- Views: 2191
Re: Get all Annotations/Comments/Notes
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...
- Mon Mar 11, 2024 10:35 pm
- Forum: Macros and UNO API
- Topic: Get all Annotations/Comments/Notes
- Replies: 17
- Views: 2191
Re: Get all Annotations/Comments/Notes
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 ...
- Sun Mar 10, 2024 7:50 pm
- Forum: Macros and UNO API
- Topic: Get all Annotations/Comments/Notes
- Replies: 17
- Views: 2191
Re: Get all Annotations/Comments/Notes
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...
- Mon Mar 04, 2024 7:02 pm
- Forum: Macros and UNO API
- Topic: Macro to hide all objects within a group
- Replies: 16
- Views: 2052
Re: Macro to hide all objects within a group
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...
- Thu Feb 15, 2024 12:12 pm
- Forum: Calc
- Topic: [Solved] Unable to fit images to cells
- Replies: 3
- Views: 858
Re: Unable to fit images to cells
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 ...
- Wed Feb 14, 2024 2:07 pm
- Forum: Calc
- Topic: [Solved] Sort a column of first and last names
- Replies: 4
- Views: 805
Re: Sort a column of names
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...
- Sun Feb 11, 2024 9:24 pm
- Forum: Macros and UNO API
- Topic: Draw: "Insert File" into file
- Replies: 12
- Views: 2687
Re: Draw: "Insert File" into file
¡¿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:
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:
- Thu Feb 08, 2024 5:40 pm
- Forum: Macros and UNO API
- Topic: Draw: "Insert File" into file
- Replies: 12
- Views: 2687
Re: Draw: "Insert File" into file
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...
- Wed Feb 07, 2024 11:59 pm
- Forum: Macros and UNO API
- Topic: Draw: "Insert File" into file
- Replies: 12
- Views: 2687
Re: Draw: "Insert File" into file
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...
- Wed Feb 07, 2024 12:04 am
- Forum: Calc
- Topic: [Dropped] Determine nearby locations using German postal codes
- Replies: 11
- Views: 1336
Re: Set of 10 000 lines (records): (address data) arrange a Nearby search via zip code
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 ...
- Sat Feb 03, 2024 12:46 am
- Forum: Macros and UNO API
- Topic: [Solved] Why doesn't Calc show the macro result?
- Replies: 16
- Views: 2747
Re: [Solved] Why doesn't Calc show the macro result?
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 "."....
- Fri Feb 02, 2024 4:04 pm
- Forum: Macros and UNO API
- Topic: [Solved] Why doesn't Calc show the macro result?
- Replies: 16
- Views: 2747
Re: [Solved] Why doesn't Calc show the macro result?
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...
- Fri Feb 02, 2024 1:19 pm
- Forum: Macros and UNO API
- Topic: [Solved] Why doesn't Calc show the macro result?
- Replies: 16
- Views: 2747
Re: [Solved] Why doesn't Calc show the macro result?
=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...
- Thu Feb 01, 2024 11:14 pm
- Forum: LibreOffice
- Topic: [Solved] Recorded macro doesn't perform copy paste steps
- Replies: 8
- Views: 2083
Re: Macros unable to reproduce copy paste steps in LibreOffice 7.6.4.1 Windows 10 64 bit
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...
- Wed Jan 31, 2024 4:33 pm
- Forum: LibreOffice
- Topic: [Solved] Recorded macro doesn't perform copy paste steps
- Replies: 8
- Views: 2083
Re: Macros unable to reproduce copy paste steps in LibreOffice 7.6.4.1 Windows 10 64 bit
@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...