Ask Your Question

Windcheetah's profile - activity

2019-10-12 19:51:52 +0100 received badge  Famous Question (source)
2019-10-11 17:38:47 +0100 edited question Too Many Days in Month when less than 31 (Solved)

Too Many Days in Month when less than 31 Hi, I'm trying to create a planner for a number of months. They are down the le

2019-10-11 17:37:37 +0100 commented answer Too Many Days in Month when less than 31 (Solved)

Thanks for the info, I hope I've corrected my errors

2019-10-11 17:36:32 +0100 commented answer Too Many Days in Month when less than 31 (Solved)

Wonderful, I'm sorry about messing up the forum.

2019-10-11 17:34:33 +0100 edited answer Too Many Days in Month when less than 31 (Solved)

I have removed the answer that was here, as mistakenly thought it was the place for what I thought the best answer was.

2019-10-08 01:57:46 +0100 received badge  Notable Question (source)
2019-10-07 20:06:49 +0100 received badge  Popular Question (source)
2019-10-07 19:14:05 +0100 commented answer Too Many Days in Month when less than 31 (Solved)

Sorry, I thought this is where I put what I consider the best answer.

2019-10-07 19:13:07 +0100 marked best answer Too Many Days in Month when less than 31 (Solved)

Hi, I'm trying to create a planner for a number of months. They are down the left hand side, with the days across the top. As the number of days in the month change, the days across the top can extend for too long, as there are 31 columns in the sheet.

If that is not clear, please leave a reply, and I will try and explain again.

The attached file shows the problem that I'm trying to solve.

C:\fakepath\YearPlanner.ods

Thanks loads

Martin

2019-10-07 19:00:11 +0100 received badge  Organizer (source)
2019-10-07 18:57:34 +0100 commented answer Too Many Days in Month when less than 31 (Solved)

No problem, thanks for your help Martin

2019-10-07 18:56:18 +0100 answered a question Too Many Days in Month when less than 31 (Solved)

=IF(AND(B1<>"";DAY(B1+1)>DAY(B1));B1+1;"") Is it spot on!!!

2019-10-07 18:46:09 +0100 commented answer Too Many Days in Month when less than 31 (Solved)

Hi, thanks loads, at an initial look, it looks topps!!!! Could you possibly send a link as to where gives you a hint as

2019-10-07 18:02:39 +0100 asked a question Too Many Days in Month when less than 31 (Solved)

Too Many Days in Month when less than 31 Hi, I'm trying to create a planner for a number of months. They are down the le

2014-07-27 13:29:15 +0100 received badge  Famous Question (source)
2014-07-13 15:41:22 +0100 received badge  Supporter (source)
2014-07-13 15:35:25 +0100 commented answer Why can't I copy or move a sheet within a spreadsheet document?

Thanks loads, A WINNER I don't remember setting it to record, but I must have done at some stage, in an effort to fix the problem.

Thanks loads Martin

2014-07-13 15:33:36 +0100 commented question Why can't I copy or move a sheet within a spreadsheet document?

No, I'm afraid not, but I now have the answer. Please see below. Martin

2014-07-13 15:25:14 +0100 received badge  Notable Question (source)
2014-07-13 14:14:59 +0100 commented question Why can't I copy or move a sheet within a spreadsheet document?

Thanks, it is NOT a read-only document. It would appear to be a problem with some thing that I've done to the document, as I can move on a new ods doc. I did create the the doc in LibreOffice so not an inport/conversion issue, and as far as I can tell, it is not protected. Yes I can alter cells and it is on my local computer. Thanks Martin

2014-07-13 09:57:25 +0100 received badge  Popular Question (source)
2014-07-12 19:39:02 +0100 asked a question Why can't I copy or move a sheet within a spreadsheet document?

Hi, I'm using Version: 4.2.4.2 Build ID: 420m0(Build:2) in the English(UK) language and the sheet component. I use ubuntu 64 bit O/S with the XFCE front end.

I am unable to move or copy a sheet within a document. I do not know about to a new document, as I feel this will be a little beoynd my simple usage.

I can select a sheet, e.g. the current sheet in the document, then when I go to Edit/Sheet, Move/Copy and Delete are not selectable, only Select and Events are enabled.

Can anyone let me know what I'm doing wrong??

Thanks loads Martin

2014-02-19 22:35:59 +0100 received badge  Famous Question (source)
2013-11-12 22:40:05 +0100 received badge  Self-Learner (source)
2013-11-12 22:40:05 +0100 received badge  Teacher (source)
2013-10-29 22:36:28 +0100 received badge  Notable Question (source)
2013-10-21 13:25:03 +0100 received badge  Popular Question (source)
2013-10-21 12:32:53 +0100 answered a question Install on Mint from repository

Thanks loads, about to give a try Martin

Good that LO is back but after doing

sudo add-apt-repository ppa:libreoffice/libreoffice-4-0

sudo apt-get update

sudo apt-get dist-upgrade

sudo apt-get install libreoffice

the spelling check fails to find badly spelled words, and the dictionary is not full of junk

Martin

Update a few days later, all returned to working well Thanks

2013-10-20 22:34:34 +0100 asked a question Install on Mint from repository

Hi, can some one please let me know how the install from the repository???

I have tried many a time, but it has never been totally successful. I need all the parts of LO, along with the help and most importantly the spelling checker.

I prefer to use the apt command line or Synaptic package manager GUI

Thanks

Martin

2013-07-27 18:00:40 +0100 received badge  Popular Question (source)
2013-07-27 18:00:40 +0100 received badge  Notable Question (source)
2013-07-27 18:00:40 +0100 received badge  Famous Question (source)
2013-02-10 13:47:52 +0100 received badge  Scholar (source)
2013-02-10 13:47:08 +0100 commented question libobasis4.0-en-gb and Install Help

Having seen the most voted answer, I didn't realise that I had to install the language pack as well

2013-02-07 15:31:51 +0100 edited question libobasis4.0-en-gb and Install Help

Hi, I am a reasonably incompetent linux user, and I have just tried to upgrade to upgrade to Version 4.0.0.3 (Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89) to get the spelling to work.

The installation of LO went well and works, but I can't get the Help to install. This is what I get:

martin@martin-desktop ~/Computing/Martin/LibreOffice/4.0.0 LibreOffice_4.0.0.3_Linux_x86-64_deb_helppack_en-GB/DEBS $ sudo dpkg -i *.deb
[sudo] password for martin:
(Reading database ... 173962 files and directories currently installed.)
Preparing to replace libobasis4.0-en-gb-help 4.0.0.3-103 (using libobasis4.0-en-gb-help_4.0.0.3-103_amd64.deb) ...
Unpacking replacement libobasis4.0-en-gb-help ...
dpkg: dependency problems prevent configuration of libobasis4.0-en-gb-help: libobasis4.0-en-gb-help depends on libobasis4.0-en-gb; however: Package libobasis4.0-en-gb is not installed.
dpkg: error processing libobasis4.0-en-gb-help (--install):
dependency problems - leaving unconfigured
Errors were encountered while processing: libobasis4.0-en-gb-help

Can anyone please tell me what I've done wrong, and perhaps more importantly, how to put it right!!!

Thanks loads Martin

PS I am running Linux Mint 13 Maya

2013-02-07 15:31:51 +0100 received badge  Editor (source)