OpenOffice.info

So einfach ist das^^
Meine Herren, Vielen Dank :)

[quote]was mache ich falsch[/quote]

Du importierst alle Werte als Zahlen und erwartest sie als Text exportieren zu können.

Importiere also ggf. die Werte als Text indem Du im Importdialog für Spaltentyp "Text" statt, wie derzeitig, "Standard" einstellst.


Gruß
Stephan

"00:00","168","168","ºC","20:00"
"00:10","111","111","ºC","20:00"
"00:20","60","60","ºC","20:00"
"00:30","49","49","ºC","20:00"
"00:40","52","52","ºC","20:00"
"00:50","58","58","ºC","20:00"
"01:00","66","66","ºC","20:00"
"01:10","72","72","ºC","20:00"
"01:20","79","79","ºC","20:00"
"01:30","84","84","ºC","20:00"
"01:40","91","91","ºC","20:00"
"01:50","96","96","ºC","20:00"
usw.

00:00:00,168,168,"ºC",20:00:00

Moin zusammen,
ich habe ein kleines Problem, mein Datenlogger liefert mir eine Datei in folgendem Format:
[code]"00:00","168","168","ºC","20:00"
"00:10","111","111","ºC","20:00"
"00:20","60","60","ºC","20:00"
"00:30","49","49","ºC","20:00"
"00:40","52","52","ºC","20:00"
"00:50","58","58","ºC","20:00"
"01:00","66","66","ºC","20:00"
"01:10","72","72","ºC","20:00"
"01:20","79","79","ºC","20:00"
"01:30","84","84","ºC","20:00"
"01:40","91","91","ºC","20:00"
"01:50","96","96","ºC","20:00"
usw.
[/code]


[img]http://up.picr.de/6326107nco.jpg[/img]
Diese öffne ich über die Importfunktion in Calc und dann

[img]http://up.picr.de/6326106fai.jpg[/img]
schaut die Tabelle so aus.

[b]Soweit so gut, dann bearbeite ich die Werte und möchte im Urformat wieder speichern, das misslingt leider, Textdatei hat keine Anführungszeichen :([/b]

[img]http://up.picr.de/6326150qbr.jpg[/img]
Speichern unter:

[img]http://up.picr.de/6326151cdt.jpg[/img]
Filtereinstellungen bearbeiten

[img]http://up.picr.de/6326152tpq.jpg[/img]

[code]00:00:00,168,168,"ºC",20:00:00[/code]
[b]So sieht das exportierte Format dann aus, was mache ich falsch?[/b]