Re: [libreoffice-users] Is there an easy way to sum across a gap?

[Brian Barker]

At 18:19 15/02/2017 -0500, Robert Peirce wrote:
I have data in a table by month. At the end of each year there is a 
summary row separated by a blank line above and below. Frequently I 
need to sum from, say, 03/16-02/17 so I have 10 rows with data I 
want, three rows with data I don't want and two more rows with data 
I want. My approach has been something like this:


sum(A3:A12)+sum(A16:A17)


This is unnecessarily complicated. Use =SUM(A3:A12,A16:A17)

A13:A15 contain the data I don't want but I want to be able to see. 
This works but it is less than automatic. When I copy the formulae I 
need to edit them so they apply to the right rows.


I'm not sure why you are copying the formula. If you construct it 
properly - with $ signs in the right places - it ought to modify 
itself appropriately. But you can anyway form such a formula very 
simply: type "=SUM(", drag across A3:A12, type ",", drag across 
A16:A17, type ")", press Enter of click the green arrow.


Another thing is the rows summed aren't always the same. Sometimes I 
may need only two rows and other times maybe as many as 12.


There was I, thinking most years had twelve months! If you always 
have twelve rows for the months, your SUM() function will add zeros 
for any empty cells and still give the correct answer.


The solution to all this is very probably to design your spreadsheet 
to make the process of creating formulae easy. One obvious 
possibility would be to run your months sequentially, not breaking 
the lists for the annual sums. (After all, January follows December 
just as surely as December follows November.) Your sums could be in a 
new, adjacent column - perhaps next to the December values. Again, 
with appropriately constructed formulae, everything will copy 
seamlessly. Alternatively, you could have a separate table of annual 
sums in consecutive rows somewhere else on the spreadsheet.


I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Is there an easy way to sum across a gap?

[Remy Gauthier]

Hello,

Is there a way to identify the data you want? If so, you could use a
set of =SUMIF() or =SUMIFS() to add up the data that matches one or a
group of criteria. Otherwise, you may need to provide an example
(obviously scrubbed since it seems to be some financial data) because I
cannot quite picture what you are attempting to do.

I hope this helps.
Rémy Gauthier.
Le mercredi 15 février 2017 à 18:19 -0500, Robert Peirce a écrit :
> I have data in a table by month.  At the end of each year there is a 
> summary row separated by a blank line above and below.  Frequently I 
> > need to sum from, say, 03/16-02/17 so I have 10 rows with data I
want, 
> > three rows with data I don't want and two more rows with data I
want. 
> My approach has been something like this:
> 
> sum(A3:A12)+sum(A16:A17)
> 
> A13:A15 contain the data I don't want but I want to be able to see.
> 
> > This works but it is less than automatic.  When I copy the formulae
I 
> need to edit them so they apply to the right rows.
> 
> > Another thing is the rows summed aren't always the same.  Sometimes
I 
> may need only two rows and other times maybe as many as 12.
> 
> 

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Is there an easy way to sum across a gap?

[Robert Peirce]

I have data in a table by month.  At the end of each year there is a 
summary row separated by a blank line above and below.  Frequently I 
need to sum from, say, 03/16-02/17 so I have 10 rows with data I want, 
three rows with data I don't want and two more rows with data I want. 
My approach has been something like this:


sum(A3:A12)+sum(A16:A17)

A13:A15 contain the data I don't want but I want to be able to see.

This works but it is less than automatic.  When I copy the formulae I 
need to edit them so they apply to the right rows.


Another thing is the rows summed aren't always the same.  Sometimes I 
may need only two rows and other times maybe as many as 12.



--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: about libreoffice online which is introduced in version 5.3

[Robert Großkopf]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi anne-plogy,

Am 15.02.2017 um 16:34 schrieb anne-ology:
> yes.

It would be good if you will answer to mails with pressing the button
"answer to list".
When I open my Thunderbird today I could see three answers from you
which should be part of other threads and not standalones.

And another part I have learned in mailinglist: Don't produce TOFU
(Text Over Fullquote Under). Normal way should be: I read a question
and than the answer. I won't be interested for an answer like that
above, because I won't guess the content which it should belong for.

Regards

Robert
- -- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3
-BEGIN PGP SIGNATURE-
Version: GnuPG v2

