Importing CSV and Posting questions on forum

[Ivo van Emmerik]

1) Importing CSV
All the information is in the two documents













2) Posting questions on forum

Sorry I want to ask the forum a question! But I can not see a button to start a 
new message, I logged in there is no clear indication where to press, if I am 
blocked because I am new than tell me, this is very frustrating!

Sent from Mail for Windows 10

JOB NAME: E:\Users\Ivo\Documents\Constructa\2017\Cameron Park\MGA harris st 4
Date:  20/02/2018
Point,Layer,Dsn Height,
 111, LIP,   14.668,
 112, LIP,   14.623,
 113, LIP,   14.433,
 114, LIP,   14.263,
 115, LIP,   14.243,
 116, LIP,   14.112,
 117, LIP,   14.093,
 118, LIP,   13.981,
 119, LIP,   13.853,
 120, LIP,   13.725,
 121, LIP,   13.597,
 122, LIP,   13.483,
 123, LIP,   13.363,
 124, LIP,   13.243,
 125, LIP,   13.123,
 126, LIP,   13.103,
 127, LIP,   12.980,
 128, LIP,   12.856,
 129, LIP,   12.733,
 130, LIP,   12.633,
 131, LIP,   12.623,
 132, LIP,   12.523,
 133, LIP,   12.423,
 134, LIP,   12.323,
 135, LIP,   12.283,
 136, LIP,   12.183,
 137, LIP,   12.083,
 138, LIP,   12.083,
 163, LIP,   14.608,
 164, LIP,   14.563,
 165, LIP,   14.373,
 166, LIP,   14.203,
 167, LIP,   14.183,
 168, LIP,   14.052,
 169, LIP,   14.033,
 170, LIP,   13.921,
 171, LIP,   13.793,
 172, LIP,   13.665,
 173, LIP,   13.537,
 174, LIP,   13.423,
 175, LIP,   13.303,
 176, LIP,   13.183,
 177, LIP,   13.063,
 178, LIP,   13.043,
 179, LIP,   12.920,
 180, LIP,   12.796,
 181, LIP,   12.673,
 182, LIP,   12.573,
 183, LIP,   12.563,
 184, LIP,   12.463,
 185, LIP,   12.363,
 186, LIP,   12.263,
 187, LIP,   12.223,
 188, LIP,   12.123,
 189, LIP,   12.023,
 190, LIP,   12.023,
 217,FACE,   14.743,
 218,FACE,   14.698,
 219,FACE,   14.508,
 220,FACE,   14.338,
 221,FACE,   14.318,
 222,FACE,   14.187,
 223,FACE,   14.168,
 224,FACE,   14.056,
 225,   STORM,   13.928,
 226,FACE,   13.800,
 227,FACE,   13.672,
 228,FACE,   13.558,
 229,FACE,   13.438,
 230,FACE,   13.318,
 231,FACE,   13.198,
 232,FACE,   13.178,
 233,FACE,   13.055,
 234,FACE,   12.931,
 235,FACE,   12.808,
 236,   STORM,   12.708,
 237,FACE,   12.698,
 238,FACE,   12.598,
 239,FACE,   12.498,
 240,FACE,   12.398,
 241,FACE,   12.358,
 242,FACE,   12.258,
 243,   STORM,   12.158,
 244,FACE,   12.158,
 270,FACE,   14.683,
 271,FACE,   14.638,
 272,FACE,   14.448,
 273,FACE,   14.278,
 274,FACE,   14.258,
 275,FACE,   14.127,
 276,FACE,   14.108,
 277,FACE,   13.996,
 278,FACE,   13.868,
 279,FACE,   13.740,
 280,FACE,   13.612,
 281,FACE,   13.498,
 282,FACE,   13.378,
 283,FACE,   13.258,
 284,FACE,   13.138,
 285,FACE,   13.118,
 286,FACE,   12.995,
 287,FACE,   12.871,
 288,FACE,   12.748,
 289,   STORM,   12.648,
 290,FACE,   12.638,
 291,FACE,   12.538,
 292,FACE,   12.438,
 293,   STORM,   12.338,
 294,FACE,   12.298,
 295,FACE,   12.198,
 296,   STORM,   12.098,
 297,FACE,   12.098,
 499,  CL,   14.638,
 500,  CL,   14.593,
 501,  CL,   14.403,
 502,  CL,   14.233,
 503,  CL,   14.213,
 504,  CL,   14.082,
 505,  CL,   14.063,
 506,  CL,   13.951,
 507,  CL,   13.823,
 508,  CL,   13.695,
 509,  CL,   13.567,
 510,  CL,   13.453,
 511,  CL,   13.333,
 512,  CL,   13.213,
 513,  CL,   13.093,
 515,  CL,   13.073,
 517,  CL,   13.032,
 519,  CL,   12.991,
 521,  CL,   12.950,
 523,  CL,   12.909,
 525,  CL,   12.867,
 527,  CL,   12.826,
 529,  CL,   12.785,
 531,  CL,   12.744,
 533,  CL,   12.703,
 535,  CL,   12.670,
 537,  CL,   12.636,
 539,  CL,   12.603,
 540,  CL,   12.593,
 542,  CL,   12.560,
 544,  CL,   12.526,
 546,  CL,   12.493,
 548,  CL,   12.460,
 550,  CL,   12.426,
 552,  CL,   12.393,
 553,  CL,   12.360,
 555,  CL,   12.326,
 557,  CL,   12.293,
 558,  CL,   12.253,
 559,  CL,   12.153,
 560,  CL,   12.053,
 561,  CL,   12.053,
 642,1 M OFSET,   14.743,
 643,1 M OFSET,  

Re: Importing CSV and Posting questions on forum

[David Robley]

On 02/20/2018 11:14 AM, Ivo van Emmerik wrote:


2) Posting questions on forum

Sorry I want to ask the forum a question! But I can not see a button 
to start a new message, I logged in there is no clear indication where 
to press, if I am blocked because I am new than tell me, this is very 
frustrating!



Go to the forum and log in. Click on the section of the forum in which 
you want to post a question, e.g. Calc. Once in the selected section, 
look for an icon New Topic in the upper left hand side of the page.



Cheers
--
David Robley

There's no life after death. Just Los Angeles.
 

Re: Importing CSV and Posting questions on forum

[Martin Groenescheij]

On 20/02/18 11:44 AM, Ivo van Emmerik wrote:


 1. Importing CSV

All the information is in the two documents



Delete the first two lines from the CSV file to get the columns correct 
remember that each spreadsheet looks at the first line to

find what columns to use, then open it in Calc.
Because there are a lot of spaces in front of the values it is interpret 
as text not as numbers, the way OpenOffice handles text

it puts the ` in front of the number.
If you remove all the spaces it will load correctly as numbers. To save 
you a lot of time there is an option with importing CSV files
tick the Detect special numbers and it will handle the values as numbers 
instead of text.



2) Posting questions on forum

Sorry I want to ask the forum a question! But I can not see a button 
to start a new message, I logged in there is no clear indication where 
to press, if I am blocked because I am new than tell me, this is very 
frustrating!


Sent from Mail  for 
Windows 10




-
To unsubscribe, e-mail: users-unsubscr...@openoffice.apache.org
For additional commands, e-mail: users-h...@openoffice.apache.org

Re: Importing CSV and Posting questions on forum

[David Robley]

On 02/20/2018 11:14 AM, Ivo van Emmerik wrote:


 1. Importing CSV

All the information is in the two documents



On the Text Import dialogue box, make sure Detect special numbers is 
checked.


Cheers
--
David Robley

To err is human. To really screw up it takes a computer!