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


Hi :)
I think you give good answers.  We can't always solve everyone's
questions.  Hopefully we do push enough of them in the right direction but
it is not always possible.

There are other places people can use to try to find answers too.  Also we
are not just about giving answers but are also about showing people that
this is a comfortable place to "mull over issues" and to maybe pick up some
new ways of thinking.  Those new ways might help people with other
problems.

Sometimes problems only get solved when several people ask because it takes
time for us to learn how to cope with something new.  Sometimes the
functionality is not there yet so we push for new features.  Sometimes it's
something that is not widely known about so we all learn.

So, don't worry when you can't help a person directly.  Just trying to help
shows them that they are not alone and that can be a huge help.

Good work!  Much appreciated :)
Regards from
Tom :)



On 26 July 2014 19:00, jorge <jrodriguez17@cpcecr.com> wrote:

Hi:

        I'm sorry for you but LO is quite different to excel not all that
you
can do in LO you can do in excel and invece ... They usually do almost
all but in different way...sometimes one or other improve process that
the other doesn't do by different issues. Is like a car, if you change a
car you can't expect its perfomance is equal to other car.

        I tried to give you a way to solve your problem using LO Car !

Regards,

Jorge Rodriguez




El sáb, 26-07-2014 a las 17:00 +0200, Rob Jasper escribió:
In  MS Excel one can select a full column by just leaving off the
rownumber, example: MAX(B:B).
If I open the .xls file with LibreOffice this formula gets translated in
MAX(B$1:B$983040)

Tried to enter the original formal but that responds #NAME?.
Apparently LibreOffice does not have the functionality.

Rob.


Op 23 jul. 2014, om 16:39 heeft jorge het volgende geschreven:

Hi:

I could suggest you to select a greatter range than you are going to
use
at the begining. For example. Imagine you need make a chart with the
information of all the months of the year but at this moment you have
only seven mounth, like this:

Row A       B

1   J       10
2   F       20
3   M       30
4   A       40
5   My      40
6   J       50
7   Jy      60

But you expect five additional months:

Row A       B

8   A       ? (Keep in blank)
9   S       ? (Keep in blank)
10  O       ? (Keep in blank)
11  N       ? (Keep in blank)
12  D       ? (Keep in blank)

When you select the initial range you can select:

A1:B12 as complete series

In this case the chart only show elements graphics for months that have
numbers...the others only by referens...but if you dont want show these
in the chart you can hide its part of range-rows-(Partial or Total),
and
the chart adjusts automatically its range.

I hope this help you to make your chart better and easier,

Regards,

Jorge Rodríguez


El mié, 23-07-2014 a las 10:48 +0100, Gordon Burgess-Parker escribió:
Hi!
I'm trying to create a chart where when I add data I don't have to
edit
the data range each time to include the new row.
I can't see how to do that. (Probably something I've missed).
Can anyone help?

Ta!




--
Atentamente,

Jorge Rodríguez


--
To unsubscribe e-mail to: users+unsubscribe@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


--
Atentamente,

Jorge Rodríguez


--
To unsubscribe e-mail to: users+unsubscribe@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


-- 
To unsubscribe e-mail to: users+unsubscribe@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

Context


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.