### [libreoffice-users] Re: Calc a formula conundrum

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

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

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

)),"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

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

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 ?

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 ?

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 ?

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 ?

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 ?

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

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

://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

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

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

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

' 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

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

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

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

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

- 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

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

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

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

?? 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

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

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

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

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

(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

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

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

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

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

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

=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

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

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

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

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

- 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

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 ?

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 ?

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