[off-topic] Spreadsheet question

[Jim Householder]

Sorry about the lack of details.  I'm powered by off-grid solar, and I 
use OpenOffice.org to keep a daily record of power used and the minimum 
State of Charge on the batteries.  I keep track of minimum SOC and KWh 
daily, and for each month the averages and total KWh.

The find and replace works nicely, but a bit tedious.  For each of the 
10 columns referenced I replaced =<col> with =Sheet1.<col> without 
worrying about row numbers.  I tried replacing "=" with "=Sheet." but it 
did not like that.  Said it could not find the search string.

Thanks
Jim


On 03/12/12 19:00, Dion wrote:
> Hi,
>
> Nice idea. It may be handy to know which spreadsheet application you're
> using.
>
> In Libre Office and probably OpenOffice too, just highlight the block of
> cells you want to change and then do a find and replace. Replace
> cellnumber with sheetname.cellnumber eg "A7" with "Sheet2.A7"
>
> For many references, I don't know if it can do a regular expression. It
> depends on the complexity of your spreadsheet whether this is worth
> exploring.
>
> Regards,
> D.
>
> On 12/03/12 3:23 AM, Jim Householder wrote:
>> Hi
>>
>> I'm keeping a daily record of my power usage in a spreadsheet. After I
>> set it up, I decided I wanted a summary by month. Now the area for the
>> summary is getting tight. I would like to move it to a second sheet.
>>
>> Is there a simple way to move an 8 x 46 block of cells, each of which
>> has a reference to a single cell, to a second sheet without manually
>> adjusting every cell?
>>
>> TIA
>> Jim
>> _______________________________________________
>> Off-topic mailing list
>> Off-topic at plug.org.au
>> http://lists.plug.org.au/mailman/listinfo/off-topic
>
>