Re: Recommended program version for old and slow computers, netbooks, based on winXP

[Alan B]

On Thu, Oct 15, 2015 at 2:00 PM, Jim McLaughlin 
wrote:

> Alan, thank you for the tip.
>
> I use 4.1.1 on an old Dell Latitude D600, running XP.  I have 2 gigs of
> memory installed (board maximum). The CPU is a now ancient Pentium, 1600
> Mhz.
>
> It takes a  LONG time to boot up.
>

Hello again Jim... just wanted to get back to you on this. My experience
has been that on any given system the Linux distribution that I've tried
has always been faster than Windows on the same system. If you want better
performance without new hardware I suggest trying Linux.

You can test if it gives better performance without making a commitment to
a permanent switch. There are at least two ways to do this:
1. if your pc will boot from USB create a bootable USB and try it that way
2. dual boot (choose whether to boot Windows or Linux each time the pc
starts)

Option 1 is the least disruptive as it makes no changes to the hard drive
and provides fairly good performance
Option 2 is more flexible and has the best performance. Best performance
because works at hard drive speed. More flexible because is easy to
customize add/remove programs from the Linux install.

If you'd like more information feel free to contact me off list. I'd be
glad to share more of my Linux experiences. For me it was a gradual
transition. Used only Windows for a long time. Then mostly Windows and a
little Linux. Then the reverse. And now mostly Linux with occasional
Windows.

You can try it without making an irreversible decision.

-Alan

Just two simple questions

[cjm1819]

1. want do I type to get a total of highlighted cells?

2. what  do I type to get the total (multiple) of two highlighted cells? 


Cliff

cjm1...@sbcglobal.net

734 665 4986

Re: Just two simple questions

[Brian Barker]

At 14:01 18/10/2015 -0400, Cliff Monly wrote:

Just two simple questions


These may be a little too simple ...


1. what do I type to get a total of highlighted cells?


I'm guessing that you mean spreadsheet cells, not table cells in a 
text document? And by "total" you mean the sum of their values, not 
the total number of cells? And by  "highlighted", you mean selected 
cells - not either having a background colour, or formatted to show, 
say, negative numbers highlighted in a different colour, or 
highlighted differently by View | Value Highlighting?


I don't think spreadsheets work in the way that you expect. Any 
formula you enter has to be entered in cell, and if you had cells 
already selected, the formula would overwrite one of them. If you 
created the formula first and selected multiple cells afterwards, you 
would still be expecting OpenOffice to recalculate formulae every 
time you made a  selection or modified one. Spreadsheets don't do that.


There are ways that you can achieve something like what you seem to need:

o You can construct a formula - probably including the IF() function 
- which will calculate the sum of the relevant cells based on some 
criterion, without the need to select the cells to identify them.


o You can filter a column of values so as to hide some rows and leave 
only the relevant rows. Note that the SUM() function will not help 
here, as it will still include values in the hidden rows; but you can 
use the SUBTOTAL() function with 9 as its first argument to sum only 
those values that are in rows that are not hidden.



2. what do I type to get the total (multiple) of two highlighted cells?


Sorry, but I don't know what a "multiple total" is. If this question 
is not the same as the first one, then I don't understand it. Do you 
perhaps here mean the sum of values but in the first question you 
meant the count of the values? In that case, the solutions are 
similar; the equivalent to the COUNT() function that omits values in 
hidden rows is SUBTOTAL(2;...).


I trust this helps.

Brian Barker


-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org