AUD PLATFORM EN
페이지 트리
메타 데이터의 끝으로 건너뛰기
메타 데이터의 시작으로 이동


List of Excel Functions Supported in MX-Grid

No.Function NameSupported Version (maf-extend)Remarks
1*AUD_HIDE_COLUMNS7.0.300.152022-07-06
This function is specific to MX-GRID.
Function Prototype : AUD_HIDE_COLUMNS(condition As Boolean, Optional range As range) As String
Hides the Column area corresponding to the provided parameter.
If no parameter is passed, it hides the current Column.
2*AUD_HIDE_ROWS7.0.300.152022-07-06
This function is specific to MX-GRID.
Function Prototype :  AUD_HIDE_ROWS(condition As Boolean, Optional range As range) As String
Hides the Row area corresponding to the provided parameter.
If no parameter is passed, it hides the current Row.
3*AUD_IMAGE7.0.300.152022-07-06
This function is specific to MX-GRID Platform.
Function Prototype : AUD_IMAGE(imageName As Variant)
Displays an image in a cell based on the image name provided as a parameter.
Images path should be located in the reports/WEB_IMAGES folder or a specified path under reports.
To reference an image within Excel, set the parameter value to start with a colon(:). E.g. AUD_IMAGE(":Image1")
4*AUD_PROPERTY7.0.300.152022-07-19
This function is specific to MX-GRID.
Function Prototype : AUD_PROPERTY(cellText As String, Optional propName1 As Variant, Optional propValue1 As Variant, Optional propName2 As Variant, Optional propValue2 As Variant)
  
Creates properties in cells that are accessible from the client.
On the Client side, you can access these values as shonwn below.
 var OniGridCellClick  = function(sender, args){
  if(args.Cell.getProperty("ITEM1")){
  var arrMsg = [];
arrMsg.push("ITEM 1 = " +  args.Cell.getProperty("ITEM1"));
arrMsg.push("ITEM 2 = " +  args.Cell.getProperty("ITEM2"));
arrMsg.push("ITEM 3 = " +  args.Cell.getProperty("ITEM3"));
arrMsg.push("ITEM 4 = " +  args.Cell.getProperty("ITEM4"));
alert(arrMsg.join("\n"));
}
 };
5*AUD_TEMPLATE_BINDING7.0.300.152022-07-19
This function is specific to MX-GRID.
Function Prototype : AUD_TEMPLATE_BINDING(formulaRange As Variant, styleRange As Variant, Optional alternativeStyleRange As Variant)
   This function enables the use of templates during data binding. When set in a cell at position -1 relative to where data is bound (both row and column), it outputs data based on the area specified by the parameters.
   formulaRange : Sets the area where data field names or formulas are specified.
   styleRange   :  Sets the area where style area and cell styling are specified.
   alternativeStyleRange : Designates the style area for repeated rows.
   
6*AUD_CHECK_BOX7.0.300.362022-07-19
This function is specific to MX-GRID.
Function Prototype : AUD_CHECK_BOX(text As Variant, value As Variant, Optional linkCell As range, Optional status As Integer)
Displays a CHECKBOX on the screen.
  text          : The text for the CHECKBOX
  value        : The value for the CHECKBOX
  linkRanges : Cells to update when the CHECKBOX's value changes
                  When a single cell is specified, its value will be updated to the CHECKBOX's valuee.
                  When a range is specified, the status of the CHECKBOX within that range will be updated to the currnet CHECKBOX's status("select all" functionality)
                  If ststus is not provided, the CHECKBOX will be selected if all values in linkRanges match the current CHECKBOX value.
  status     : The value indicating the CHECKBOX's selection state (0:false, 1:true, -1:mix)
7*AUD_RADIO_BUTTON7.0.300.362022-07-19
This function is specific to MX-GRID.
Function Prototype : AUD_RADIO_BUTTON(text As Variant, value As Variant, Optional linkCell As range)
Displays a Radio Button on the screen. (Only works within mx-grid.)
 text       : The text for the radio button
 value      : The value for the radion button
 linkCell   : The cell to be updated when the radio button value changes
              The radion button will be checked, if the value of the cell matches the current radion button's value.
8*AUD_PROTECT7.0.400.142023-02-08
This function is specific to MX-GRID.
Function Prototype : AUD_PROTECT(range1 As Variant, Optional range2 As Variant, Optional range3 As Variant, Optional range4 As Variant) As String
Locks cells within a specified range, preventing them from being modified.
 range1   : Cell range or address to lock
 range2..?: Additional cell ranges or addresses to lock
