Ask Your Question

Stephen's profile - activity

2020-09-27 20:46:38 +0200 marked best answer #ref! showing in .xls file

Editing an .xls file. Numerous cells do not dsiplay normally showing '#ref!' and code such as '=INDEX(OFFSET($Input.A:A,,shift),MATCH(F22,$Input.A:A,0)+3,)' .

I am not conversant in formulas. I was only seeking to add some text to this file. It displays normally in Excel Online

I would appreciate any comments. Thanks.

2020-08-19 05:06:21 +0200 commented question Blank Menus and Dialogue boxes

Seemed a problem only when two windows on the same doc were open

2020-08-19 04:46:01 +0200 asked a question Blank Menus and Dialogue boxes

Blank Menus and Dialogue boxes Just updated to LO 7. Dialogue boxes and menus are blank. Thanks for any help.

2020-07-13 08:52:18 +0200 received badge  Famous Question (source)
2020-06-18 21:23:55 +0200 received badge  Notable Question (source)
2020-06-18 21:23:55 +0200 received badge  Popular Question (source)
2020-03-28 08:13:53 +0200 received badge  Famous Question (source)
2019-05-30 08:52:53 +0200 asked a question Presentation with non sequential / non linear points

Presentation with non sequential / non linear points Would like to ask if it's possible to create a presentation with no

2019-05-21 03:15:55 +0200 asked a question Spellcheck not function / reset user profile

Spellcheck not function / reset user profile Have installed appropriate dictionaries. Spell check does not work, and des

2019-05-03 14:57:46 +0200 received badge  Famous Question (source)
2018-11-29 23:04:33 +0200 received badge  Famous Question (source)
2018-09-20 14:21:43 +0200 received badge  Notable Question (source)
2018-09-19 01:47:06 +0200 answered a question Automatically Save as PDF

Thanks for answering. Yes I mean the 'Export As' function. The problem being is that if you work on directory (a), save

2018-09-18 21:35:07 +0200 received badge  Popular Question (source)
2018-09-18 16:48:29 +0200 asked a question Automatically Save as PDF

Automatically Save as PDF I'm sure many would appreciate the function of a setting where a text document would be automa

2018-06-18 02:00:18 +0200 marked best answer DocInformation:Tile appearing instead of title

Have a lot docs with title in headers. There is a 'title' field. Instead of showing the title, the headers now display 'DocInformation:Title.' Instead of page numbers appearing, it displays 'pagenumber.' Thanks.

2018-06-09 08:43:19 +0200 received badge  Popular Question (source)
2018-06-07 14:13:36 +0200 received badge  Supporter (source)
2018-06-07 12:08:10 +0200 answered a question DocInformation:Tile appearing instead of title

Whoops. Thanks for your rapid reply. Silly mistake.

2018-06-07 12:06:39 +0200 edited question DocInformation:Tile appearing instead of title

DocInformation:Tile appearing instead of title Have a lot docs with title in headers. There is a 'title' field. Instead

2018-06-07 11:53:14 +0200 asked a question DocInformation:Tile appearing instead of title

DocInformation:Tile appearing instead of title Have a lot docs with title in headers. There is a 'title' field. Instead

2018-01-22 04:33:58 +0200 received badge  Famous Question (source)
2018-01-22 04:33:58 +0200 received badge  Notable Question (source)
2018-01-22 04:33:58 +0200 received badge  Popular Question (source)
2017-10-19 09:19:08 +0200 commented question Libreoffice Hangs when using Thesaurus

Based in Hong Kong, using UK English. The text was set for UK English. Windows 10, latest updates. Yes I've reset my use

2017-10-19 08:45:58 +0200 asked a question Libreoffice Hangs when using Thesaurus

Libreoffice Hangs when using Thesaurus Using the thesaurus (ctl+F7) caused LO to hang. It became totally unresponsive. I

2017-10-10 04:34:21 +0200 edited answer How to make tick marks and bullets in the libreoffice menu black in Linux?

What you show in your image is not a 'context menu.' A context menu is what pops up when you 'right-click' on various p

2017-10-10 01:51:58 +0200 answered a question How to make tick marks and bullets in the libreoffice menu black in Linux?

What you show in your image is not a 'context menu.' A context menu is what pops up when you 'right-click' on various p

2017-10-10 01:44:29 +0200 commented question move right left doesn't work

What happens with the arrow key in other applications? Perhaps your 'scroll lock' key is on

2017-10-10 01:41:14 +0200 commented question move right left doesn't work

What happens with the arrow key in other applications?

2017-10-10 01:40:22 +0200 commented question move right left doesn't work

Does this happen only in Calc? Does it happen in Write too? How about in Notepad or any other of your default apps?

2017-10-10 01:36:05 +0200 commented question Repeated crashing

OK Mike. Just one of those things. I'll just get used to efficiently resetting the profile. Thanks for taking the troubl

2017-10-09 12:08:52 +0200 commented question Repeated crashing

Mike would you be able to shed any light on why these files become 'corrupted' and what may be done to prevent this? I'd

2017-10-09 09:00:37 +0200 commented question Repeated crashing

remarks deleted -

2017-10-09 07:41:23 +0200 commented question Repeated crashing

Please note that the instructions are unclear on that page. They say 'If the problem is solved, one or more files on you

2017-10-09 07:32:23 +0200 commented question Repeated crashing

Hi Mike Thanks. I'll try that.

2017-10-09 07:32:23 +0200 received badge  Commentator
2017-10-09 07:20:33 +0200 asked a question Repeated crashing

Repeated crashing Running LO on Windows 10. LO 5.4.1.2. It just now repeatedly crashes. Any attempt to open files causes

2017-09-14 10:05:02 +0200 received badge  Notable Question (source)
2017-09-14 01:49:35 +0200 asked a question Paths setting not working

Paths setting not working Under Tools>Options>Paths I have set the paths so that it points at the directory I stor

2017-09-13 06:13:34 +0200 commented answer Preserve header contents on document's styles updated from template

Thanks Kruno for your helpful response. I'll follow all your useful suggestions.

2017-09-12 08:33:05 +0200 received badge  Popular Question (source)
2017-09-12 06:21:03 +0200 edited answer Preserve header contents on document's styles updated from template

Thanks for your answer. The headers in the template and the documents are identical. When a new document is opened, I ad

2017-09-12 06:19:48 +0200 edited answer Preserve header contents on document's styles updated from template

Thanks for your answer. The headers in the template and the documents are identical. When a new document is opened, I ad

2017-09-12 04:52:37 +0200 edited answer Preserve header contents on document's styles updated from template

Thanks for your answer. The headers in the template and the documents are identical. When a new document is opened, I ad

2017-09-12 04:26:33 +0200 answered a question Preserve header contents on document's styles updated from template

Thanks for your answer. The headers in the template and the documents are identical. When a new document is opened, I ad

2017-09-11 06:16:34 +0200 asked a question Preserve header contents on document's styles updated from template

Template adjustment - 'Update styles' - header disappears Any slight adjustment to a template results in previous docume

2017-07-27 13:34:36 +0200 received badge  Notable Question (source)
2017-07-17 21:29:20 +0200 received badge  Notable Question (source)
2017-07-01 05:44:00 +0200 commented answer Bullet points break up borders

Ah, good one. Thanks.