Who is a smart bear????

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!