And of course remember to save as file type ODF Spreadsheet Template (.ots)

You haven't (inadvertently?) placed OpenOffice in full screen mode as mentioned in the link MrProgrammer provided above?

If you have anchored the images to page - which you should only do if you understand the consequences - you will have problems. If the images are anchored otherwise they should move with the text.

With that little information, it is hard to know what is going on.

Perhaps you might try LibreOffice.

Please don't SHOUT, it is considered impolite.

Press F1 to open Help; search Transpose and see the process described.

Is this what you want? Sheet1 is the source, Sheet2 is the transposed values.

Or this where Sheet2 is the source and Sheet1 is the transposed values.

Can you please update your signature to include details of your operating system?

A (hopefully) repaired document has been sent to OP; the problem was the annotations bug with MS Office documents.

Edit: You might want to look at Using Styles and Templates [PDF] to make production of your document easier.

I've sent you a PM* with contact details. The link of course only allows one to download a file that can't be opened without some degree of expertise; make of that what you will. And remember - you aren't paranoid if they are really out to get you

* PM -> Private Message

How to upload a file - with pictures to assist.

Or use a recipe manager; why drive a screw with a hammer when a more suitable tool is available?

https://www.pitonyak.org/oo.php is a highly recommended source of information about OpenOffice macros.

Cross posted on AskLibreOffice where some discussion has ensued.

If you cross post, as a courtesy please let us know that you have done so, otherwise it leads to several discussions and a waste of time because several identical answers may be posted by different users.

I can access the LibreOffice.org home page Strictly speaking, you are in fact opening the LibreOffice Start Centre on your computer. Using the terminology home page would confuse anyone trying to help you. I cannot see any way to create a LibreOffice Account, download any built in help, get any Lib...

You have perhaps downloaded LibreOffice from a nonofficial site and may have acquired some unexpected extra bonus with your download. You may wish to check your system for unwanted extras. https://www.libreoffice.org/download/download-libreoffice/ is the correct download site and doesn't involve any...

LMGTFY

https://osxdaily.com/2015/06/17/home-en ... functions/

Also make sure to select Detect special numbers.

In addition [Tutorial] Text to Columns has instructions on elimination of the initial apostrophe which prevents values from being recognized as numbers/dates/times.

Forget it. It's all nonsense. Don't you get it

Spoilsport. You must be great fun at parties

For those who may have missed the announcement elsewhere:

Dear All,

The Apache OpenOffice Development Team is proud to announce that the next releases will introduce an important change: a text-only user interface.

Read more:
https://openoffice.apache.org/blog/back ... ative.html

If you haven't closed the amended file, you could use repeated Ctrl+Z (Undo) to restore the file to previous states.

Otherwise, if you have enabled backup file using Tools | Options | Load/Save | General you could use that. Last resort [Tutorial] How to find and un-delete AOO/LO temporary files

It may also be possible that OpenOffice is looking for a defined printer that is offline. Try changing the setting for the 'Load printer settings with the document' option under Tools| Options| Load/Save| General.

It is off by default at installation; but perhaps someone has accidentally turned it on via keyboard shortcut Ctrl+F8.

There is a little trap with UTC +9:30 - Alice Springs and the whole Northern Territory, together with all of South Australia share the same time zone; however only South Australia observes daylight saving time.

2) my Q above is "are the words 'smallest' and 'largest' in the incorrect places? should they be reversed?

No - the numbers refer to the amount of compression of the image, from 0, none to 9, maximum amount. Obviously the more the file is compressed, the smaller it will be.

In computing a k is taken to be 1024 characters Unless you happen to be buying something; manufacturers seem to round the kilobyte and other sizes down. For instance, this from the Kingston website about USB drives: Megabyte (MB) = 1,000,000 bytes; 1 Gigabyte (GB) = 1,000,000,000 bytes; 1 Terabyte ...

It depends; are you using characters that may require more than one byte per character? Anyway, somewhere on the order of 64000. 64 Kb is of course 64 * 1024 (a Kilobyte).

Have you looked at [Troubleshooting] Spell check in OpenOffice? In particular see 3 Paragraph Style Settings - it may be that the language of the document doesn't match.

Yes it is possible - it is well described in the Mail Merge chapter of the Writer Guide.

Well really there seems not much need for it in the forums I mentioned - they seem to me to be for information rather than problem solving.

The specific topic that floris v linked seems like it might better be placed elsewhere.

Seems to be the case for both the User Experience and Announcement forums that the Post Icons have been disabled - or not enabled - for both those forums. I tried several topics in each forum with the same result. I don't have karma to see that level of administration on the board; perhaps Hagar wil...