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. 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)