Ask Your Question

Mark McLean's profile - activity

2019-01-07 12:07:04 +0200 answered a question cell range list with date content, show content format as number

If i understand your question, try to format the cells, Ctrl+1/numbers.

2018-12-14 02:14:27 +0200 answered a question general input/output error keeps destroying my work

Had same problem with Calc! I saved it as an Excel xls 97-2003 file. Saved fine, reopened it, and it wanted to find a fi

2018-11-27 20:22:22 +0200 marked best answer Saving personal dictionary, (the words I added to LibreOffice dictionary), saving or copying them to another computer.

I have added many words from King James Bible to the current dictionary in LibreOffice and would like to transfer to another computer. Or is there a dictionary with all the old English King James Bible that I could add to LibreOffice? https://wp.me/pa0PtW-14 <--Sorts Bible verses in a Biblical order!

2018-11-06 13:29:09 +0200 answered a question Fast way to count duplicates in 30000 rows (LibreOffice Calc)

I do not think I am understanding the question clearly, but I believe this will help. Formulas to quickly show if any ma

2018-11-04 14:41:36 +0200 commented answer how to do a horizontal screen split

Ah, new tool or option to me, didn't know of split, thought they meant freeze. Thanks again Lupp.

2018-11-04 14:40:46 +0200 commented answer how to do a horizontal screen split

Ah, new tool to me, didn't know of split, thought they meant freeze. Thanks again Lupp.

2018-11-04 02:53:42 +0200 answered a question how to do a horizontal screen split

Select Cell...View/Freeze Rows Columns.

2018-11-03 02:32:00 +0200 commented answer I need macro click help

Put questions, comments in, "add a comment", not here, this for answers! make it active, enter a number, and look up to,

2018-11-01 01:28:01 +0200 edited answer I need macro click help

http://bit.ly/faithalone. No password needed, just unlock, many buttons, formula's and simple macros. I learned much fro

2018-10-31 20:23:40 +0200 edited answer I need macro click help

http://bit.ly/faithalone. No password needed, just unlock, many buttons, formula's and simple macros. I learned much fro

2018-10-31 20:14:08 +0200 edited answer I need macro click help

This is large, no password needed, just unlock, many buttons, formula's and simple macros. I learned much from reading q

2018-10-31 19:50:37 +0200 answered a question I need macro click help

This is large, no password needed to to unlock, many buttons, simple macros. I learned much from reading questions here,

2018-10-27 17:23:02 +0200 edited answer I cannot open my Libre Office for some reason!

Restart computer..? And or install newest LibreOffice update. ? Updates will not affect your personal files, files will

2018-10-27 12:53:51 +0200 answered a question I cannot open my Libre Office for some reason!

Restart computer..? And or install newest update. ? Updates will not affect your personal files, files will still be the

2018-10-23 10:56:19 +0200 commented question libreoffice Freeze / block

LO website may know, that version 6.0 will work on your old windows 7!?? I would try to install what LO proposed..

2018-10-15 13:00:32 +0200 commented answer Is there a fix for libreoffice not working after Windows 10 Fall update?

Yes it does, but mine is only 21MB. My path is C/Users/Administrator/AppData/Roaming/LibreOffice/4/user. I just copy/sav

2018-10-15 12:34:38 +0200 commented answer Is there a fix for libreoffice not working after Windows 10 Fall update?

Yes it does, but mine is only 21MB. My path is C/Users/Administrator/AppData/Roaming/LibreOffice/4/user. I just copy/sav

2018-10-15 11:42:31 +0200 commented answer Is there a fix for libreoffice not working after Windows 10 Fall update?

Yes it does, but mine is only 21MB. My path is C/Users/Administrator/AppData/Roaming/LibreOffice/4/user. I just copy/sav

2018-10-15 11:14:48 +0200 edited answer Is there a fix for libreoffice not working after Windows 10 Fall update?

