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
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
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
?? 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
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
=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
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
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
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
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
(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
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
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
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
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
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
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
-
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
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
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
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 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 ?
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
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
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
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
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
-
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
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
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
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
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
' 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
://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
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
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
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
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
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
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
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
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
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
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
)),"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
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
46 matches
Mail list logo