Apache OpenOffice Community Forum

DiGro

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;"")

DiGro

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

DiGro

Maybe you should have a look here:
https://wiki.openoffice.org/wiki/Docume ... _with_Base

DiGro

Hagar Delest wrote: ↑Sun Feb 18, 2024 12:13 am Isn't English available by default for any localized version?

Not on my Dutch version.
Userinterface is nl - no dropdown, just Dutch

I can however choose another Locale if I should wish that

DiGro

In Basic:

Code: Select all

Sub Move10Up()
  Dim oViewCursor As Object
  oViewCursor = ThisComponent.CurrentController.getViewCursor()
  oViewCursor.goUp(10, False)
End Sub

DiGro

Thanks for that. Looks good to me.

DiGro

I agree

DiGro

Code: Select all

sub PROTECT_SHEET()
oSheet = ThisComponent.Sheets.getByName("Summary Accounts")
oSheet.protect("MY PASSWORD")
end sub

DiGro

Or take a look here: viewtopic.php?t=87424

DiGro

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

DiGro

Would this help?

Sparkys tutorial.odt: (19.25 KiB) Downloaded 92 times

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

DiGro

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

DiGro

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

DiGro

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

: Options_OpenOffice Calc_Calculate.png (12.47 KiB) Viewed 3366 times

DiGro

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.

You can now download it directly from Mr. Marcelly's page:

https://berma.pagesperso-orange.fr/HM/H ... -1.1.1.oxt

DiGro

Well, it is.

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.

DiGro

Use ~ or ` for a great or small gap respectively between

Code: Select all

{x}over{y}~=~{20}over{94}~=`21"%"

that will get you the spaces you desire:

: With gaps; CutPerc_with_gaps.PNG (2.01 KiB) Viewed 16508 times

DiGro

Check Data > Validity to see if the blank lines are in your cell range or list

DiGro

With RoryOF settings of the margins to 2.00 cm.

Tools > LineNumbering ON

DiGro

Thank you very much for that

DiGro

Try File > Properties > Statistics

DiGro

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

DiGro

Lupp,

AOo complains that the downloaded file is damaged. Won't open

DiGro

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

DiGro

See if setting the Margins to 0 gives some relief.

Format > Page > section Margins

DiGro

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.

DiGro

Thanks for reporting.
Submitted in Pootle.
Should be fixed in future versions

DiGro

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

DiGro

AKle wrote: ↑Sun Jun 26, 2022 4:32 pm […] My request appeared, because I often forget, which files are already open.

OK, then click Window on the menu bar

DiGro

Maybe this will help: viewtopic.php?p=58403

Search found 158 matches

Re: Subtracting one day from a date yields #VALUE!

Re: Selection List

Re: Vehicle Tracking Base

Re: Display page numbers instead of field name

Re: .uno:GoUp "Count" property is not work for me

Re: [Solved] Rationalization of the Macro forum sections

Re: Rationalization of the Macro forum sections

Re: Naming sheet in macro

Re: Naming sheet in macro

Re: Cannot Install or Open

Re: Page addition

Re: Can't open files

Re: Calc changes dates on each opening of file

Re: Calc changes dates on each opening of file

Re: [Solved] Recent documents list too short

Re: Download and install new version of AOO

Re: [Solved] Can't write a literal character (%) in a Math object

Re: Data Validity Dropdown - It's full of blank lines!

Re: Line numbering not working

Re: 26 Free Open Office 4 Calculator Tutorials - Youtube

Re: How to quickly test if there is any data entry in a spreadsheet?

Re: Testing StarBasic Sort Algorithms

Re: Testing StarBasic Sort Algorithms

Re: Merge a photo on a photo for printing

Re: OO Draw: Remove Print Boundary Lines

Re: Spelling error in Danish Format → Page dialog

Re: Spelling error in Danish Format → Page dialog

Re: Selection List

Re: After a double-click on a file already loaded to OpenOffice nothing happens

Re: AOO 'crashed' but allows opening of file!