I have Windows 10, version 1803, last update was 10/10/2018, (auto update check 10/14/2018! Runs great and LibreOffice 6

2018-10-15 11:09:26 +0200 edited answer Is there a fix for libreoffice not working after Windows 10 Fall update?

I have Windows 10, version 1803, last update was 10/10/2018, (auto update check 10/14/2018! Runs great and LibreOffice 6

2018-10-15 11:07:08 +0200 edited answer Is there a fix for libreoffice not working after Windows 10 Fall update?

I have Windows 10, version 1803, last update was 10/10/2018, runs great and LibreOffice 6.1 also runs great with it, I u

2018-10-15 11:05:46 +0200 answered a question Is there a fix for libreoffice not working after Windows 10 Fall update?

I have Windows 10, version 1803, runs great and LibreOffice 6.1 also runs great with it, I use it daily! I would uninsta

2018-10-13 09:51:11 +0200 commented answer Why is LibreOffice taking up 67.2 GB of my storage space?

Yup. Mine 535MB

2018-09-29 12:17:41 +0200 commented question how to get ride of a hightlighted bible verse that I pasted on to a page before printing?

Hi @fireball. Here is a Bible program that you may find very helpful, saves, selected verses and sorts them Biblically

2018-08-31 17:53:56 +0200 commented answer how can i make a cell linkable to another spreadsheet

Oh, I do such with macro assigned to a button. I don't know how one could do such by clicking a cell.

2018-08-31 02:48:14 +0200 edited answer Bible verses collected, and sorted by books, chapters and verses, in a Biblical order in LibreOffice calc.

Knowing many others save favorite verses for study and/or for sermons, and having used this file daily for years, LibreO

2018-08-30 20:59:36 +0200 answered a question how can i make a cell linkable to another spreadsheet

If I am understanding!? Enter = where you want results to show, and than just go to whatever sheet/cell you want and hit

2018-08-30 00:06:15 +0200 commented question Saving current Bible verse

Here is one that has worked. http://bit.ly/dailydesire. It sorts collected verses with your notes on each verse, sorts i

2018-08-30 00:03:33 +0200 commented question Is there a way to create an index of Biblical references?

http://bit.ly/dailydesire, This page has a file to go to that will sort verses aright. Sorry I forgot! And just happen t

2018-08-29 22:09:38 +0200 edited answer Where can I find the user profile in libreoffice 6.0.6.2X64?

I found mine by the path in LibreOffice! Menu/Tools/Options/LibreOffice/PATHS. Mine was C/User/Administrator/AppData/Ro

2018-08-29 21:51:51 +0200 answered a question Where can I find the user profile in libreoffice 6.0.6.2X64?

I found mine by the path in LibreOffice! Menu/Tools/Options/LibreOffice/PATHS. What also help me is to have LibreOffice

2018-08-28 18:11:58 +0200 commented question Excel has many Bible reading plans, can I convert to LibreOffice Calc file? Safely?

Needed to change link, had free site, but only for so long.

2018-08-28 18:10:52 +0200 edited question Excel has many Bible reading plans, can I convert to LibreOffice Calc file? Safely?

Excel has many Bible reading plans, can I convert to LibreOffice Calc file? Safely? Here is a free one http://bit.ly/fai

2018-08-28 18:03:49 +0200 edited question Bible verses collected, and sorted by books, chapters and verses, in a Biblical order in LibreOffice calc.

Bible verses collected, and sorted by books, chapters and verses, in a Biblical order in LibreOffice calc. To sort a col

2018-08-28 17:56:21 +0200 edited question Bible verses collected, and sorted by books, chapters and verses, in a Biblical order in LibreOffice calc.

Bible verses collected, and sorted by books, chapters and verses, in a Biblical order in LibreOffice calc. To sort a col

2018-08-08 18:27:09 +0200 commented answer Is there a way to enter numbers with suffixes?

I "edited" my answers! Now my "upfile" is blue. I didn't notice it didn't work. I am doing something wrong, but not sure

2018-08-08 18:26:45 +0200 edited answer Is there a way to enter numbers with suffixes?

This works, at least to cells having a text after a #, like 1gb, 1.1gb, 1.11gb mm, sm, Bytes, or whatever!? No macro's j

2018-08-08 14:34:20 +0200 commented answer Is there a way to enter numbers with suffixes?

I "edited" my answers! Now my "upfile" is blue. I didn't notice it didn't work. I am doing something wrong, but not sure

2018-08-08 14:27:09 +0200 commented answer Is there a way to enter numbers with suffixes?

I "edited" my answers! Now my "upfile" is blue. I didn't notice it didn't work. I am doing something wrong, but not sure

2018-08-08 14:07:35 +0200 commented answer Is there a way to enter numbers with suffixes?

I "edited" my answers! Now my "upfile" is blue. I didn't notice it didn't work. I am doing something wrong, but not sure

2018-08-08 14:04:53 +0200 edited answer Is there a way to enter numbers with suffixes?

This works, at least to cell having a text after a #, like 1gb, 1.1gb, 1.11gb, 1.1 gb 1 gg !? No macro's just formulas.

2018-08-08 14:02:23 +0200 commented answer Is there a way to enter numbers with suffixes?

It's a file I created, I think I posted it earlier with URL to it, http://bit.ly/2Dl8tFK, but today I made it so a hundr

2018-08-08 13:42:21 +0200 edited answer Is there a way to enter numbers with suffixes?

This works, at least to cell having a text after a #, like 1gb, 1.1gb, 1.11gb, 1.1 gb 1 gg !? No macro's just formulas.

2018-08-08 12:28:56 +0200 answered a question Is there a way to enter numbers with suffixes?

This works, at least to cell having a text after a #, like 1gb, 1.1gb, 1.11gb, 1.1 gb 1 gg !? No macro's just formulas.

2018-07-23 12:25:34 +0200 commented question Have you seen that someone sells LibreOffice on the Microsoft Store?

Thanks @gabix! I didn't know I could do that. And yes, it is more so a comment.

2018-07-23 11:43:53 +0200 commented answer Have you seen that someone sells LibreOffice on the Microsoft Store?

Thanks @Mike Kaganski. I meant to say Years, about 15! Not till my XP was not supported and I found Linux Lite to replac

2018-07-23 02:28:03 +0200 answered a question Have you seen that someone sells LibreOffice on the Microsoft Store?

Not good! But maybe many will see it and try it. I used M. S. Office for year! I never knew another option was out there

2018-07-22 12:40:35 +0200 answered a question my laptop was shut down before I closed a document I had started. Even though it was being automatically saved in progress, I now can't find the file. Any suggestions?

@Hazlbev I would open LibreOffice first, as @MIKE mentioned, that should find it and open it, but if not, the path to us

2018-07-21 12:51:32 +0200 answered a question Save directory not sorted:

Just above the names, is a small arrow, light gray in color. click it.