Ako zmazať riadky pre splay-shots: Select a cell in Column C - kde sú čísla bodov alebo -. Select all cells in the spreadsheet with Ctrl-A. Open the Data->Filter->Standard Filter menu. Set the first row of the filter so that Field Name is "Column C", Condition is "Equals" and Value is ¨-¨. Click OK to apply the filter to the spreadsheet. Select all rows in the spreadsheet with Ctrl-A. To unselect any column header cells, hold Ctrl and click the appropriate row. Right-click on any of the row numbers and select Delete Rows. Select one of the column header cells, or any non-blank cell. Use the Data->Filter->Remove Filter menu item to restore the remaining rows.
5. 1. 2016 v 13:01, Martin Sluka <martinsluka@mac.com>:
To by ale vůbec nevadilo. Stačilo by vyexportovat tabulku: Název bodu;survey;length;clino;asimut;note
Přesně tohle je v tom sql exportu. Akorát kuchařku, jak se na ta data dostat. Oni všichni tvůrci Survexu a Therionu si s SQL tykají. Tak je to jednoduché jak facka:
1. otevři .sql soubor v textovém editoru 2. najdi sekci, která vypadá takhle:
insert into STATION values (859, '40.5', 3275, 443203.59, 4731741.06, 543.77); insert into STATION values (860, '-', 3275, 443201.66, 4731742.97, 543.19); insert into STATION values (861, '-', 3275, 443202.60, 4731742.99, 543.35); insert into STATION values (862, '-', 3275, 443203.15, 4731742.09, 543.32); insert into STATION values (863, '-', 3275, 443204.17, 4731742.66, 543.36); insert into STATION values (864, '-', 3275, 443204.11, 4731743.42, 543.32); insert into STATION values (865, '-', 3275, 443202.93, 4731739.39, 541.24);
Všechno tam je, stačí nakopírovat do tabulky a vyházet přebytečné sloupce a řádky. Jo a ještě pro češtinu zaměnit „.“ za „,“ ale až v tabulce.
:)
m. _______________________________________________ Therion-cs mailing list Therion-cs@speleo.sk http://mailman.speleo.sk/mailman/listinfo/therion-cs