9*AUD_PROTECT_INDIRECT7.0.400.142023-02-08
This function is specific to MX-GRID.
Function Prototype : AUD_PROTECT_INDIRECT(range1 As Variant, Optional range2 As Variant, Optional range3 As Variant, Optional range4 As Variant) As String
Locks cells within a specified range, preventing them from being modified.
 range1   : Cell range or address containing cell addresses to lock
 range2..?: Additional cell ranges or addresses containing cell addresses to lock
10*AUD_EXPAND_ROW7.0.400.142023-02-10
This function is specific to MX-GRID.
Function Prototype : AUD_EXPAND_ROW(isExpand As Boolean, range1 As Variant, Optional range2 As Variant, Optional range3 As Variant) As String
Creates expand/collapse button for the specified ROW areas.
 isExpand : Determines whether to display the rows in an expanded state
 range1   : Target Row or Row range to apply expand or collapse
 range2..?: Target Row or Row range to apply expand or collapse
11*AUD_EXPAND_COLUMN7.0.400.142023-02-10
This function is specific to MX-GRID.
Function Prototype : AUD_EXPAND_COLUMN(isExpand As Boolean, range1 As Variant, Optional range2 As Variant, Optional range3 As Variant) As String
Creates expand/collapse button for the specified COLUMN areas.
 isExpand : Determines whether to display the rows in an expanded state
 range1   : Target Column or Column range to apply expand or collapse
 range2..?: Target Column or Column range to apply expand or collapse
12*AUD_ISMODIFIED7.0.400.242023-03-19
This function is specific to MX-GRID.
Function Prototype : AUD_ISMODIFIED(range1 As Variant, Optional range2 As Variant, Optional range3 As Variant, Optional range4 As Variant) As String
Returns whether the cells within a specified range have been modified.
 range1 ~ range?   : Cell ranges to check for modifications
13ABS　　
14ACOS　　
15AND　　
16ASIN　　
17ATAN　　
18AVERAGE　　
19AVERAGEIF　　
20CEILING　　
21CHAR　　
22CHOOSE3.0.300.12022-04-04
23COLUMN　　
24COS　　
25COUNT　　
26COUNTA　　
27COUNTIF　　
28COUNTIFS3.0.100.37 　
29DATE　　
30DATEVALUE　　
31DAY　　
32DEGREES　　
33EDATE3.0.200.78　
34EOMONTH3.0.200.1102022-03-21
35EXACT7.0.300.152022-07-20
36EXP　　
37FACT　　
38FIND　　
39FLOOR　　
40HLOOKUP　　
41HOUR　　
42HYPERLINK   Allows linking to a URL or calling a function within the report
 1. URL link : =HYPERLINK("http://www.bimatrix.co.kr", "Homepage")
 2. Function call within the report =HYPERLINK("CELL_CLICK", "Cell clicked")
      // Function Sample
      var CELL_CLICK = function(sender, cell){
             // sender : MXGrid Control
             // cell :  Clicked Cell (istudio.control.iGrid.Cell)
      }
