----- Mensaje original ----- De: "Wade Smart" <wadesm...@gmail.com> Para: ooo-us...@incubator.apache.org Enviados: Miércoles, 15 de Enero 2014 23:45:40 Asunto: [openoffice] Flipping a table
In my calc sheet I have a need to flip the entire sheet. So Column 1A would be 450A? Ive found several macros but Ive not been able to get them to work. Does anyone know if this can be done? Wade -- ------------------------------------------------------------- 1A and 450A (more properly A1 and A450 ) are cells, not columns. Supposing you want row 1 to be row 450, row 2 to be row 449 and so on it's just a matter of order. If you can't find a field for reordering as you want, then you can insert a temporary new column A with contents A1=1, A2=2, ... A450=450 and then you can sort the sheet by column A (reverse order). For inserting those values in column A just write 1 in A1, press [enter], click on cell A1 (to select that cell) and then double-click on the little square in then lower-right corner of cell A1 (or drag that little square from A1 to cell A450) . Hope this helps (if I understood your problem) Luis.
