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+1 d2=a1+2 e2=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 -- View this message in context: http://nabble.documentfoundation.org/Looking-for-an-easier-way-to-do-the-following-in-a-spreadsheet-tp3995544.html Sent from the Discuss mailing list archive at Nabble.com. -- Unsubscribe instructions: 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.documentfoundation.org/www/discuss/ All messages sent to this list will be publicly archived and cannot be deleted