iQIcBAEBAgAGBQJYpJv4AAoJELDKYwaoS9AI7GkQAIuaEMIq6JVhJ4/4QLDIMU6S
rKOWu5aWeuStFLXtIX4qNu+lWS+moE3DJVYalj+O60ioPUK5vTgvrwIa00b0f9W2
qk67p1mihwf/H7NX2JJJkJ0QAeju5g471TWniAvCVVNIpdtcEku13EFXfGc8viQX
chPmp8dj7szkgQm8TRG9a463F19ggoE68ngMTbdJmolBHNBtXINfvlhCSfpHCg9V
sCU/UkuIjrLWrBlCPSbeR+6tYm/0SHrZhEHoR6RkOMNN0GaLlLBJmaHCVIQo0gq+
Q4D1w80GJfdvyXyD5G8q/QYYrumhKTPDGhUCdZ3NvrBAFXCw2K6ZMONqcHHs0be+
o1ZZCB2p/Bu9DaFFtfaYrSSx0a8U+YVF5EtxZtmJeJPhzTR/S8oFS5is6jDztrUW
72/UNI5sM9WEgyVNF8gCJOlbpkO4LNBH+9V9zeBMuxdbhZSpOcseOeaOt/U7tHDi
2suDmqawzI5FBAae3c4V5p5WiVFab+izBJ6q7FCRy2SytekcWPeEovtdMbLHarkV
se0JrCSGESh1TqVIrMroKO6RPcynquak005k3oF8fgbPcBxWVbBY+FpgqlkJC0GP
s6v9ix7r4qlAkP8ZGbPm7x6O7Q7NXqkTR/Q5/ro9KXa4YZTV8GebBCabYQ9h5eM+
1f4+4UX3YeOPQKVrZ+GS
=WEhO
-END PGP SIGNATURE-

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: about libreoffice online which is introduced in version 5.3

[anne-ology]

   yes.




From: Tim---Kracked_P_P---webmaster 
Date: Wed, Feb 15, 2017 at 8:00 AM
Subject: Re: [libreoffice-users] Re: about libreoffice online which is
introduced in version 5.3
To: users@global.libreoffice.org


On 02/15/2017 07:37 AM, william drescher wrote:

> On 2/14/2017 5:20 PM, anne-ology wrote:
>
>>  what would you do if the power grid went out, leaving you with no
>> access to your data?
>>
>
> Summer:  I would mix a big gin and tonic and relax while contemplating
> what would happen to civilization.
> Winter: I would mix a big mulled wine and sit in front of the fireplace
> while contemplating what would happen to civilization.
>
> If you lost the entire power grid, working on a computer is the least of
> your problems.
>
> -bill
>
>
>
One of the big things that businesses need to look at is who can access and
"own" the data in the cloud. I have heard of several versions of the
answer[s] since the cloud started to be used to store data.  Your "power"
issue is a problem, but what happens if the cloud service gets bought out
by another company or if the service closes down.

Like any data,  you NEED to backup your data.  If the data is stored
online, I really think people/organization/business needs to make a backup
of the data that is stored in their home/office/building in some offline
method.  That way, if the service goes down for an extended period [hours
to days] there will be some access to the data.  If people not using the
cloud should/need to backup your data.  I have 6TB+ of data and it is
stored on USB drives. If you use a cloud service, you MUST know how the
data is backed up. How many times has a server, that LibreOffice uses,
needed "fixes" to keep the services going.  The "service is down" issues we
have had over the years has been annoying to the users, but gets fixed
quickly.  We have been lucky so far.

There has been some really weird "service agreement" language that aloud
the provider to read your data to make sure that the data is not of an
illegal nature.  Other seem to tell the user that since your data is on
their servers, then it belongs to the service provider in some way.  The
good service providers will encrypt data that is stored on their servers.
My problem with these services is that you need an expensive lawyer to
figure out the the "terms of service" agreement.

The worse case is that the service closes down for more than a day or two.
This can be due to weather and other "natural" issues that either takes
down the power lines for an extended period and/or the building that holds
the servers are severely damaged. This could be caused by fire, earth
quakes, or really bad storms. The news full of the natural disasters that
destroys the power lines, floods the community where the servers are
located, or even wild fires doing the same destruction.

I am not applying that the service provider could have any service issues,
but we need to think about the worse case.

This is my own opinion on these subjects, based on what I have seen - via
the news services -  and/or read about in the USA.  You alway need to think
about the worse case so if it happens, you will not lose you data and be
down for the shortest time possible.

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Upgrade loses fonts [UPDATE]

[anne-ology]

   There could be at least 2 options for you:
  (1) can you revert your machine to an earlier date, when the
