Einheiten in Tabelle

[Jonas 54]

Hallo zusammen

In einer Tabelle Liste ich die Höhen meiner Vermessungspunkte auf. (mit Objektliste)

Die Einheit meiner Datei ist cm will aber die Vermessungspunkte mit Meter auflisten.

Wie ändere ich die Einheit in der Liste?

 

LG

[linosphere]

Du kannst den Wert durch 100 teilen:

=(ZKOORDINATE/100)

 

[GSP_nowhere]

Hallo @Jonas 54

Grundlegend werden Maße in Tabellen immer in der Dokumenteneinheit ausgegeben.
Man kann wie @linosphere beschreibt "händisch" multiplizieren.

Alternativ gibt es die Tabellenfunktion =TXT() um Werte von Dokumenteneinheit in eine gewünscht Einheit zu wandeln.
 

Zitat

 

 

txt(Wert; ZuEinheit; [Param1]; [Param2]; ...)
	Verwandelt einen numerischen Wert von Dokumenteinheiten in die angegebene Einheit und gibt eine String-Darstellung zurück, wobei die Optionen zur Formatierung verwendet werden. Weitere Informationen finden Sie im Beispiel. (Schweiz: txt(Wert, ZuEinheit, [Param1], [Param2], ...))
	The first parameter must be <ToUnit> and then a list of optional parameters to fine tune the conversion. Parameter Details: - <ToUnit> - the units in which the value will be converted from the current document units Possible options are for using the current document units: Dim - linear dimension Area - area dimension Volume - volume dimension Angle - angular dimension General purpose options: General - as a general number Sci - as a scienific number Percent - as a percent number Linear specific units options (one of the list): FeetNInches, Inches, Feet, Miles, Yards, Microns, Millimeters, Centimeters, Meters, Kilometers, Degrees, Ares Area specific units options (one of the list): SquareInches, SquareFeet, SquareYards, SquareMiles, Acres, SquareMicrons, SquareMillimeters, SquareCentimeters, SquareMeters, SquareKilometers, Hectares Volume specific units options (one of the list): CubicInches, CubicFeet, CubicYards, Gallons, CubicMillimeters, CubicCentimeters, CubicMeters, Litres - <optional param> - rounding style Dec - decimal representation of the number Frac - fractional representation of the number Auto - will use fractional representation if rounds up to one, or decimal representation if not - <optional param> - rounding format Decimal rounding represented by the number of digits after the decimal dot. Examples: 0.000 - would round up three digits. e.g. 0.356 if the number is 0.3556678 0.0 - would round up one digit. e.g. 0.4 if the number is 0.3556678 0. - would round up to no digits. e.g. 0 if the number is 0.3556678 Fractional rounding represented by the number after the / symbol, from 1/1 to 1/64 max. Examples: 1/8 - would round to 1/8th 1/64 - would round to 1/64th 1/1 - would round to integer number - <optional param> - rounding base using multiples of tenths, quarters, or halves RoundTenth RoundQuarter RoundHalf - <optional param> - Units display NoUnits Units - <optional param> - thousands separator display ThousandsSeparator NoThousandsSeparator - <optional param> - trailing zero display NoTrailingZero TrailingZero - <optional param> - leading zero NoLeadingZeroes LeadingZeroes Examples: =TXT(2.45, 'Dim') - returns the number in the documents linear dimensions =TXT(2.45, 'Feet', 'Frac', '1/16') - returns the number in feet as fraction with 1/16 rounding