Search found 11275 matches

by Zizi64
Wed Mar 27, 2024 8:42 am
Forum: Writer
Topic: Spell check not working, at all, one document
Replies: 6
Views: 337

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?
by Zizi64
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: 385

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...
by Zizi64
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: 385

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...
by Zizi64
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: 385

Re: Need a macro to change percent in cell to value*100

'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.
by Zizi64
Sun Mar 24, 2024 11:23 am
Forum: Macros and UNO API
Topic: Sort onto another sheet
Replies: 8
Views: 934

Re: sort onto another sheet

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.
by Zizi64
Sun Mar 24, 2024 10:50 am
Forum: General Discussion
Topic: Letters and numbers doubled in Windows 10
Replies: 3
Views: 304

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...
by Zizi64
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: 452

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...
by Zizi64
Mon Mar 18, 2024 7:59 am
Forum: Calc
Topic: [Solved] Keep formula from changing if columns are deleted
Replies: 4
Views: 456

Re: Keep formula from changing

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.
by Zizi64
Sun Mar 17, 2024 8:28 am
Forum: Writer
Topic: [Dropped] Blank Page Partially Covering Text
Replies: 9
Views: 1060

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...
by Zizi64
Sun Mar 10, 2024 11:16 pm
Forum: Impress
Topic: "Fade" the image borders
Replies: 2
Views: 314

Re: "Fade" the image borders

The Impress is not a pixelgraphic editor. Use third paty softwares for that task.
by Zizi64
Thu Feb 29, 2024 8:32 am
Forum: Writer
Topic: [Solved] Documents seem to default to 2-line spacing
Replies: 22
Views: 4264

Re: [Solved] Documents seem to default to 2-line spacing

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.
by Zizi64
Wed Feb 28, 2024 2:20 pm
Forum: Writer
Topic: [Solved+Issue] Tooltip hints for formula fields
Replies: 22
Views: 1920

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...
by Zizi64
Tue Feb 27, 2024 4:15 pm
Forum: Writer
Topic: [Solved+Issue] Tooltip hints for formula fields
Replies: 22
Views: 1920

Re: Tooltip hints for formulas

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.
by Zizi64
Mon Feb 26, 2024 8:10 am
Forum: Writer
Topic: [Solved+Issue] Tooltip hints for formula fields
Replies: 22
Views: 1920

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...
by Zizi64
Sat Feb 24, 2024 3:00 pm
Forum: Calc
Topic: [Solved] Calc won't calculate (AutoCalculate=checked)
Replies: 7
Views: 962

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...
by Zizi64
Mon Feb 19, 2024 8:43 pm
Forum: Calc
Topic: [Solved] Hyperlinks lost when Calc closed
Replies: 12
Views: 1039

Re: Hyperlinks lost when Calc closed

What file type of spreadsheets are you using?

Can you upload an ODF type sample file here?
by Zizi64
Thu Feb 15, 2024 8:35 am
Forum: Calc
Topic: [Solved] Unable to fit images to cells
Replies: 3
Views: 831

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...
by Zizi64
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: 642

Re: ole Embedded DIAGRAM X / Y - x axis labels

Please upload the full macro code and an ODF type sample file here.
by Zizi64
Sun Feb 11, 2024 11:34 am
Forum: Calc
Topic: Searching with Find Toolbar causes crash
Replies: 4
Views: 1466

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...
by Zizi64
Sun Feb 04, 2024 4:56 pm
Forum: Writer
Topic: Text won't wrap around object at top of page
Replies: 4
Views: 815

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.
by Zizi64
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...
by Zizi64
Thu Feb 01, 2024 6:01 pm
Forum: LibreOffice
Topic: [Solved] LibreOffice Version Numbers: now 24.2.0!
Replies: 10
Views: 3239

Re: What is Going on With LibreOffice Version Numbers? (LibreOffice 24.2.0!)?

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... :lol: :bravo:
by Zizi64
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?
by Zizi64
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
by Zizi64
Wed Jan 31, 2024 5:21 am
Forum: Calc
Topic: [Solved] Calc footer page number insert
Replies: 4
Views: 730

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...
by Zizi64
Wed Jan 31, 2024 5:11 am
Forum: Calc
Topic: [Solved] Calc footer page number insert
Replies: 4
Views: 730

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...
by Zizi64
Tue Jan 30, 2024 9:12 pm
Forum: Calc
Topic: [Solved] Method setValue() ignored in Basic function
Replies: 3
Views: 722

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...
by Zizi64
Tue Jan 30, 2024 9:06 pm
Forum: LibreOffice
Topic: [Solved] Recorded macro doesn't perform copy paste steps
Replies: 8
Views: 1566

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?
by Zizi64
Tue Jan 30, 2024 8:57 pm
Forum: Calc
Topic: [Solved] Method setValue() ignored in Basic function
Replies: 3
Views: 722

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.
by Zizi64
Tue Jan 30, 2024 6:48 pm
Forum: Forms
Topic: I have JRE, but Base shows JRE not installed
Replies: 3
Views: 939

Re: I have JRE , but base showss jre not installed

Java HotSpot(TM) 64-Bit Server VM (build 25.401-b10, mixed mode)

My open office version is 4.1.15
The Windows version of the Apache OpenOffice is a 32 bit software. It requests 32 bit Java.