[libreoffice-users] Re: Calc a formula conundrum

2016-11-09 Thread IGraham
never seen the 'SUBSTITUTE' function before, going to be fun working out whats going on, i can feel a headache coming on already again thanks - IGraham W1064 LibreOffice 5.1.6.2 -- View this message in context: http://nabble.documentfoundation.org/Calc-a-formula-conundrum-tp4199203p4199622

[libreoffice-users] Re: Calc a formula conundrum

2016-11-04 Thread IGraham
Thank, a couple of things to experiment with, but thats going to have to wait till tomorrow, i shall report results eventually - IGraham W1064 LibreOffice 5.1.6.2 -- View this message in context: http://nabble.documentfoundation.org/Calc-a-formula-conundrum-tp4199203p4199232.html Sent

[libreoffice-users] Re: Calc a formula conundrum

2016-11-04 Thread IGraham
BANK_STATEMENT.ods <http://nabble.documentfoundation.org/file/n4199204/BANK_STATEMENT.ods> the attachment didn't seem to upload so trying again - IGraham W764 LibreOffice 4.4.2.2 -- View this message in context: http://nabble.documentfoundation.org/Calc-a-formula-con

[libreoffice-users] Calc a formula conundrum

2016-11-04 Thread IGraham
)),"MORRISON",IF(ISNUMBER(FIND("ALDI",I5)),"ALDI",IF(ISNUMBER(FIND("HERON",I5)),"HERO BANK_STATEMENT.ods <http://nabble.documentfoundation.org/file/n4199203/BANK_STATEMENT.ods> N","NO" - IGraham W764 LibreOffice 4.4

[libreoffice-users] Calc. Convert date DD to number

2015-08-01 Thread IGraham
Hello Looking for an easy way to from a date (say) 03/05/2015 get just the day value as a number value not a date value, would like to have just '3' but '31' would do Do know of =Text(cell,DD) but text is not directly number - IGraham W764 LibreOffice 4.4.2.2 -- View this message

[libreoffice-users] Re: Calc. Convert date DD to number

2015-08-01 Thread IGraham
Thanks for the working reply knew there was a simple way just couldn't remember it, even though I'd used it before - senility is lurking - IGraham W764 LibreOffice 4.4.2.2 -- View this message in context: http://nabble.documentfoundation.org/Calc-Convert-date-DD-to-number

[libreoffice-users] Re: Base, connect to map/grid ?

2015-05-18 Thread IGraham
to have something integrated but such is life. Thanks for the help - IGraham W764 LibreOffice 4.4.1.2 -- View this message in context: http://nabble.documentfoundation.org/Base-connect-to-map-grid-tp4148544p4148823.html Sent from the Users mailing list archive at Nabble.com

[libreoffice-users] Base, connect to map/grid ?

2015-05-13 Thread IGraham
I haven’t found it. So is it possible to connect a database to a map/grid/whatever to do what I want Any thoughts help appreciated - IGraham W764 LibreOffice 4.4.1.2 -- View this message in context: http://nabble.documentfoundation.org/Base-connect-to-map-grid-tp4148544.html Sent from

[libreoffice-users] Re: Calc, selecting from a list ? vlookup maybe ?

2015-03-24 Thread IGraham
thanks - IGraham W764 LibreOffice 4.4.1.2 -- View this message in context: http://nabble.documentfoundation.org/Calc-selecting-from-a-list-vlookup-maybe-tp4144307p4144387.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr

[libreoffice-users] Re: Calc, selecting from a list ? vlookup maybe ?

2015-03-24 Thread IGraham
thanks Rob you obviously worked out the upload file routine - IGraham W764 LibreOffice 4.4.1.2 -- View this message in context: http://nabble.documentfoundation.org/Calc-selecting-from-a-list-vlookup-maybe-tp4144307p4144388.html Sent from the Users mailing list archive at Nabble.com

[libreoffice-users] Calc, selecting from a list ? vlookup maybe ?

2015-03-24 Thread IGraham
row below has different membership type and associated data I want new lists based on the membership type The main list may be sorted changing the order of the rows Anyone know how i can do this test1.ods http://nabble.documentfoundation.org/file/n4144307/test1.ods - IGraham W764

[libreoffice-users] Re: Calc, =left not working as expected

2014-09-02 Thread IGraham
Thanks for the replys people The 'VALUE' convert to number worked - i really should have remembered that, memory is getting worse - IGraham W764 LibreOffice 4.2.0.4 -- View this message in context: http://nabble.documentfoundation.org/Calc-left-not-working-as-expected-tp4120882p4121011

[libreoffice-users] Calc, =left not working as expected

2014-08-31 Thread IGraham
://nabble.documentfoundation.org/file/n4120882/left_test.ods - IGraham W764 LibreOffice 4.2.0.4 -- View this message in context: http://nabble.documentfoundation.org/Calc-left-not-working-as-expected-tp4120882.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail

[libreoffice-users] Calc - Auto fill stepped cell reference

2014-07-26 Thread IGraham
A16 A24 A32 A40 etc I've got a few columns needing the same stepped cell reference and this could save me some time - IGraham W764 LibreOffice 4.2.0.4 -- View this message in context: http://nabble.documentfoundation.org/Calc-Auto-fill-stepped-cell-reference-tp4116789.html Sent from

[libreoffice-users] Re: Calc - Auto fill stepped cell reference

2014-07-26 Thread IGraham
Hello Pedro thanks for the reply Slight edit to my original post I missed out the = I'd tried the Edit, Fill, Series thing and couldn't get it to work, its ok with just numbers but including the stuff in front stops it from working - IGraham W764 LibreOffice 4.2.0.4 -- View

[libreoffice-users] Re: Calc - Auto fill stepped cell reference

2014-07-26 Thread IGraham
learning - IGraham W764 LibreOffice 4.2.0.4 -- View this message in context: http://nabble.documentfoundation.org/Calc-Auto-fill-stepped-cell-reference-tp4116789p4116814.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr

[libreoffice-users] Re: Calc - Auto fill stepped cell reference

2014-07-26 Thread IGraham
' the first value in the column, that copies down nicely and the 8 16 24 32 etc is reusable thanks for pointing me in the right direction - IGraham W764 LibreOffice 4.2.0.4 -- View this message in context: http://nabble.documentfoundation.org/Calc-Auto-fill-stepped-cell-reference

[libreoffice-users] Re: Calc - sort in to columns

2014-02-21 Thread IGraham
will be the easiest to maintain and for the users to use. I'm still toying with the database idea, but in truth that would be more to satisfy my own urge to relearn and tinker. Thanks for looking at it - IGraham W764 LibreOffice 4.2.0.4 -- View this message in context: http

[libreoffice-users] Re: Calc - sort in to columns

2014-02-20 Thread IGraham
of it. If you have any other solutions/thoughts I'd be grateful (theres shed loads of spreadsheet stuff (I know) I don't know) - IGraham W764 LibreOffice 4.2.0.4 -- View this message in context: http://nabble.documentfoundation.org/Calc-sort-in-to-columns-tp4098035p4098086.html Sent from the Users

[libreoffice-users] Calc - sort in to columns

2014-02-19 Thread IGraham
garbled explanation - hope it makes sense anyway Thanks for any solutions test2.ods http://nabble.documentfoundation.org/file/n4098035/test2.ods - IGraham W764 LibreOffice 4.1.42 -- View this message in context: http://nabble.documentfoundation.org/Calc-sort-in-to-columns-tp4098035.html

[libreoffice-users] Calc, paste special, transpose and link

2014-01-01 Thread IGraham
all, transpose, link (all selections then go grey) Click ok and the cells are pasted vertical *not horizontal* as required I've done it before ?? But I'm doing a bit of head scratching now Can anyone help - IGraham W764 LibreOffice 4.1.0.4 -- View this message in context: http

[libreoffice-users] Re: Calc, paste special, transpose and link

2014-01-01 Thread IGraham
- IGraham W764 LibreOffice 4.1.0.4 -- View this message in context: http://nabble.documentfoundation.org/Calc-paste-special-transpose-and-link-tp4090407p4090468.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org

[libreoffice-users] Calc - Pasting links relative to a folder

2013-09-13 Thread IGraham
to paste the data from the two year spreadsheets into the combine spreadsheet but have the links relative to the folder all three sheets are within - not relative to the actual storage system (in this case a NAS) - IGraham W764 LibreOffice 4.1.0.4 -- View this message in context: http

[libreoffice-users] Calk - lookup cell in column

2013-09-13 Thread IGraham
that if I know how to do it for say January then I can do it for any month. I'm totally clueless as to how to do this /Hopping that my explanation isn't to bamboozling/ Any ideas - please - IGraham W764 LibreOffice 4.1.0.4 -- View this message in context: http

[libreoffice-users] Re: Calk - lookup cell in column

2013-09-13 Thread IGraham
Calc not Calk - dam that spell checker - - can we agree to blame the spell checker vlookup thanks for pointing me at that does exactly what i wanted - though it did kill a few grey cells getting it to work now i can happily move on to the next problem - IGraham W764 LibreOffice

[libreoffice-users] Re: Calc =MONTH problem

2013-08-20 Thread IGraham
?? Maybe I should have just for the 'smidgen more' Again, thanks for the help - IGraham W764 LibreOffice 4.1.0.4 -- View this message in context: http://nabble.documentfoundation.org/Calc-MONTH-problem-tp4070686p4070715.html Sent from the Users mailing list archive at Nabble.com

[libreoffice-users] Calc =MONTH problem

2013-08-19 Thread IGraham
01/09/2013 which is DD/MM/ In another cell I have =MONTH(CF3) this cell is formatted as 'date' 'MMM' and I expect the cell to show 'Sep' it actually shows 'Jan' So its showing the day as the month and not the month as the month Any ideas how to fix - IGraham W764 LibreOffice 4.1.0.4

[libreoffice-users] Re: Calc sheet name

2013-05-08 Thread IGraham
Hello and thanks for the reply Yes that was what i was asking - shame about the negative answer :( But apparently it can be done with a macro - i'll have a go at that - IGraham W764 LibreOffice 3.6.2.2 -- View this message in context: http://nabble.documentfoundation.org/Calc-sheet-name

[libreoffice-users] Calc sheet name

2013-05-06 Thread IGraham
that ? Is it possible ? Thanks for any help you can give - IGraham W764 LibreOffice 3.6.2.2 -- View this message in context: http://nabble.documentfoundation.org/Calc-sheet-name-tp4054043.html Sent from the Users mailing list archive at Nabble.com. -- To unsubscribe e-mail to: users+unsubscr

[libreoffice-users] Re: Writer: remove/merge pages

2013-01-17 Thread IGraham
showed as panels Thanks all, help was appreciated - IGraham W764 LibreOffice 3.6.2.2 -- View this message in context: http://nabble.documentfoundation.org/Writer-remove-merge-pages-tp4028644p4029835.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions

[libreoffice-users] Writer: remove/merge pages

2013-01-12 Thread IGraham
(crashers), if so any good practices to avoid the resulting aggravation - IGraham W764 LibreOffice 3.6.2.2 -- View this message in context: http://nabble.documentfoundation.org/Writer-remove-merge-pages-tp4028644.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe

[libreoffice-users] Re: Writer: remove/merge pages

2013-01-12 Thread IGraham
report back on the lack of crashers latter (fingers crossed) - IGraham W764 LibreOffice 3.6.2.2 -- View this message in context: http://nabble.documentfoundation.org/Writer-remove-merge-pages-tp4028644p4028690.html Sent from the Users mailing list archive at Nabble.com

[libreoffice-users] Conditional formatting

2012-11-07 Thread IGraham
have deleted my user profile and let it recreate but that didn't fix looks like I'll have to install the previous version Unless anyone has any ideas how to fix - IGraham W764 LibreOffice 3.6.2.2 -- View this message in context: http://nabble.documentfoundation.org/Conditional-formatting

[libreoffice-users] Re: Conditional formatting

2012-11-07 Thread IGraham
Thanks for the reply 'but' umm I forgot to change my sig/version - must in future remember to include such details I am using 3.6.3.2 and this is the version that has introduced the Conditional formatting bug - IGraham W764 LibreOffice 3.6.3.2 -- View this message in context

[libreoffice-users] Re: Calc question - paste special

2012-10-10 Thread IGraham
needs to reflect one data type and a 'dot' will do) so using =if(len(a1)0,.,) works (notice the .), however again all formatting is lost Thanks for the help but the best results are achieved by a daily copy and paste - IGraham W764 LibreOffice 3.6.2.2 -- View this message in context: http

[libreoffice-users] Calc question - paste special

2012-10-09 Thread IGraham
for any help - IGraham W764 LibreOffice 3.5.2.2 -- View this message in context: http://nabble.documentfoundation.org/Calc-question-paste-special-tp4012272.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h

[libreoffice-users] Re: calc - message in cell

2012-09-10 Thread IGraham
=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml - IGraham W764 LibreOffice 3.5.2.2 -- View this message in context: http://nabble.documentfoundation.org/calc-message-in-cell-tp4006357p4006653.html Sent from the Users

[libreoffice-users] calc - message in cell

2012-09-09 Thread IGraham
Calc How do i (can i) place in a cell a message - that isn't part of the active spreadsheet I want to tell the user the data type they should be entering as 'date type 01/01/2012' and that the message will disappears as the user starts typing Thanks for any help - IGraham W764 LibreOffice

[libreoffice-users] Formula Bar size

2012-04-09 Thread IGraham
Hello Calc My eyes aren't quite as good as they once were so in Toolsoptionsview I've increased 'scaling' to 130% - I can now see my formulas with out trouble However the Formula Bar itself hasn't increased heigh to accommodate the scaled content and the bottom of the content drops under the

[libreoffice-users] Re: Formula Bar size

2012-04-09 Thread IGraham
was thinking that being able to tweak the interface was a long-shot but - if you don't ask Might try the OS option though - IGraham W764 LibreOffice 3.5.2.2 -- View this message in context: http://nabble.documentfoundation.org/Formula-Bar-size-tp3896265p3896947.html Sent from the Users

[libreoffice-users] Conditional Formatting columns

2012-04-09 Thread IGraham
formula I'm using COLUMN()-COLUMN($'DH April'.$E$10)=$'DH April'.$W$7 Its not doing as I expected, its colouring the columns/area not from the first column but from the first column plus whatever the number is Any ideas on how to get this working - IGraham W764 LibreOffice 3.5.2.2 -- View

[libreoffice-users] Re: Conditional Formatting columns

2012-04-09 Thread IGraham
- IGraham W764 LibreOffice 3.5.2.2 -- View this message in context: http://nabble.documentfoundation.org/Conditional-Formatting-columns-tp3896993p3897740.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org

[libreoffice-users] Re: Conditional Formatting columns

2012-04-09 Thread IGraham
Thanks, both methods work Miguel - now why didn't i see that Brian - had no idea it could be reduced so much thanks people - IGraham W764 LibreOffice 3.5.2.2 -- View this message in context: http://nabble.documentfoundation.org/Conditional-Formatting-columns-tp3896993p3898033.html Sent

[libreoffice-users] Base - Phone book ?

2012-02-14 Thread IGraham
Base its been quite a few years since I've perplexed myself with a database, but needs must i want to print my Thunderbird address book, (the phone numbers mainly) i can do this from within Thunderbird but i cant choose the fields or set up the display so the output is hardly user friendly using

[libreoffice-users] Re: Base - Phone book ?

2012-02-14 Thread IGraham
far be it for me to distract from a good developing 'discussion' ;) thanks for the input people the calc option, as much as i like a good spreadsheet i don't really think its going to produce a booklet type phone number book without a good deal of tweaking and as has been pointed out calk wont

[libreoffice-users] calc column headers

2011-10-16 Thread IGraham
LibreOffice 3.4.3 , W7 64x, Calc Calc the column headers - A B C etc are acting strange, sometimes their not there, sometimes some of them are there, if they are there they overlay Row one, and they randomly appear/disappear as sheets are clicked on or changed. I'm assuming this is a bug but ?

[libreoffice-users] Re: calc column headers

2011-10-16 Thread IGraham
Thanks for the response - and to Brian who emailed me After a bit more investigation I'm (fingers crossed) convinced its to do with a corrupted spreadsheet rather than a failure within Libreoffice. The broken up column header was only happening with one spreadsheet, the spreadsheet was saved as