43IF　　
44IFERROR　　
45INDEX3.0.100.37 Array return types are not supported (row_num = 0 or column_num = 0)
46INDIRECT3.0.100.37 R1C1 style is not supported
47INT　　
48IPMT3.0.200.78　
49ISBLANK　　
50ISERR　　
51ISERROR　　
52ISLOGICAL　　
53ISNUMBER　　
54ISOWEEKNUM3.0.200.892021-12-18
55ISTEXT　　
56LARGE3.0.200.892021-12-18
57LEFT　　
58LEN　　
59LOWER　　
60MATCH3.0.100.37 　
61MAX　　
62MID　　
63MIN　　
64MINUTE　　
65MOD　　
66MONTH　　
67NOT　　
68NOW　　
69OFFSET　　
70OR　　
71PERCENTILE3.0.200.892021-12-18
72PERCENTILE.EXC3.0.200.892021-12-18
73PERCENTILE.INC3.0.200.892021-12-18
74PI　　
75PMT3.0.200.78　
76POWER　　
77PPMT3.0.200.78　
78QUOTIENT　　
79RADIANS　　
80RAND　　
81RANDBETWEEN 3.0.300.12022-04-02
82RANK　　
83REPLACE　　
84REPT　　
85RIGHT　　
86ROUND　　
87ROUNDDOWN3.0.200.892021-12-18
88ROW　　
89SEARCH　　
90SECOND　　
91SIN　　
92SMALL3.0.200.892021-12-18
93STDEV3.0.200.892021-12-18
94STDEV.P3.0.200.892021-12-18
95STDEV.S3.0.200.892021-12-18
96STDEVA7.0.300.262022-08-25
97STDEVP3.0.200.892021-12-18
98STDEVPA3.0.200.892021-12-18
99SUBSTITUTE　　
100SUM　　
101SUMIF　　
102SUMIFS3.0.100.37 　
103TAN　　
104TEXT　　
105TIME　　
106TODAY　　
107TRIM　　
108TRUNC　　
109UPPER　　
110VALUE　　
111VAR3.0.200.892021-12-18
112VAR.P3.0.200.892021-12-18
113VAR.S3.0.200.892021-12-18
114VARP3.0.200.892021-12-18
115VLOOKUP　　
116WEEKDAY　　
117WEEKNUM3.0.200.85Validation is completed for values after the year 1901
 (Values before December 31, 1900, do not match Excel's behavior)
118YEAR　　
119FALSE　　
120TRUE　　
121FORMULATEXT7.0.300.35Only added to the 7 sub-packages
122CONCAT7.0.300.36　
123CONCATENATE7.0.300.36　
124TEXTJOIN7.0.300.36　
125ROUNDUP7.0.300.41　
126IFNA7.0.400.2　
127ISNA7.0.400.2　
128NA7.0.400.2　
129FORECAST7.0.400.412023-04-18
130FORECAST.LINEAR7.0.400.412023-04-18
131INTERCEPT7.0.400.412023-04-18
132SLOPE7.0.400.412023-04-18
133AVERAGEIFS7.0.400.662023-05-26
134MAXIFS7.0.400.662023-05-26
135MINIFS7.0.400.662023-05-26
136DSUM7.0.400.692023-06-08
137DCOUNT7.0.400.692023-06-08
138DCOUNTA7.0.400.692023-06-08
139DMAX7.0.400.692023-06-08
140DMIN7.0.400.692023-06-08
141DAVERAGE7.0.400.692023-06-08
142NETWORKDAYS7.0.400.702023-06-09
143SQRT7.0.400.1022023-06-20
144DAYS7.0.400.1122023-08-01
145DATEDIF7.0.400.119

2023-08-23

※ [Limitations] The DATEDIF function may produce different results compared to Excel for calculations involving the year 1900. ( This is due to a known bug in Excel where it incorrectly recognizes 1900 as a leap year )

146YEARFRAC7.0.400.1192023-08-23
147DAYS3607.0.400.1192023-08-23
148LN7.0.400.1312023-10-06
149LOG7.0.400.1312023-10-06
150MEDIAN7.0.400.1322023-10-10
151FIXED7.0.400.2142024-03-12
152CORREL　7.0.500.112024-04-30
153RSQ　7.0.500.112024-04-30　
154T.DIST　7.0.500.112024-04-30　
155T.DIST.2T7.0.500.112024-04-30　
156T.DIST.RT7.0.500.112024-04-30
157T.INV7.0.500.112024-04-30
158T.INV.2T7.0.500.112024-04-30
159FINV7.0.500.112024-04-30
160F.INV7.0.500.112024-04-30
161F.INV.RT7.0.500.112024-04-30
162TTEST7.0.500.112024-04-30
163T.TEST7.0.500.112024-04-30
164FTEST7.0.500.112024-04-30
165F.TEST7.0.500.112024-04-30
166FDIST7.0.500.112024-04-30
167F.DIST7.0.500.112024-04-30
168F.DIST.RT7.0.500.112024-04-30
169

LINEST

7.0.500.372024-06-14
170NPV7.0.500.382024-06-18
171IRR7.0.500.382024-06-19
172SUMPRODUCT7.0.500.382024-06-18
173MODE7.0.500.612024-07-23
174MODE.SNGL7.0.500.612024-07-23
175MODE.MULT7.0.500.612024-07-23
176CELL7.0.500.842024-10-11
177NUMBERVALUE7.0.500.922024-11-07
178SUBTOTAL7.0.500.117

2025-03-04

When using subtotal function options, options 1-11 in Excel include manually hidden rows. However, MX-GRID does not identify manually hidden rows, so please use options 101-111 instead.

In the future, after implementing the filter feature in the product, options 1-11 will be properly supported. Therefore, you should consider compatibility when creating reports.

  • 레이블 없음