Date: prev next · Thread: first prev next last
2014 Archives by date, by thread · List index

Thank you for your advise. 

Yes, I'll guess I'll have to do that, redefine the ranges to (a little more
then) the needed range, then it should probably work. I just wish I had
tested this sooner. 

And the reason why I wanted to do this is simple; when you have a sheet like
this: the easiest way to insert new data 'C'  inbetween column B and D is
inserting a new column rather then cut-pasting everything to the right - and
usually the savest way, but not this time. 
And I'd named the entire rows because when you have more then one screen of
data, it is the easiest way to just click the row header (A) and define the
name in the Name-box on the left top. 
None of the tutorials I used warned against the problem that when inserting,
it would drop the (unused) excells allright, but not move the formula along. 


View this message in context:
Sent from the Users mailing list archive at

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.