My fav quote from Yogi bear --- "I am a smart bear - sometimes I am so smart - it hurts" next minute he's flat on his face from his picnic basket robbing days - rubbing a sore spot on his head!!
or like this
“I’m so smart it hurts.”
“It’s because I’m smarter than the average bear.”
yogi bear hunting picnic baskets
humpf - well - the other day I did feel rather silly
I used to be able to do this:
In LibreOffice - you used to be able to select a range of cells (some empty some not) and copy them - then select another spreadsheet or file and do a Paste/Link!! Meaning that when you update or fill a cell at the source - it would update and accurately reflect that change made in the destination cell's.
Well for some reason LibreOffice would no longer copy EMPTY Cells.
In MS Excel and Lotus123 (yes remember that good software???) it does copy empty cells! sooo hmmmmm
Research says you ought to be able to do this in Libreoffice - so there is either a bug or some software program no longer providing the function!
WHAT to DO?????
After a lot of trial and head scratching -- I found a work around!!
Select any single empty cell - click in it - push the space bar once and hit enter! This will in effect add an "indent" into the cell - and voila it is no longer empty - but showing nothing - since no text/data/formula etc has been entered into this cell yet! Now copy that cell and paste into your source spreadsheet as far and wide as you want / need too (or indeed the whole spreadsheet) and paste it.
Now you can select your few cells and copy them and do the paste link cmd ( seeing it will recognize the cells now, seeing they are no longer "empty" and of course any future data entered in the source cell will be reflected in the destination cells!!)
YUSSSSS
Where is my picnic basket with Nutella sandwich's !!
Have fun!
