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