Re: [tdf-discuss] Looking for an easier way to do the following in a spreadsheet
2012/7/23 Johnny Rosenberg : > 2012/7/15 dave_ : >> By saving a spreadsheet as a csv file, I can import the values into another >> program (it creates labels and btw the program is designed for it printer >> only). The labels are "paired numbers" >> >> Let say I have a column labeled A-O (starting at cell a1 >> >> A B C D E F G H and so on (this is row 1) >> >> 1 1 2 2 3 3 4 4 5 5 and so on (this is row a2) >> 6 6 7 7 8 8 9 9 10 10 and so on (this is row a3) >> >> Cell A1 will be the starting input value and the rest will be generated >> >> a1= a1 b2=a2 c2=a2+1d2=a1+2e2=a1+2 f2=a1+3 and so on. >> (1) (1) (2) (3) (3) >> (4) >> >> Since column O makes the total columns number odd (15 colums) I cannot just >> "copy" the cells down. >> >> Any know an easier way of doing this. I am enclosing a sample file >> (hopefully anyway). :) >> >> Thanks ahead to all that helps. >> >> http://nabble.documentfoundation.org/file/n3995544/Double_Number_Series.ods >> Double_Number_Series.ods > > Here is my try: > B8=1 > C8=1 (why complicate things?) > D8=IF(B8=C8;C8+1;C8) > Fill D8 to R8. Yes, to R8, that is two columns more than the headers. This is only temporary, because the next step takes care of it. Just wanted to make sure this was not misunderstood, since this is ”the trick” in this case… Then, do ↓ > Select Q8:R8, drag them to B9:C9. These cells will then be the first > two cells on the next row. > Fill D8:P8 to D9:P9 to complete the row. > Now you have a complete row (B9:P9) that you can fill down as far as you want. > > Here is my version of your file: > http://ubuntuone.com/0azAbwhwtFk1UEMeG8e6z6 > > > Kind regards > > Johnny Rosenberg > ジョニー・ローゼンバーグ -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
Re: [tdf-discuss] Looking for an easier way to do the following in a spreadsheet
2012/7/15 dave_ : > By saving a spreadsheet as a csv file, I can import the values into another > program (it creates labels and btw the program is designed for it printer > only). The labels are "paired numbers" > > Let say I have a column labeled A-O (starting at cell a1 > > A B C D E F G H and so on (this is row 1) > > 1 1 2 2 3 3 4 4 5 5 and so on (this is row a2) > 6 6 7 7 8 8 9 9 10 10 and so on (this is row a3) > > Cell A1 will be the starting input value and the rest will be generated > > a1= a1 b2=a2 c2=a2+1d2=a1+2e2=a1+2 f2=a1+3 and so on. > (1) (1) (2) (3) (3) > (4) > > Since column O makes the total columns number odd (15 colums) I cannot just > "copy" the cells down. > > Any know an easier way of doing this. I am enclosing a sample file > (hopefully anyway). :) > > Thanks ahead to all that helps. > > http://nabble.documentfoundation.org/file/n3995544/Double_Number_Series.ods > Double_Number_Series.ods Here is my try: B8=1 C8=1 (why complicate things?) D8=IF(B8=C8;C8+1;C8) Fill D8 to R8. Select Q8:R8, drag them to B9:C9. These cells will then be the first two cells on the next row. Fill D8:P8 to D9:P9 to complete the row. Now you have a complete row (B9:P9) that you can fill down as far as you want. Here is my version of your file: http://ubuntuone.com/0azAbwhwtFk1UEMeG8e6z6 Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
[tdf-discuss] Re: Looking for an easier way to do the following in a spreadsheet
Why does the number of columns have to be odd? If you add one more column the problem is solved :) If there is an absolute reason that the number of columns MUST be odd, then all cells starting from the second row need to check if the previous two cells are equal. You can do this with an IF function. Then you can copy the second row to as many as you need. Hope this helps ;) -- View this message in context: http://nabble.documentfoundation.org/Looking-for-an-easier-way-to-do-the-following-in-a-spreadsheet-tp3995544p3997093.html Sent from the Discuss mailing list archive at Nabble.com. -- Unsubscribe instructions: E-mail to discuss+h...@documentfoundation.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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
