Go to Start > Settings > Apps > Installed apps > search for OpenOffice ...
Klik the … next to the item, choose Change, not Remove
Knock yourself out
Search found 160 matches
- Sun Apr 21, 2024 12:21 pm
- Forum: MS Windows
- Topic: [Solved] PDQ install
- Replies: 15
- Views: 1009
- Sat Apr 20, 2024 1:46 pm
- Forum: Macros and UNO API
- Topic: [Solved] Macro button to hide/unhide rows in Calc
- Replies: 7
- Views: 900
Re: Macro button for hide/unhide rows in Calc
You were almost there. Try this one: Sub hideRows14_17() oDoc=ThisComponent oSheet=oDoc.CurrentController.ActiveSheet myRange=oSheet.getCellRangeByPosition(,13,,16) myRange.Rows.IsVisible=false End Sub Mind you getCellRangeByPosition takes as arguments (start_column,start_row,end_column,end_row) hen...
- Thu Mar 21, 2024 1:13 pm
- Forum: Calc
- Topic: [Solved] Calculation with date yields #VALUE!
- Replies: 10
- Views: 1272
Re: Subtracting one day from a date yields #VALUE!
Use Search and Replace to convert your text to numeric values.
Search for : .* (= dot+star)
Replace by: &
Make sure you've checked Regular expressions under "More"
You probably want to change the column A in the formula in A2 to C : so =IF(D2>0,0395833;C2-1;"")
Search for : .* (= dot+star)
Replace by: &
Make sure you've checked Regular expressions under "More"
You probably want to change the column A in the formula in A2 to C : so =IF(D2>0,0395833;C2-1;"")
- Sun Feb 25, 2024 12:06 pm
- Forum: Calc
- Topic: [Solved] Remove unwanted entries in AutoInput selection list
- Replies: 7
- Views: 4133
Re: Selection List
Unless someone has a better idea, the only way I know of to flush this list is to uninstall Open Office and install a fresh copy. As far as I know, that selection list is filled with the values that come from the same column, nothing else. So, if you want to delete or modify something, you should l...
- Wed Feb 21, 2024 2:45 pm
- Forum: Base
- Topic: [Dropped] Vehicle Tracking Base
- Replies: 11
- Views: 1784
Re: Vehicle Tracking Base
Maybe you should have a look here:
https://wiki.openoffice.org/wiki/Docume ... _with_Base
https://wiki.openoffice.org/wiki/Docume ... _with_Base
- Sun Feb 18, 2024 5:07 pm
- Forum: Writer
- Topic: [Solved] Display page numbers instead of field name
- Replies: 9
- Views: 1632
Re: Display page numbers instead of field name
Not on my Dutch version.Hagar Delest wrote: ↑Sun Feb 18, 2024 12:13 am Isn't English available by default for any localized version?
Userinterface is nl - no dropdown, just Dutch
I can however choose another Locale if I should wish that
- Mon Jan 22, 2024 12:46 pm
- Forum: Macros and UNO API
- Topic: [Solved] Count property ignored for .uno:GoUp
- Replies: 7
- Views: 2064
Re: .uno:GoUp "Count" property is not work for me
In Basic:
Code: Select all
Sub Move10Up()
Dim oViewCursor As Object
oViewCursor = ThisComponent.CurrentController.getViewCursor()
oViewCursor.goUp(10, False)
End Sub
- Sun Dec 24, 2023 6:50 pm
- Forum: Forum Governance
- Topic: [Solved] Rationalization of the Macro forum sections
- Replies: 10
- Views: 2944
Re: [Solved] Rationalization of the Macro forum sections
Thanks for that. Looks good to me.
- Sun Dec 24, 2023 11:55 am
- Forum: Forum Governance
- Topic: [Solved] Rationalization of the Macro forum sections
- Replies: 10
- Views: 2944
- Wed Dec 06, 2023 12:18 pm
- Forum: Macros and UNO API
- Topic: [Solved] Protect/Unprotect sheets {identified by name or ...] in macro
- Replies: 15
- Views: 3497
Re: Naming sheet in macro
Code: Select all
sub PROTECT_SHEET()
oSheet = ThisComponent.Sheets.getByName("Summary Accounts")
oSheet.protect("MY PASSWORD")
end sub
- Tue Dec 05, 2023 2:26 pm
- Forum: Macros and UNO API
- Topic: [Solved] Protect/Unprotect sheets {identified by name or ...] in macro
- Replies: 15
- Views: 3497
Re: Naming sheet in macro
Or take a look here: viewtopic.php?t=87424
- Mon Dec 04, 2023 1:54 pm
- Forum: MS Windows
- Topic: [Solved] Cannot install or open
- Replies: 3
- Views: 1629
Re: Cannot Install or Open
If you really are on Windows you shouldn't have a "pkg" It should be an .exe file to install.
For instance for English US it would be: Apache_OpenOffice_4.1.14_Win_x86_install_en-US.exe !
Download from here to find your download: https://www.openoffice.org/nl/download/index.html
For instance for English US it would be: Apache_OpenOffice_4.1.14_Win_x86_install_en-US.exe !
Download from here to find your download: https://www.openoffice.org/nl/download/index.html
- Mon Nov 13, 2023 5:48 pm
- Forum: Writer
- Topic: [Solved] Add new pages to document
- Replies: 21
- Views: 3634
Re: Page addition
Would this help?
I have a document with a lot of pages set up. but it is too big to place here.
Send me an PM with an emailaddress and I'll send it to you
I have a document with a lot of pages set up. but it is too big to place here.
Send me an PM with an emailaddress and I'll send it to you
- Sat Oct 21, 2023 12:41 pm
- Forum: MS Windows
- Topic: [Solved] Can't open files with OpenOffice after Windows update
- Replies: 3
- Views: 4928
Re: Can't open files
Could be that your file extensions (.odt, .ods etc) are assigned to Word, Excel instead of OpenOffice.
Read this viewtopic.php?p=417022#p417022
to see if that brings back OpenOffice
Read this viewtopic.php?p=417022#p417022
to see if that brings back OpenOffice
- Wed Oct 11, 2023 2:02 pm
- Forum: Calc
- Topic: [Solved] Calc changes dates on each opening of file
- Replies: 8
- Views: 3419
Re: Calc changes dates on each opening of file
Well, I set it only once and it sticks to all new spreadsheets
Don't know what went wrong on your side, but as I said, you should only have to set it once
Don't know what went wrong on your side, but as I said, you should only have to set it once
- Wed Oct 11, 2023 1:15 pm
- Forum: Calc
- Topic: [Solved] Calc changes dates on each opening of file
- Replies: 8
- Views: 3419
Re: Calc changes dates on each opening of file
Looks like your "Day 0" is off.
Check Options - OpenOffice Calc- Calculate to see if the Date is set to 30-12-1899.
I assume it is set to 01-01-1904 which gives the difference of five years and a day
Check Options - OpenOffice Calc- Calculate to see if the Date is set to 30-12-1899.
I assume it is set to 01-01-1904 which gives the difference of five years and a day
- Sun Aug 13, 2023 11:51 am
- Forum: User Experience (UX)
- Topic: [Solved] Recent documents list too short
- Replies: 8
- Views: 6127
Re: [Solved] Recent documents list too short
You can now download it directly from Mr. Marcelly's page:fuzzymo wrote: ↑Sat Aug 12, 2023 11:57 pm History Master is no longer available.
It directs to www.sfr.fr when you try to download which appears to have been shut down.
https://berma.pagesperso-orange.fr/HM/H ... -1.1.1.oxt
- Tue Aug 01, 2023 1:46 pm
- Forum: Mac OSX
- Topic: [Solved] Download and install new version of AOO
- Replies: 3
- Views: 3763
Re: Download and install new version of AOO
Well, it is.
But as Mr. programmer said:
But as Mr. programmer said:
MrProgrammer wrote: ↑Mon Jul 31, 2023 5:51 pm Check for Update is exactly that, a check to see if updates are available. OpenOffice never installed the updates. You must to install them, but that is very simple.
- Tue Jul 25, 2023 1:00 pm
- Forum: Math
- Topic: [Solved] Can't write a literal character (%) in a Math object
- Replies: 9
- Views: 18181
Re: [Solved] Can't write a literal character (%) in a Math object
Use ~ or ` for a great or small gap respectively between
that will get you the spaces you desire:
Code: Select all
{x}over{y}~=~{20}over{94}~=`21"%"
- Fri Jun 30, 2023 12:52 pm
- Forum: Calc
- Topic: [Solved+Issue] Data Validity Dropdown - It's full of blank lines!
- Replies: 3
- Views: 439
Re: Data Validity Dropdown - It's full of blank lines!
Check Data > Validity to see if the blank lines are in your cell range or list
- Thu Sep 08, 2022 4:35 pm
- Forum: Writer
- Topic: [Dropped] Line numbering not working
- Replies: 43
- Views: 3223
Re: Line numbering not working
With RoryOF settings of the margins to 2.00 cm.
Tools > LineNumbering ON
Tools > LineNumbering ON
- Mon Sep 05, 2022 3:20 pm
- Forum: Tutorials
- Topic: 26 Free Open Office 4 Calculator Tutorials - Youtube
- Replies: 1
- Views: 4051
Re: 26 Free Open Office 4 Calculator Tutorials - Youtube
Thank you very much for that
- Mon Sep 05, 2022 12:03 pm
- Forum: Calc
- Topic: [Solved] Quickly test if there is any data entry in a spreadsheet
- Replies: 9
- Views: 1208
Re: How to quickly test if there is any data entry in a spreadsheet?
Try File > Properties > Statistics
- Wed Aug 24, 2022 2:07 pm
- Forum: Macros and UNO API
- Topic: [Solved] Testing StarBasic Sort Algorithms with Calc cells
- Replies: 8
- Views: 3346
Re: Testing StarBasic Sort Algorithms
I just also downloaded the above attached file (was the fourth one to do so), treated it as described in my previous post attach a little archive with a fake extension. It's containing two files: An unsorted .tsv of data and an .odg holding the code. Extract the archive to an empty folder, enter yo...
- Wed Aug 24, 2022 11:23 am
- Forum: Macros and UNO API
- Topic: [Solved] Testing StarBasic Sort Algorithms with Calc cells
- Replies: 8
- Views: 3346
Re: Testing StarBasic Sort Algorithms
Lupp,
AOo complains that the downloaded file is damaged. Won't open
AOo complains that the downloaded file is damaged. Won't open
- Mon Aug 22, 2022 5:17 pm
- Forum: Install, Setup and Troubleshooting
- Topic: Merge a photo on a photo for printing
- Replies: 2
- Views: 678
Re: Merge a photo on a photo for printing
Insert the Cover in Draw and also insert the Other picture in that document. Click on Other picture and drag it on the Cover. Place it where you want. Then select both by dragging a rectangle around the cover. {IMPORTANT] With this selection, select File - Export and select SELECTION in the Save dia...
- Thu Aug 11, 2022 6:05 pm
- Forum: Draw
- Topic: [Dropped] OO Draw: Remove Print Boundary Lines
- Replies: 4
- Views: 6246
Re: OO Draw: Remove Print Boundary Lines
See if setting the Margins to 0 gives some relief.
Format > Page > section Margins
Format > Page > section Margins
- Tue Aug 02, 2022 4:16 pm
- Forum: Writer
- Topic: [Solved] Spelling error in Danish Format → Page dialog
- Replies: 3
- Views: 653
Re: Spelling error in Danish Format → Page dialog
This should be fixed in code now (Danish sdf file https://lists.apache.org/thread/y74tvqd ... 6b3fmkqnvl ).
Future versions should no longer have this error.
If that may not be the case, please inform us again.
Future versions should no longer have this error.
If that may not be the case, please inform us again.
- Fri Jul 29, 2022 12:02 pm
- Forum: Writer
- Topic: [Solved] Spelling error in Danish Format → Page dialog
- Replies: 3
- Views: 653
Re: Spelling error in Danish Format → Page dialog
Thanks for reporting.
Submitted in Pootle.
Should be fixed in future versions
Submitted in Pootle.
Should be fixed in future versions
- Fri Jul 22, 2022 11:50 am
- Forum: Calc
- Topic: [Solved] Empty Data Validity selection list for a cell
- Replies: 9
- Views: 1034
Re: Selection List
Select the cell you want to affect and then go to the menu Data -> Validity. On the Criteria tab, in the Allow section, choose All Values from the drop down list. Select the column (click the header) you want to affect and then go to the menu Data -> Validity. On the Criteria tab, in the Allow sect...