Yes, a template is the method for controlling the default settings of your documents. Here is a short version of the instructions: Set the Default cell style to have the font size you want and set up any other style preferences. Choose the menu File -> Templates -> Save. Name the template and save i...

The control of freezing or splitting the view of a Calc document is done through the WIndow menu, not a button. Do you not see the Window menu item near the top of the screen?

With a Writer document open, go to the menu Tools -> AutoCorrect Options. On the Localized Options tab, click the Replace box in the Singe Quotes section. That should be all you need to do.

I added a new Slide 2. It has two content boxes. Can you add text to the left box and an image to the right one, or does even that fail?

Can you post a presentation with a slide that demonstrates this problem. I recently inserted a lot of images in Impress using AOO 4.1.15 and I did not see this problem.

I don't know of any way to break the connection between the chart and its data other than copying it, but that doesn't mean there aren't any. Before you rebuild the chart, I suggest you make a simple x-y plot with just one series. Save and close the file, reopen it and see if the data range is still...

The problem is that your graph has lost its connection to the original data set. That is why you see the data table instead of a data range. I believe this can happen when you copy a graph. Did you build the graph on one sheet and then copy it to another sheet?

I would break this into three columns. Say your text is in A1. In C1, find the first non-alpha character with =SEARCH("[^[:alpha:]]";A1) In D1, find the first alpha character that is after the non-alpha character =SEARCH("[:alpha:]";A1;C1) In E1, pull the text between those posit...

There is no obvious use for that formula. Besides the broken reference, it is set to return the first column in the reference table, which would just be the value of column A.

I managed to open content.xml and it's a mess. It seems to be only style definitions. I couldn't find any user data, though I was simply scrolling through, so I easily could have missed something. Near the end of the file, it is badly damaged. For example <style:style style:namepable-cell-properties...

I got the document but I can't extract the content.xml file. The ods file does open as a zip archive but the tools I have on WIndows and Linux Mint say "An error occurred while extracting the file" when I try to extract content.xml. I can successfully extract other files from the archive, ...

I will send you a private message with my email address.
It is not frequent that documents get corrupted, but it can happen. Always back up documents. And a usb is particularly likely to get lost or damaged.

If you post the document here, someone can take a look at the internal structure and possibly fix it. To post a document, click Post Reply and look for the Attachments tab just below the box where you type a response.

Here is a video that suggests killing msiexec.exe jobs in the Task Manager. Do you see any of those?
Video

I think the Enter key is the one to use to accept the suggested text.

I'm not understanding your problem, though I have never before pinned individual documents to the taskbar. If I drag a Calc file from my desktop to the taskbar, I see a message that says "Pin to OpenOffice Calc". When I release the file icon, there is a Calc icon on the taskbar and right c...

When you import the csv, you should see at some point a dialog labeled Import Text. At the bottom of that there is a display of a few rows of data. At the top of each column, there is a label that says Standard. You can right click on that and set the data type of the column. For your numbers, you p...

The apostrophe is not part of the cell content. It is displayed in the formula bar to indicate that the cell content is text, despite looking like a number. How were these cell value entered? If they were imported from a text (csv) file, you can adjust the import process to avoid the whole problem.

What were you trying to do when you would get the message about Java?

You should be able to go to Tools -> Options and set up the Java as shown in this image. Ignore the OpenJDK, that isn't relevant to your case. Click on the "Use a Java runtime environment box" and wait several seconds. If your Java is not detected, use the Add button to point to the jre-1....

Do you have a folder named C:\Program Files (x86)\Java\? What is in there?

If this happens with all documents, try resetting your user profile. The crash might have damaged it. With OpenOffice shutdown, open any folder and enter %appdata%\openoffice\4 in the address bar. Rename the user folder to user_old . Restart OpenOffice and you should get the registration screen. Che...

Go to the menu Tools -> Options and expand the OpenOffice list on the left. Select Java. Select the check box "Use a Java runtime environment". Use the Add button to point to
C:\Program Files (x86)\Java\jre-1.8
or the equivalent folder in your Java installation

This thread suggests you shutdown the computer and then retry the installation. Note that it should be a true shutdown and not just a quick restart.

The file is almost certainly damaged beyond repair. You can post it here and let others take a look, though confidentiality might be a problem for you. Is there any back up of you One Drive files?

a) The formulas will automatically be displayed in the the language of the user's OpenOffice locale. There is no need to translate them. b) Column headers in other languages are not usually a problem but it might make the document easier to understand if they were in English. The most helpful things...

Yes, the MIN() function won't work. The formula relies on the fact that TRUE comparisons have a value of 1. When A1:A8 = "A" is true, it gets the value 1 and the same goes for B1:B8 = "". You end up with 1 * 1 * C1:C8 for the rows where both the test conditions are TRUE. A FALSE ...

A formula like the following, entered as a array formula, works for me if the maximum value is positive.

In the Text Import dialog that you should get as part of importing a csv file, there is a table at the bottom showing a few rows of data and the data type under which they will be imported. The default type is Standard. Right click on the word standard and pick something appropriate for the column. ...

Your dates and your numbers have entered the cells as text and are being sorted alphabetically. How is the data being entered into Calc?