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.
Search found 11276 matches
- Thu Mar 28, 2024 7:55 pm
- Forum: Macros and UNO API
- Topic: Scale picture in merged Calc cells
- Replies: 2
- Views: 254
- Wed Mar 27, 2024 8:42 am
- Forum: Writer
- Topic: Spell check not working, at all, one document
- Replies: 6
- Views: 364
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: 394
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: 394
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: 394
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: 946
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: 344
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: 470
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: 459
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: 1071
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: 316
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: 4269
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: 1926
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: 1926
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: 1926
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: 963
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: 1040
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: 833
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: 647
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: 1468
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: 818
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: 892
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: 3286
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: 780
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: 778
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: 731
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: 731
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...
- Tue Jan 30, 2024 9:12 pm
- Forum: Calc
- Topic: [Solved] Method setValue() ignored in Basic function
- Replies: 3
- Views: 724
Re: SetValue() function doesn`t work
Is there any way to modify/overwrite the value of other cell? Yes, there are. - You can use a Sub instead of the Function. But you must launch it by other way. (You can not call it from a cell.) - You can modify the values of some adjacent cells (a specific cell range) by creating an Array function...
- Tue Jan 30, 2024 9:06 pm
- Forum: LibreOffice
- Topic: [Solved] Recorded macro doesn't perform copy paste steps
- Replies: 8
- Views: 1570
Re: Macros unable to reproduce copy paste steps in LibreOffice 7.6.4.1 Windows 10 64 bit
Can you upload the recorded macro code embedded into a sample file?
- Tue Jan 30, 2024 8:57 pm
- Forum: Calc
- Topic: [Solved] Method setValue() ignored in Basic function
- Replies: 3
- Views: 724
Re: SetValue() function doesn`t work
A custom macro Cell function can not modify the value of other cell than the function was called from.