previous version was?
 [just be sure to save anything which might be newer than
that date and/or back-up your system first]
  (2) the LO site should have these various versions to download
somewhere.




From: Rich Shepard 
Date: Tue, Feb 14, 2017 at 7:30 PM
Subject: Re: [libreoffice-users] Upgrade loses fonts [UPDATE]
To: users@global.libreoffice.org



I need to remove those and restore the fonts I regularly use, such as
> Baker Signet and Bitstream Amerigo.
>

  The problem is that my Slackware-14.1/32-bit wants version -5.1.4 and does
not support -5.3.0.

  Is there an older distribution archive site where I can download this
version?

Rich

-- 
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Re: about libreoffice online which is introduced in version 5.3

[Tim---Kracked_P_P---webmaster]

On 02/15/2017 07:37 AM, william drescher wrote:

On 2/14/2017 5:20 PM, anne-ology wrote:
 what would you do if the power grid went out, leaving you 
with no

access to your data?


Summer:  I would mix a big gin and tonic and relax while contemplating 
what would happen to civilization.
Winter: I would mix a big mulled wine and sit in front of the 
fireplace while contemplating what would happen to civilization.


If you lost the entire power grid, working on a computer is the least 
of your problems.


-bill


One of the big things that businesses need to look at is who can access 
and "own" the data in the cloud. I have heard of several versions of the 
answer[s] since the cloud started to be used to store data.  Your 
"power" issue is a problem, but what happens if the cloud service gets 
bought out by another company or if the service closes down.


Like any data,  you NEED to backup your data.  If the data is stored 
online, I really think people/organization/business needs to make a 
backup of the data that is stored in their home/office/building in some 
offline method.  That way, if the service goes down for an extended 
period [hours to days] there will be some access to the data.  If people 
not using the cloud should/need to backup your data.  I have 6TB+ of 
data and it is stored on USB drives. If you use a cloud service, you 
MUST know how the data is backed up. How many times has a server, that 
LibreOffice uses, needed "fixes" to keep the services going.  The 
"service is down" issues we have had over the years has been annoying to 
the users, but gets fixed quickly.  We have been lucky so far.


There has been some really weird "service agreement" language that aloud 
the provider to read your data to make sure that the data is not of an 
illegal nature.  Other seem to tell the user that since your data is on 
their servers, then it belongs to the service provider in some way.  The 
good service providers will encrypt data that is stored on their 
servers.  My problem with these services is that you need an expensive 
lawyer to figure out the the "terms of service" agreement.


The worse case is that the service closes down for more than a day or 
two.  This can be due to weather and other "natural" issues that either 
takes down the power lines for an extended period and/or the building 
that holds the servers are severely damaged. This could be caused by 
fire, earth quakes, or really bad storms. The news full of the natural 
disasters that destroys the power lines, floods the community where the 
servers are located, or even wild fires doing the same destruction.


I am not applying that the service provider could have any service 
issues, but we need to think about the worse case.


This is my own opinion on these subjects, based on what I have seen - 
via the news services -  and/or read about in the USA.  You alway need 
to think about the worse case so if it happens, you will not lose you 
data and be down for the shortest time possible.




--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Re: [libreoffice-users] Upgrade loses fonts [RESOLVED]

[Rich Shepard]

On Tue, 14 Feb 2017, Girvin Herr wrote:

I don't know where you got your Slackware package to install or if you 
created it yourself, as I do.  Or you installed the RPM directly.  I use 
SlackBuilds.org for my Slack packages.  Here is S14.1 LO 5.1.4:

https://www.slackbuilds.org/result/?search=libreoffice=14.1


Girvin,

  The link produces a 'Page not found' message as that old version is not
directly available from the LO web site.

  I found the archive of old versions. Downloaded and installed 5.1.4.2.
That restored the typefaces available.

  As time permits I'll incrementally upgrade versions to find the latest
that will run on 14.1.

Regards,

Rich

--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

[libreoffice-users] Re: about libreoffice online which is introduced in version 5.3

[william drescher]

On 2/14/2017 5:20 PM, anne-ology wrote:

 what would you do if the power grid went out, leaving you with no
access to your data?


Summer:  I would mix a big gin and tonic and relax while 
contemplating what would happen to civilization.
Winter: I would mix a big mulled wine and sit in front of the 
fireplace while contemplating what would happen to civilization.


If you lost the entire power grid, working on a computer is the 
least of your problems.


-bill


--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted