Here is a similat topic with macro code snippets and an Extension (.oxt):
viewtopic.php?t=98070
Search found 11279 matches
- Sun Apr 07, 2024 8:31 am
- Forum: Calc
- Topic: Changing background to RGB values from cells
- Replies: 2
- Views: 258
- Sun Apr 07, 2024 7:55 am
- Forum: Calc
- Topic: Changing background to RGB values from cells
- Replies: 2
- Views: 258
Re: Changing background to RGB values from cells
The macros can do it. Write your own macro function or subroutine.Is this something that can be done?
- Sat Mar 30, 2024 7:14 am
- Forum: Calc
- Topic: Running total in accumulator
- Replies: 6
- Views: 858
Re: Running Total
What is so difficult? A very simple rule: You can not store a single constant number AND a Formula in same time in a Cell. But you can store the new values (as constant) in the Formulas: For A12: =A11+23.45 For A13: =A12+33.45 Of course the Cell will not display the new entered constant value, but i...
- Thu Mar 28, 2024 7:55 pm
- Forum: Macros and UNO API
- Topic: Scale picture in merged Calc cells
- Replies: 2
- Views: 517
Re: Scale picture in merged Calc cells
The recent LibreOffice versions have a built-in feature for resizing the images: "Fit to cell size". It works for me with merged cells too.
- Wed Mar 27, 2024 8:42 am
- Forum: Writer
- Topic: Spell check not working, at all, one document
- Replies: 6
- Views: 580
Re: Spell check not working, at all, one document
Dis you set the proper language property in the applied Paragraph style?
Can you upload an ODF type sample file here?
Can you upload an ODF type sample file here?
- Tue Mar 26, 2024 6:47 am
- Forum: Macros and UNO API
- Topic: Need a macro to change percent in cell to value*100
- Replies: 4
- Views: 626
Re: Need a macro to change percent in cell to value*100
for II = 120 to 270 oDoc=ThisComponent oSheet = oDoc.Sheets.getByName("Calcs") Why you call the same ThisComponent and Sheets.getByName("Calcs") functions so many times (inside the for cycle)? It is enough to call it once. The StarBasic has a low speed anyway. Dol not slowener i...
- Tue Mar 26, 2024 6:42 am
- Forum: Macros and UNO API
- Topic: Need a macro to change percent in cell to value*100
- Replies: 4
- Views: 626
Re: Need a macro to change percent in cell to value*100
oCell.String = Value(Pct)*100 There is not a function named "Value()" in the StarBasic. The existing one is the "Val()" The "Value()" is a Cell Function. And you can not call the spreadsheet Cell Functions such simple way. (is is possible, but it is more diffcoult.) Or...
- Tue Mar 26, 2024 6:30 am
- Forum: Macros and UNO API
- Topic: Need a macro to change percent in cell to value*100
- Replies: 4
- Views: 626
Re: Need a macro to change percent in cell to value*100
The "apostrophe - number - percent unit" combo seems a STRING imported from a .csv, .tsv file. In this case you must import the data properly before, or you must remove the apostrophe sign by the macro.'25.1%
- Sun Mar 24, 2024 11:23 am
- Forum: Macros and UNO API
- Topic: Sort onto another sheet
- Replies: 8
- Views: 1202
Re: sort onto another sheet
Then your macros was not stored inside the document. Always create backup copies of your important data, documents, macros, etc.I have a spreadsheet that was made in office but when the operating system was upgraded to windows 11 all macros were removed .
- Sun Mar 24, 2024 10:50 am
- Forum: General Discussion
- Topic: Letters and numbers doubled in Windows 10
- Replies: 3
- Views: 607
Re: помощь
in Windows 10, letters and numbers are kind of double How it is related to the Apache OpenOffice or LibreOffice. It is happened only inside the AOO/LO? Can you upload a screeshot image here? The Win10 works fine for me with the AOO and with the LO too. Maybe is is a graphic card (hardware or driver...
- Sun Mar 24, 2024 8:14 am
- Forum: Macros and UNO API
- Topic: [Solved] Use cell reference for chart's scale maximum
- Replies: 6
- Views: 752
Re: Use cell reference for chart's scale maximum
Here is a "solution" with macro cell function. It for the Ymin value only, but you can modify the macro code. It will refresh automatically, when the passed parameters are changed.(Tested in the LibreOffice 7.5.8): https://ask.libreoffice.org/t/create-a-dynamic-left-axis-in-calc/103407/7 T...
- Mon Mar 18, 2024 7:59 am
- Forum: Calc
- Topic: [Solved] Keep formula from changing if columns are deleted
- Replies: 4
- Views: 643
Re: Keep formula from changing
It may depends on the fact that you want delete columnHow do I keep =COUNTA(C4:BZ4) from changing when I delete columns?
- after the referenced cell range,
- before the referenced cell range,
- inside the referenced cell range.
- Sun Mar 17, 2024 8:28 am
- Forum: Writer
- Topic: [Dropped] Blank Page Partially Covering Text
- Replies: 9
- Views: 1185
Re: Blank Page Partially Covering Text
I'd like to know why OO is doing this (my fault or software glitch) I suppose that you have pasted something from the internet directly. Never do it! Always paste text content as "Unformatted text". Always use the "Insert - Image (from file)" menu item for the pictures never pas...
- Sun Mar 10, 2024 11:16 pm
- Forum: Impress
- Topic: "Fade" the image borders
- Replies: 2
- Views: 456
Re: "Fade" the image borders
The Impress is not a pixelgraphic editor. Use third paty softwares for that task.
- Thu Feb 29, 2024 8:32 am
- Forum: Writer
- Topic: [Solved] Documents seem to default to 2-line spacing
- Replies: 22
- Views: 4396
Re: [Solved] Documents seem to default to 2-line spacing
It is a direct (manual) formatting method. I strongly suggest you to use the Styles instead of it.I solved this simply by going to 'Format' then 'Paragraph' then 'Line spacing'.
- Wed Feb 28, 2024 2:20 pm
- Forum: Writer
- Topic: [Solved+Issue] Tooltip hints for formula fields
- Replies: 22
- Views: 2040
Re: [Issue] Tooltip hints for formulas
From your sample file: a=1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6+1+2+3+4+5+6...
- Tue Feb 27, 2024 4:15 pm
- Forum: Writer
- Topic: [Solved+Issue] Tooltip hints for formula fields
- Replies: 22
- Views: 2040
Re: Tooltip hints for formulas
Please upload a real, ODF type sample file here.Example. Source document 4 pages. After "Ctrl + F9" - 52 pages. It is difficult to find the one, the most necessary formula.
Image
- Mon Feb 26, 2024 8:10 am
- Forum: Writer
- Topic: [Solved+Issue] Tooltip hints for formula fields
- Replies: 22
- Views: 2040
Re: Tooltip hints for formulas
Formatting is completely lost. For big documents, it's a problem. What formatting is lost? The formatting of the Fields? What type of the fields are you using in the Writer document showed by your attached images? Can you upload an ODF type sample file here? What settings (of the fields or of the h...
- Sat Feb 24, 2024 3:00 pm
- Forum: Calc
- Topic: [Solved] Calc won't calculate (AutoCalculate=checked)
- Replies: 7
- Views: 1077
Re: [SOLVED] OO v4.1.15 Calc won't calculate even if AutoCalculate=checked and View Formulas=unchecked
Note: The Calc will show the result of 2^64 as 18446744073709600000, but the correct result is 18446744073709551616. The "Double precision floating point numbers" (what the spreadsheet softwares use) can not show precisely those huge integers. You must use some tricks for displaying a prec...
- Mon Feb 19, 2024 8:43 pm
- Forum: Calc
- Topic: [Solved] Hyperlinks lost when Calc closed
- Replies: 12
- Views: 1111
Re: Hyperlinks lost when Calc closed
What file type of spreadsheets are you using?
Can you upload an ODF type sample file here?
Can you upload an ODF type sample file here?
- Thu Feb 15, 2024 8:35 am
- Forum: Calc
- Topic: [Solved] Unable to fit images to cells
- Replies: 3
- Views: 844
Re: Unable to fit images to cells
You can align an image PRECISELY to a cell by some macros. (You must realign them when the cell size changed.) Similar topic: https://forum.openoffice.org/en/forum/viewtopic.php?t=34544 REM ***** BASIC ***** option explicit Sub fitGraphics() Dim oDoc As Object Dim oSheet As Object Dim oShape as Obje...
- Thu Feb 15, 2024 7:25 am
- Forum: Macros and UNO API
- Topic: [Dropped] OLE-embedded DIAGRAM X / Y - x axis labels
- Replies: 1
- Views: 848
Re: ole Embedded DIAGRAM X / Y - x axis labels
Please upload the full macro code and an ODF type sample file here.
- Sun Feb 11, 2024 11:34 am
- Forum: Calc
- Topic: Searching with Find Toolbar causes crash
- Replies: 4
- Views: 1483
Re: Find words not working
For example, I wanted to search (find) a simple word such as "Ceramic" in my spreadsheet and it just kicks you out. There is an option for the searching function: "Entire cells" When this option is checked on, the F&R function will found the cells only where there is not any...
- Sun Feb 04, 2024 4:56 pm
- Forum: Writer
- Topic: Text won't wrap around object at top of page
- Replies: 4
- Views: 901
Re: Text Won't Wrap Around Object At Top of Page
A real sample file can help us more - then we can help you...
An image can not give us enough information about the applied styles and settings.
An image can not give us enough information about the applied styles and settings.
- Fri Feb 02, 2024 7:52 pm
- Forum: Calc
- Topic: [Solved] Add values with a slash
- Replies: 6
- Views: 900
Re: [Solved] Add values with a slash
Or you can use the function SILLYSUM() as you can see in my attachment: SillySum.ods It is a macro function. You can imporove it for more error handling or more features. Here is the code: REM ***** BASIC ***** Option Explicit Function SillySum(aRangeValues as variant) Dim Sum_0, Sum_1 as long Dim l...
- Thu Feb 01, 2024 6:01 pm
- Forum: LibreOffice
- Topic: [Solved] LibreOffice Version Numbers: now 24.2.0!
- Replies: 10
- Views: 3853
Re: What is Going on With LibreOffice Version Numbers? (LibreOffice 24.2.0!)?
And the release date is 2024-01-31It seems that the developers have short memories and didn't learn the lession of Y2K.
https://blog.documentfoundation.org/blo ... fice-24-2/
Plus, it's easy to mistake for a 1924 mechanical typewriter/calculator combo...
- Wed Jan 31, 2024 4:04 pm
- Forum: Calc
- Topic: [Solved] Linear regression
- Replies: 2
- Views: 794
Re: Linear regression
Have you tried the LINEST() array function?
Can you upload an ODF type sample file here?
Can you upload an ODF type sample file here?
- Wed Jan 31, 2024 5:33 am
- Forum: Tablets
- Topic: Where's the AndrOpen menu gone?
- Replies: 1
- Views: 984
Re: Where's the menu gone?
Try to ask the developers of the AndrOpenOffice:
https://play.google.com/store/apps/deta ... l=hu&gl=US
Or you can try the Collabora Office:
https://play.google.com/store/search?q= ... s&hl=en_US
https://play.google.com/store/apps/deta ... l=hu&gl=US
Or you can try the Collabora Office:
https://play.google.com/store/search?q= ... s&hl=en_US
- Wed Jan 31, 2024 5:21 am
- Forum: Calc
- Topic: [Solved] Calc footer page number insert
- Replies: 4
- Views: 748
Re: Calc Footer Page Number Insert Not Working
The "Page" and "Pages" icons do not insert those items in the Footer. Those words do appear when the cursor is on those icons. Thy will not insert the words "Page" and "Pages" automatically, but the number only. You must type-in the words manually. (Or you ca...
- Wed Jan 31, 2024 5:11 am
- Forum: Calc
- Topic: [Solved] Calc footer page number insert
- Replies: 4
- Views: 748
Re: Calc Footer Page Number Insert Not Working
Thank you for the attachment. (It works fine in my LibreOffice 7.5.8 version and in my AOO portable 4.1.13 version.) But: However, the first 2 pages are portrait orientation and display page numbers 1 and 2. That is, Page 1 of 5 and Page 2 of 5. The next 3 are landscape. Of those, the first 2 displa...