Apache OpenOffice Community Forum

I have made a template of running financial data.
It has the date; day; stock market models/predictions by account size, £/pt, margin, number of points...; income; withdrawal; income from other sources; bank account; and expenses.
Each column perpetuates itself on formulae.
Certain information on holidays is excluded using formulae, and the dates of holidays are listed and highlighted until the end of 2026.
Column breaks have been added for ease of reading.
Top row is frozen for ease of reading.
I've been working on it for a while.
Navigation short-cuts: CTRL+SHIFT+Arrows; ALT+Arrows for adjusting width/height of cells; CTRL+PGUP/PGDN for switching between sheets; SHIFT+F4 for locking cells; CTRL+S for saving; CTRL+W for closing; CTRL+Z for undo; CTRL+C for copy; CTRL+V for paste; CTRL+X for cut; CTRL+B for bold; CTRL+I for italic; CTRL+U for underline; ...
I have put "END" at the end of each of column of filled data to make it easier to navigate from top to bottom.
I have had to abridge it so that it could be uploaded.
Please remember that the main purpose for this spreadsheet is STOCK MARKET.
Stock market is a MIXTURE of BOTH ART, FEELING, AND MATHEMATICS.
As such, not all of the formulae are ubiquitous, some cells have been replaced with raw data or left empty to be determined on the day.
Please feel free to steal it and adjust it for your own purposes.
Please feel free to give me suggestions and feedback on its functionality and spreadsheet technicality.

Hi, thank you for uploading your template. warning: Most people won't find your template here. You should really submit it in the Templates sections of Apache OpenOffice and of LibreOffice (especially in the LibreOffice section). See https://templates.openoffice.org/ and https://extensions.libreoffice.org/. Upload it there in the template format; save as a template with extension .ots instead of .ods, (that's the extension for an ordinary Calc spreadsheet document).

Hi Floris, you're right, thanks for telling me.
I've been trying for a few hours, but keep getting this message.

A guess: try replacing the - and the spaces in the fiilename with underscores.

Still the same, after 2 attempts.