When exporting this to PDF, the text disappears.

Is it a free font, or licensed commercial font? There are some restrictions for embedding of the non free fonts into the native documents, and into the PDF-s.

In C4
= "Deposit @"&Text(J2;"0")&"%"

what an arrogant and high and mighty answer thanks for nothing and i'm glad you wasted your precious time being a wise guy and a flippant all knowing jackass You are not an exempt member either. Just follow the Forum rules. The AOO has two, and the LibreOffice has three sizes of the icon sets. You ...

Here is a similat topic with macro code snippets and an Extension (.oxt):

viewtopic.php?t=98070

Is this something that can be done?

The macros can do it. Write your own macro function or subroutine.

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...

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.

Dis you set the proper language property in the applied Paragraph style?
Can you upload an ODF type sample file here?

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...

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...

'25.1%

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.

I have a spreadsheet that was made in office but when the operating system was upgraded to windows 11 all macros were removed .

Then your macros was not stored inside the document. Always create backup copies of your important data, documents, macros, etc.

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...

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...

How do I keep =COUNTA(C4:BZ4) from changing when I delete columns?

It may depends on the fact that you want delete column
- after the referenced cell range,
- before the referenced cell range,
- inside the referenced cell range.

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...

The Impress is not a pixelgraphic editor. Use third paty softwares for that task.

I solved this simply by going to 'Format' then 'Paragraph' then 'Line spacing'.

It is a direct (manual) formatting method. I strongly suggest you to use the Styles instead of it.

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...

Example. Source document 4 pages. After "Ctrl + F9" - 52 pages. It is difficult to find the one, the most necessary formula.
Image

Please upload a real, ODF type sample file here.

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...

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...

What file type of spreadsheets are you using?

Can you upload an ODF type sample file here?

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...

Please upload the full macro code and an ODF type sample file here.

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...

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.

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...

It seems that the developers have short memories and didn't learn the lession of Y2K.

And the release date is 2024-01-31
https://blog.documentfoundation.org/blo ... fice-24-2/

Plus, it's easy to mistake for a 1924 mechanical typewriter/calculator combo...

Have you tried the LINEST() array function?
Can you upload an ODF type sample file here?