An extension library for IupMatrix. This library adds new features to the IupMatrix in order to extend the current features. Adds support for Import/Export, Clipboard, Undo/Redo, Find, Sort, Column Visibility, Numeric Columns, Numeric Units, Context Menu and others.
It can be used in callback mode or in standard more.
This is an additional control that depends on the IupControls library. (Since IUP version 3.24 the separate library that contains IupMatrixEx was merged with the IupControls library)
Based on the DMatrix library created by Bruno Kassar and Luiz Cristóvão Gomez Coelho.
Ihandle* IupMatrixEx(void); [in C]
iup.matrixex{} -> (ih: ihandle) [in Lua]
matrixex() [in LED]
This function returns the identifier of the created editing component, or NULL if an error occurs.
The IupMatrixEx element handle all attributes defined for a IupMatrix control.
BUSY: returns Yes if the library is changing the matrix contents internally as a result of an operation such as paste or duplicate. Can be canceled setting to No. See the BUSY_CB callback for more information.
BUSYPROGRESS: flag to display a progress dialog while data is being changed. Can be Yes or No. Default: No.
LASTERROR (read-only): set when an error occurred during an operation. It is reset to NULL at the start of every operation that sets its value.
COPY (write-only): copies (export) the selected cells to the clipboard in TEXT format. If value is ALL then all cells are copied regardless if there is a selection. If value is MARKED then the MARKED attribute is used to define the selection. Value can also be a range of cells in the format "L1:C1-L2:C2". Title cells are not copied, even when a line or column is fully selected. If the column or line is invisible (its size=0) it is not copied. The TEXTSEPARATOR attribute can used to define a column separator (default is tab '\t') and line separator will be line feeds ('\n').
When MARKMODE=CELLS and sparse cells are selected there are two options for copy
according to the COPYKEEPSTRUCT attribute, if "Yes" the copied
data will fit a rectangular region that contains all the selected cells and the
non selected cells inside the region will be copied as empty spaces (' '), if
"No" only the selected cells will be copied but they must contain a matrix
consistent structure, in other words the selected column pattern must be
consistent along lines.
LASTERROR can be set to "NOMARKED" (no selected
cells) or "MARKEDCONSISTENCY" (when COPYKEEPSTRUCT=NO and inconsistent
selection).
Copied lines will follow the sort order.
COPYDATA: Use the same parameters of the COPY attributes but will copy (export) to an internal buffer. To retrieve the buffer get the attribute value after setting it. To clear the internal buffer set it to NULL.
COPYFILE (write-only): copies (export) all visible cells to a given file. Value is the file name to be saved. LASTERROR can also be set to "INVALIDFILENAME" (failed to open). Data will be in plain text format, but the file format will be defined by the FILEFORMAT attribute, can be "TXT" (default), "HTML" or "LaTeX". The COPYCAPTION attribute can be used to define a caption that will be added to the file before the data, depending on the file format.
When using TXT format, the TEXTSEPARATOR
attribute can used to define a column separator (default is tab '\t') and line
separator will be line feeds ('\n').
When using LaTeX format, the LATEXLABEL attribute can used to
define a label for the table.
When using HTML format, the attributes
"HTML<TABLE>", "HTML<TR>", "HTML<TH>", "HTML<TD>", "HTML<CAPTION>" can use used
to define a complement to be inserted in the respective tag definition, so a "
style=.." or a " class=.." complements can be added. The HTMLADDFORMAT can be
used to add the attributes ALIGNMENT?, BGCOLOR?:?, FGCOLOR?:? and FONT?:? to the
"style" complement of the "TD" tag.
For all formats use:
SKIPLINES: number of lines to skip at start when exporting the
matrix to a file, not counting the title line if any. (since 3.12)
SKIPCOLUMNS: number of columns to skip at start when exporting the
matrix to a file, not counting the title columns if any. (since 3.12)
Copied
lines will follow the sort order.
PASTE (write-only): paste (import) data from the clipboard. Data is obtained from the clipboard in TEXT format. Value is the insert position, it can be "FOCUS" to use the FOCUS_CELL attribute, can be "MARKED" to use the start of the selected groups of cells (top-left selected cell), or can be a cell address "L:C".
Data must be in plain text format. Lines can be separated in
DOS, UNIX or MAC format. Columns can be separated with a tab ('\t'), or with
a semicolon (';'), or with a space (' ') or with a custom value defined by the TEXTSEPARATOR attribute. Data
must contain an exact matrix organization. Use the attribute TEXTSKIPLINES to
skip a number of lines in the beginning of the data. If data at the insert
position will have more lines or columns than the current matrix, then the
PASTESIZE_CB callback is called, if the callback
does not exist the matrix size is not changed, and the exceeding data will be discarded. If defined the
EDITION_CB callback will be called before the cell value is set. LASTERROR
can be set to "NOTEXT" (data is empty or NULL), "INVALIDMATRIX" (not a matrix
data). BUSY will be set to Yes during the operation. Only
visible cells will receive data.
Pasted lines will follow the sort order.
PASTEDATA (write-only): paste (import) data from a memory buffer. Value is the data. Insert position is obtained from the FOCUS_CELL attribute. See PASTE for more details.
PASTEFILE (write-only): paste (import) data from a file. Value is the file name to be loaded. Insert position is always "0:0". See PASTE for more details. LASTERROR can also be set to "INVALIDFILENAME" (failed to open). The PASTEFILEAT attribute controls the insert position, can be "FOCUS" or a cell address "L:C" (since 3.17).
FIND: searches for the given text in the matrix cells. The search will start at the FOCUS_CELL cell, if found the FOCUS_CELL will be changed to the cell where the text were found and the cell will also be marked. If not visible the cell will the scrolled to the visible area. Returns the last text searched.
FINDDIRECTION: direction of the find. Default RIGHTBOTTOM.
if RIGHTBOTTOM will
search from left to right, then top to bottom;
(search for columns then change line)
if LEFTTOP will search from right to
left, then bottom to
top;
if BOTTOMRIGHT will search from top to bottom, then
left to right; (search for lines then change column)
if
TOPLEFT will search from bottom to top, then right to left;
FINDMATCHCASE: defines if the text comparison is case sensitive when using FIND. Can be Yes or No. Default: Yes.
FINDMATCHWHOLECELL: defines if the whole cell will be used for comparison or it will search for the first occurrence of the text inside the cell. Can be Yes or No. Default: Yes.
FINDMATCHSELECTION: defines if the whole matrix will be searched or just the selected cells. Can be Yes or No. Default: No.
UNDOREDO: Enable or disable the Undo/Redo support. Can be Yes or No. Default: No. Undo/Redo support is available only for cell values, interactively or programmatically changed. Attributes are not saved/restored.
UNDOCOUNT (read-only): Returns the total number of stored undo levels.
UNDONAMEid (read-only): Returns a name for the given undo level. It represents the operation that was performed. Uses descriptive strings based on the names "PASTECLIP", "PASTEDATA", "PASTEFILE", "COPYCOLTO:ALL", "COPYCOLTO:TOP", "COPYCOLTO:BOTTOM", "COPYCOLTO:MARKED", "COPYCOLTO:INTERVAL", "CLEARVALUE", "SETCELL" and "EDITCELL", that are language dependent.
UNDO: Sets the number of undo levels to be performed. If value is NULL will undo 1 level. When retrieved returns Yes or No indicating if it has Undo to be performed. BUSY will be set to Yes during the operation.
REDO: Sets the number of redo levels to be performed. If value is NULL will redo 1 level. When retrieved returns Yes or No indicating if it has Redo to be performed. BUSY will be set to Yes during the operation.
UNDOCLEAR (write-only): clears all Undo/Redo information.
SORTCOLUMNid (write-only): sort the specified lines of the matrix based on the values of the given column (id). Can be ALL (1-NUMLIN), an interval in the format "L1-L2", INVERT (invert the order in the current interval of the current column, id is ignored) or RESET (remove any ordering). The SORTSIGNid attribute will be updated to reflect the ordering.
When the SORTCOLUMNCOMPARE_CB callback is NOT defined, and the column
in NOT numeric, then the text is lexicographically sorted. This
means that numbers and text in the same value are sorted separately (for ex: A1 A2 A11 A30
B1). Also
natural alphabetic order is used: 123...aAáÁ...bBcC... The internal comparison
will work only for Latin-1
characters, even if UTF8MODE is Yes. Uses the
IupStringCompare function.
Sorting is reset if
lines are added or removed. (since 3.17)
IMPORTANT: The sort
will not affect the original data, only how it is displayed from the original
data and how it is updated to the original data. ALSO the line and cell attributes of
the sorted lines will NOT be affected, this means that sizes, colors and fonts will NOT
follow the sort order, also means that cell address in FOCUS_CELL, MARKED,
ORIGIN, SHOW, HEIGHTn (which implies VISIBLELINn), and others, are all relative to the
display position data and
they do NOT follow the sort order. *VALUE_CB, EDITION_CB and VALUE_EDIT_CB will
be called with the correct line index following the sort order, all other callbacks
won't.
SORTCOLUMNORDER: defines if the number or text comparison is in ASCENDING or DESCENDING order. Default: ASCENDING. Used during SORTCOLUMNid and when the SORTCOLUMNCOMPARE_CB callback is NOT defined. Used to update the SORTSIGNid attribute when the SORTCOLUMNCOMPARE_CB callback is defined.
SORTCOLUMNCASESENSITIVE: defines if the text comparison is case sensitive. Can be Yes or No. Default: Yes. Used only during SORTCOLUMNid and when the SORTCOLUMNCOMPARE_CB callback is not defined.
SORTCOLUMNINTERVAL (read-only): Returns the last sorted interval, in the format "L1,L2".
SORTLINEINDEXid (read-only): Returns the sorted line index given a line in regular order. To be used inside other callbacks. (since 3.16)
LASTSORTCOLUMN (read-only): Returns the last sorted column. (since 3.17)
FREEZE: freezes the scroll of columns and lines up to the given cell. Can be: "Yes" - uses the value of the FOCUS_CELL attribute, "L:C" where L and C are the line and column, or "No" clear the freeze state. Internally will set the NUMLIN_NOSCROLL and NUMCOL_NOSCROLL, and change the FRAMEHORIZCOLOR of the line and the FRAMEVERTCOLOR of the column to the color defined by FREEZECOLOR.
FREEZECOLOR: color used for the freeze lines. Default: "0 0 255". Used only by the FREEZE attribute.
VISIBLECOLid: returns if the column is visible ("Yes" or "No"). Actually checks for WIDTHid and RASTERWIDTHid if they are defined and non zero, but more complex logic when id=0. When changed will simply set those attributes to zero or NULL (when setting to NULL and col=0 not necessarily the column will became visible because of the internal matrix logic for titles).
VISIBLELINid: returns if the line is visible ("Yes" or "No"). Actually checks for HEIGHTid and RASTERHEIGHTid if they are defined and non zero, but more complex logic when id=0. When changed will simply set those attributes to zero or NULL (when setting to NULL and lin=0 not necessarily the line will became visible because of the internal matrix logic for titles).
MENUCONTEXT: enable the context menu. Can be Yes or No. Default: Yes.
SHOWCONTEXTMENUL:C (write-only): shows the context menu using the L:C cell as reference and its value as screen position in the format "x:y". (since 3.12)
SHOWMENUCONTEXT (write-only): show the context menu in the given cel. Value has the "L:C" format.
SHOWDIALOG (write-only): show the dialog used in the context menus. Can be: SETTINGS, EXPORT_TXT, EXPORT_LATEX, EXPORT_HTML, IMPORT_TXT, UNDOLIST, FIND, GOTO, SORT and COPYCOLTO_INTERVAL. Some dialog are not show if the matrix is read-only.(since 3.16)
COPYCOLTOL:C (write-only): copies (duplicates) the value of the given cell to a specified range of cells in the same column. Value can be "ALL" (for all lines), TOP (for all lines before the given line), BOTTOM (for all lines after the given line), MARKED (for all lines where the cell is marked), or a series of intervals in the format "L1-L2,L3-L4,L5,L6-L7,...". BUSY will be set to Yes during the operation. Only visible cells will receive data.
Numeric columns are enabled when the NUMERICQUANTITYid attribute is set. To define a numeric column without using units simply set NUMERICQUANTITYid to "None".
NUMERICDECIMALSYMBOL: symbol used for decimal separator in numeric values. Can be "." or "," only. If not defined will try the DEFAULTDECIMALSYMBOL global attribute. (since 3.12)
NUMERICFORMATid: format to convert the numeric data into strings at the given column (id). If not defined the NUMERICFORMATDEF attribute will be used. Uses the same format specification of the sprintf function in C, but only one value will be processed, can not contain other strings. (no redraw)
NUMERICFORMATPRECISIONid: will set the sprintf "precision" field in the NUMERICFORMATid attribute string if the format "%.<precision>f" . If the NUMERICFORMATid attribute is not defined returns NULL. It is just a simple form to set the format attribute. If id is not used it will affect the NUMERICFORMATDEF attribute. (no redraw)
NUMERICFORMATDEF: default value used when NUMERICFORMATid is not specified. If not defined it will used the DEFAULTPRECISION global attribute to build one (for intance "%.2f" if the DEFAULTPRECISION is 2).
NUMERICFORMATTITLEid: format of the title at the given column (id). Uses the same format specification of the sprintf function in C. It can contain other strings, and will receive two parameters the current column title string ("0:C") and the current column unit shown. If the current title is NULL, then only the unit parameter is passed. If not specified then only the title string ("0:C") is used. (no redraw)
NUMERICQUANTITYid: Quantity used to define units for the numeric data at the given column (id). Must set this attribute for the other NUMERIC* attributes to work. For the available option see Available Quantity and Units table bellow. To improve the precision consider using the NUMERICGETVALUE_CB and NUMERICSETVALUE_CB callbacks. The returned value is always the name of the quantity in the table, regardless the value that was set. To use the numeric attributes and callbacks without using units, simply set quantity to "None". To disable all numeric support set quantity to NULL. (no redraw)
NUMERICUNITCOUNTid (read-only): Returns the number of units for the current quantity at the given column (id).
NUMERICUNITid: Unit of the numbers set into the matrix at the given column (id) using the unit name as value. Must be in the same category of the NUMERICQUANTITYid attribute. For the available options see Available Quantity and Units table bellow. The application must process numbers for the column only in this unit, when getting or setting attributes. But the values passed to the DROP_CB and MENUDROP_CB callbacks will not be processed because they can contain strings. The returned value is always the name of the unit in the table, regardless the value that was set. Default value is the first unit on the table bellow. (no redraw)
NUMERICUNITSHOWNid: Unit to be displayed at the given column (id). Must be in the same category of the NUMERICFORMAT attribute. The library will automatically convert the numeric data to and from the shown and data units when the data is displayed or modified. The returned value is always the name of the unit in the table, regardless the value that was set. Default value is the first unit on the table. (no redraw)
NUMERICUNITSYMBOLid and NUMERICUNITSYMBOLSHOWNid: same as NUMERICUNIT* but using the units symbol as value. (no redraw)
NUMERICUNITSEARCH (write-only): Searches for a unit name. Set the result in the NUMERICFOUNDQUANTITY, NUMERICFOUNDUNIT and NUMERICFOUNDUNITSYMBOL attributes. For the available options see Available Quantity and Units table bellow.
NUMERICUNITSYMBOLSEARCH (write-only): same as NUMERICUNITSEARCH, but searches for a unit symbol.
NUMERICFOUNDQUANTITY (read-only): Returns the quantity found after a NUMERICUNITSEARCH* set. Returns NULL if not found.
NUMERICFOUNDUNIT (read-only): Returns the unit name found after a NUMERICUNITSEARCH* set. Returns NULL if not found.
NUMERICFOUNDUNITSYMBOL (read-only): Returns the unit symbol found after a NUMERICUNITSEARCH* set. Returns NULL if not found.
The following attributes will affect all IupMatrixEx controls. So the application can register new quantities and all IupMatrixEx elements will benefit. All strings must be constant strings. All attributes are Write-Only and non inheritable. They all can be set without the element being mapped to the native system.
NUMERICUNITSPELL: spelling used for Unit names. The default "INTERNATIONAL" uses the International Bureau of Weights and Measures standards: metre and litre. Set to "AMERICAN" To use the American spelling: "meter" and "liter".
NUMERICADDQUANTITY: adds a new quantity given its name. Can have up to 25 new names. If the name exists, simply prepare to add new units to that quantity.
NUMERICADDUNIT: adds a new unit given its name for the last quantity added. Can have up to 25 total names. The first unit added will be the reference unit and its factor will be automatically set to 1.
NUMERICADDUNITSYMBOL: sets the symbol name of the last unit added.
NUMERICADDUNITFACTOR: sets the factor number in double precision of the last unit added. Use "%.18g" in IupSetStrf or sprintf for maximum double precision. The factor is the reference multiplier to obtain the unit, or how much you multiply a value in the reference unit to obtain a new value in this unit. For example, 1 km = 1000 m, then for the "km" unit factor=1000 considering that the reference unit is "m".
The IupMatrixEx element understands all callbacks defined for a IupMatrix control.
BUSY_CB: Action generated when the library is changing the matrix contents as a result of an operation such as paste or copy.
int function(Ihandle* ih, int status, int count, char* name); [in C]
ih:busy_cb(status,count: number, name: string) -> (ret: number) [in Lua]
ih:
identifier of the element that activated the
event.
status: can be 1=process started, 2=iteration,
0=process finished.
count: when status=1 is the total number
of iterations. when status=2 is the current iteration. ignored when status=0.
name: valid only when status=1, otherwise is NULL. Can be
"PASTECLIP", "PASTEDATA", "PASTEFILE", "COPYCOLTO:ALL", "COPYCOLTO:TOP", "COPYCOLTO:BOTTOM", "COPYCOLTO:MARKED", "COPYCOLTO:INTERVAL",
"UNDO" or "REDO".
Returns: When status=2 and IUP_IGNORE is returned the processing is aborted. When process is aborted the callback will be called once more with status=0.
NUMERICGETVALUE_CB: Action generated when a cell value is being retrieved from a numeric column. It is only called if the cell value is NULL in normal mode, or the VALUE_CB returned value is NULL in callback mode, and the column has NUMERICQUANTITYid defined. Not called for lin=0.
double function(Ihandle* ih, int lin, int col); [in C] ih:numericgetvalue_cb(lin, col: number) -> (ret: number) [in Lua]
ih:
identifier of the element that activated the event.
lin, col:
coordinates of the cell.
Returns: the number to be drawn.
NUMERICSETVALUE_CB: Action generated when a cell value is being modified at a numeric column. It is only called if the column has NUMERICQUANTITYid defined. Not called for lin=0. If defined the value will not be updated as string in normal mode and VALUE_EDIT_CB will not be called in callback mode.
int function(Ihandle* ih, int lin, int col, double value); [in C] ih:numericsetvalue_cb(lin, col, value: number) -> (ret: number) [in Lua]
ih: identifier of the element that activated
the event.
lin, col:
coordinates of the cell.
value: new value of the cell.
MENUCONTEXT_CB: Action generated after the context menu is created but before it is displayed, so the application can add or removed items from the menu. Only shown if MENUCONTEXT=Yes.
int function(Ihandle* ih, Ihandle* menu, int lin, int col); [in C]
ih:menucontext_cb(menu: ihandle, lin, col: number) -> (ret: number) [in Lua]
ih:
identifier of the element that activated the
event.
menu:
identifier of the menu that will
be shown to the user.
lin, col:
coordinates of the cell.
Returns: if returns IUP_IGNORE the action will be aborted and the context menu will not be shown. (since 3.13)
MENUCONTEXTCLOSE_CB: Same as MENUCONTEXT_CB, but called after the context menu is closed. Only shown if MENUCONTEXT=Yes. (since 3.12)
PASTESIZE_CB: Action generated when pasting and importing data at the insert position will have more lines or columns than the current matrix. The application can change the NUMLIN and NUMCOL attributes to receive the new data.
int function(Ihandle* ih, int num_lin, int num_col); [in C]
ih:pastesize_cb(num_lin, num_col: number) -> (ret: number) [in Lua]
ih:
identifier of the element that activated the
event.
status: can be 1=process started, 2=iteration,
0=process finished.
count: when status=1 is the total number
of iterations. when status=2 is the current iteration. ignored when status=0.
name: valid only when status=1, otherwise is NULL. Can be
"PASTE", "PASTEDATA", "PASTEFILE".
Returns: if returns IUP_IGNORE the process will be aborted. if returns IUP_CONTINUE, the NUMLIN and NUMCOL attributes will be automatically changed to the given values. Otherwise and if the callback does not exist the matrix size is not changed, and the exceeding data will be discarded.
SORTCOLUMNCOMPARE_CB: Action generated when sorting data in a column to compare two cell values.
int function(Ihandle* ih, int col, int lin1, int lin2); [in C]
ih:sortcolumncompare_cb(col,lin1,lin2: number) -> (ret: number) [in Lua]
ih:
identifier of the element that activated the
event.
col: column being sorted.
lin1,
lin2:
the line numbers of the two cells being compared.
Returns: must return 0 if "col:lin1==col:lin2", -1 if "col:lin1<col:lin2", and 1 if "col:lin1>col:lin2".
The library adds a context menu where the user can execute the new features. If the matrix is read-only some of the features are not shown.
The FILEDIRECTORY attribute can be used to control the initial directory in Export and Import file dialogs (since 3.12), just sets the DIRECTORY attribute of IupFileDlg. The LASTFILENAME attribute can be consulted after the file dialogs were successfully closed (since 3.12). If LASTFILENAME is set before the dialog is shown then used to obtain the initial directory, just sets the FILE attribute of IupFileDlg (since 3.17). LASTFILENAME is set to NULL if the dialog is canceled (since 3.17).
The CELLBYTITLE attribute controls how the "Go To..." dialog and the "Copy To - Interval" dialog interpret line and column values. If set to Yes, then the title lines/columns are used as indices to locate the cell. (since 3.13)
Settings... => Shows the Settings Dialog
----------------
Export
Txt... => Shows a file selection dialog and saves the cells to a file.
LaTeX... => ( " )
Html... => ( " )
Import
Txt... => Shows a file selection dialog and loads the cells from a file.(not read-only)
----------------
Undo => Undo 1 level (not read-only)
Redo => Redo 1 level (not read-only)
Undo List... => Show the Undo Dialog (not read-only)
----------------
Cut => Copy + Clear Cell Values (not read-only)
Copy => Copy to Clipboard (marked cells)
Paste => Paste from Clipboard (start at focus cell) (not read-only)
Erase => Clear Cell Values (not read-only)
Select All => Select All Cells
----------------
Find... => Show the Find Dialog
Go To... => Show the Go To Cell Dialog
----------------
Sort... => Show the Sort Dialog
Freeze/UnFreeze => Makes the current cell a non scrollable point / Reset to default
Visibility
Hide Column
Show Hidden Columns
Hide Line
Show Hidden Lines
Column Units... / Column Decimals... => Show Column Units Dialog or Column Decimals Dialog
----------------
Copy To (Same Column) Copy cell value to other lines in the same column (not read-only)
All Lines => Copy To All Lines
Here to Top => Copy From the Current Cell to L=0
Here to Bottom => Copy From the Current Cell to L=NUMLIN
Interval... => Show "Copy To - Interval" Dialog
Selected Lines => Copy to the Selected Cells
The library adds some shortcut keys to the already implemented in IupMatrix:
Ctrl+A (English) => Select All Ctrl+T (Portuguese or Spanish) => Select All Ctrl+X => Cut (Copy + Clear Cell Values) Ctrl+C => Copy to Clipboard (marked cells) Ctrl+V => Paste from Clipboard (start at focus cell) Ctrl+Z => Undo 1 level Ctrl+Y (English) => Redo 1 level Ctrl+R (Portuguese or Spanish) => Redo 1 level Ctrl+F (English) => Show the Find Dialog Ctrl+L (Portuguese or Spanish) => Show the Find Dialog Alt+F3 => Show the Find Dialog Esc => Hide the Find Dialog F3 => Find Next Shift+F3 => Find Previous Ctrl+G => Show the Go To Cell Dialog
Unit names, symbols and conversion factors were almost all based on:
http://en.wikipedia.org/wiki/Conversion_of_units
By definition, unit names and symbols follow the case displayed in the table. When setting the NUMERICQUANTITY and NUMERICUNIT attributes use English names, the case is insensitive and spaces are ignored. Some Quantities have alternative names, once used the returned values in the attribute will be the same alternative name. For example, you can use "Specific Weight" or "SPECIFICWEIGHT", and you can use "Speed" or "Velocity".
All numeric attributes can be set without the element being mapped to the native system, so the IupMatrixEx element can also be used as a Quantity Units database.
The unit used as a reference for conversion is always the first unit listed, and it is the unit defined by the International System of Units (SI). The American spell can be used setting NUMERICUNITSPELL=AMERICAN.
NOTICE: These are only a small set of commonly used units. If you need other units, please let us know so we can include them.
Obs: "g" in Comments is the standard gravity. All Quantity and Unit names are described in English. The symbols that have extended characters will work in ISO8859-1 and in UTF-8, according to the UTF8MODE global attribute. The cell background colors are just for clarity and do not imply in any standard classification.
Quantity NUMERICQUANTITY |
Units NUMERICUNIT |
Symbol NUMERICUNITSYMBOL |
Comments |
---|---|---|---|
Time | second minute hour day week millisecond microsecond |
s min h d wk ms µs |
|
Mass | kilogram gram tonne pound ounce |
kg g t lb oz |
- (CGS Unit) - metric ton - (international avoirdupois) - oz = lb / 16 |
Temperature | Kelvin degree Celsius degree Fahrenheit degree Rankine |
K °C °F °Ra |
|
Length | metre millimetre centimetre kilometre nanometre angstrom micron inch foot yard mile nautical mile |
m mm cm km nm Å µ in ft yd mi NM |
- (CGS Unit) - micrometre - in = 25.4 mm (international) - ft = 12 in (international) - yd = 3 ft (international) - mi = 1760 yd (international) - NM = 6080 ft (Admiralty) |
Area | square metre square millimetre square centimetre square kilometre square nanometre square angstrom square micron square inch square foot square yard square mile acre hectare |
m² mm² cm² km² nm² Ų µ² sq in sq ft sq yd sq mi ac ha |
- (CGS Unit) - ac = 4840 sq yd |
Volume | cubic metre cubic centimetre cubic millimetre cubic kilometre cubic inch cubic foot cubic mile cubic yard litre gallon barrel |
m³ cm³ mm³ km³ cu in cu ft cu mi cu yd L gal bl |
- (CGS Unit) - gal = 231 cu in (US fluid; Wine) - bl = 42 gal (petroleum) |
Angle | radian degree gradian |
rad ° grad |
|
Speed (or Velocity) |
metre per second inch per second foot per second kilometre per hour centimetre per second mile per hour knot |
m/s in/s ft/s km/h cm/s mph kn |
- (CGS Unit) - kn = NM/h |
Angular Speed (or Angular Frequency) |
radian per second radian per minute degree per second degree per minute Hertz revolution per minute |
rad/s rad/min deg/s deg/min Hz rpm |
- revolution per second (frequency) |
Acceleration | metre per second squared inch per second squared knot per second mile per second squared standard gravity |
m/s² in/s² kn/s mi/s² g |
|
Kinematic Viscosity | square metre per second square foot per second stokes |
m²/s ft²/s St |
- (CGS Unit) |
Dynamic Viscosity | pascal second poise pound per foot hour pound per foot second |
Pa·s P lb/(ft·h) lb/(ft·s) |
|
Flow | cubic metre per second cubic inch per second cubic foot per second |
m³/s in³/s ft³/s |
|
Force | Newton Kilonewton dyne kilogram-force pound-force kip-force ton-force |
N kN dyn kgf lbf kip tnf |
= kg·m/s² = g·cm/s² (CGS Unit) - lbf = g · lb - kip = g · 1000 lb - tnf = g · 2000 lb |
Pressure (or Mechanical Stress) |
Pascal kilopascal atmosphere millimetre of mercury bar torr pound per square inch kip per square inch |
Pa kPa atm mmHg bar torr psi ksi |
- Pa = N/m² = kg/(m·s²) - (standard) = mmHg =13595.1 kg/m³·mm·g - psi = lbf/sq in - ksi = kip/sq in |
Force per length (or Linear Weight) |
Newton per metre Kilonewton per metre kilogram-force per metre ton-force per metre |
N/m kN/m kgf/m tnf/m |
= kg/s² |
Torque (or Moment of Force) |
Newton metre kilogram-force metre ton-force metre Newton centimetre kilogram-force centimetre ton-force centimetre Kilonewton-metre metre kilogram |
N·m kgf·m tnf·m N·cm kgf·cm tnf·cm kN·m m·kg |
= kg·m²/s² |
Specific Mass (or Density) |
kilogram per cubic metre gram per cubic centimetre gram per millilitre kilogram per litre pound per cubic foot pound per cubic inch pound per gallon |
kg/m³ g/cm³ g/mL kg/L lb/ft³ lb/in³ lb/gal |
|
Specific Weight | Newton per cubic metre Kilonewton per cubic metre kilogram-force per cubic metre ton-force per cubic metre kilogram-force per litre pound-force per cubic foot |
N/m³ kN/m³ kgf/m³ tnf/m³ kgf/L lbf/ft³ |
|
Energy | Joule Kilojoule calorie kilocalorie British Thermal Unit Kilowatt-hour horsepower-hour |
J kJ cal kcal BTU kW.h hp.h |
= m·N = kg·m²/s² - (International Table) - (International Table) |
Power (or Heat Flow Rate) |
Watt Kilowatt calorie per second horsepower |
W kW cal/s hp |
= J/s = N·m/s = kg·m²/s³ - (International Table) - hp = 550 ft lbf/s (imperial mechanical) |
Electric Charge | Coulomb Faraday milliampere hour |
C F mA·h |
= A·s |
Illuminance | lux footcandle lumen per square inch phot |
lx fc lm/in² ph |
- lm/m² - lumen per square foot |
Fraction | percentage per one per ten per thousand |
% /1 /10 /1000 |
|
None | Use numeric values but without using units. |