That is what templates are for. Create a a document with all the attributes that you want as your default, save it as a template then set that template as your default for calc. For more information read the help files or ask on either the user forum at https://forum.openoffice.org/en/forum/ or on the user mailing list at mailto:users@openoffice.apache.org

But a similar issue still occurs: when you move cells, the left-over space will not use my favorite font.

That is a problem with your template, not with AOO. I just created a new spreadsheet template saved it and set as default following the instructions in the help. It sounds like you just took an existing spreadsheet and set it as default without changing the font in all the cells.

This is a bug tracker not a help desk. Please address your question to either of the support venues mentioned in Comment 1.

I selected all and set it to Custom Font and size 9, saved it and set as default template. New table documents are now full of Custom Font and size 9, but when I move cells the left-over space is Arial and size 10.

Also what do you mean by AOO? AndrOpenOffice, the Android copy? I'm using Windows.

AOO == Apache OpenOffice

AOO == Apache OpenOffice

IMMEDIATELY FIX THIS IT MAKES ME CRY!!!!!!!!!!!!

THAT'S BECAUSE I CAN'T MOVE OR CUT INSTEAD I HAVE TO COPY, DELETE AND PASTE!!!!!! THAT'S AWFUL FIX THIS RIGHT NOW!!!!!!!!!!!!!!!!!!!!!

Please create an template of your own. This is no problem in OpenOffice.

Closing issue again due to comemnt 1 and 3.

So that means I have to use 2 templates?

Maybe as I don't know your environment and working style.

I assume when I add this template again, you will say I need a third template, then a fourth, and so on.

I think that we do not understand your problem. 

If you mark all cells with ctrl+a or a click in the upper left header where row number and headerline (the one that says A,B,C and so forth) meet, the selected font should change to blank.
Deselect the font you want.
From this moment on any new row should appear with the new font.

If that not happens check on hidden columns/rows.
Open them and then it should work.

For defaulting for all new documents you need to setup a template which is explained above. Then each new document will come with the preferred font.

I hope this solves the issue.

I think that we do not understand your problem. 

If you mark all cells with ctrl+a or a click in the upper left header where row number and headerline (the one that says A,B,C and so forth) meet, the selected font should change to blank.
Deselect the font you want.
From this moment on any new row should appear with the new font.

If that not happens check on hidden columns/rows.
Open them and then it should work.

For defaulting for all new documents you need to setup a template which is explained above. Then each new document will come with the preferred font.

I hope this solves the issue.

This video shows how OpenOffice Calc is creepy with my configurations:

https://mega.nz/#!GDwXULTY!02iAIyWyagnwqvd2hK9dcyxB2q2u6lhhecL-E9dD9Pw

I cannot see anything in the video, is it normal that everything is so dark? Also it looks somewhat broken in the middle and end.

Anyway, I think I've understood your problem. When you cut out cells, the formatting is automatically reset to system defaults which can be different to the font setting in the document.

Have you tried the font replacement function? Maybe it can help to keep a specific font (see menu "Tools - Options - OpenOffice - Fonts").

BTW:
Don't expect any further and detailed help when you are shouting at people. Yes, writing everything in uppercase (comment #8 and #9) *is* shouting.

The reason everything is so dark is because I have a dark theme on my PC. And the "middle and end" is not really "somewhat broken", it is intentionally distorted because it's creepy!

I was not able to reproduce what you described with AOO 4.1.5 and Win7.
A template set as default keep customized font with no problem.
Moving, deleting or copying range don't reset font as Arial.