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: [email protected]
> > 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: [email protected]
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
