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


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

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.