1package io.protobase.f7.spreadsheet;
  2
  3import io.protobase.f7.testutils.TestExecution;
  4import org.junit.Test;
  5
  6public class GeneralSupportedMathFormulasTest extends TestExecution {
  7  @Test
  8  public void test_ASIN() {
  9    runner().addCell("Alpha", "A1", "=ASIN(1)").addExpectedValue("Alpha", "A1", Math.asin(1)).run();
 10  }
 11
 12  @Test
 13  public void test_ABS() {
 14    runner().addCell("Alpha", "A1", "=ABS(-1.0)").addExpectedValue("Alpha", "A1", 1.0).run();
 15  }
 16
 17  @Test
 18  public void test_ACOS() {
 19    runner().addCell("Alpha", "A1", "=ACOS(4)").addExpectedValue("Alpha", "A1", Math.acos(4)).run();
 20  }
 21
 22  @Test
 23  public void test_ACOSH() {
 24    runner().addCell("Alpha", "A1", "=ACOSH(1.1111)").addExpectedValue("Alpha", "A1", 0.4671223659261196).run();
 25  }
 26
 27  @Test
 28  public void test_ACOT() {
 29    runner().addCell("Alpha", "A1", "=ACOT(1.1111)").addExpectedValue("Alpha", "A1", 0.732820074189669).run();
 30  }
 31
 32  @Test
 33  public void test_ACOTH() {
 34    runner().addCell("Alpha", "A1", "=ACOTH(1.1111)").addExpectedValue("Alpha", "A1", 1.4722668604975144).run();
 35  }
 36
 37  @Test
 38  public void test_ADD() {
 39    runner().addCell("Alpha", "A1", "=ADD(1.0, 2.0)").addExpectedValue("Alpha", "A1", 3.0).run();
 40  }
 41
 42  @Test
 43  public void test_ASINH() {
 44    runner().addCell("Alpha", "A1", "=ASINH(1)").addExpectedValue("Alpha", "A1", 0.8813735870195429).run();
 45  }
 46
 47  @Test
 48  public void test_ATAN() {
 49    runner().addCell("Alpha", "A1", "=ATAN(4)").addExpectedValue("Alpha", "A1", Math.atan(4)).run();
 50  }
 51
 52  @Test
 53  public void test_ATAN2() {
 54    runner().addCell("Alpha", "A1", "=ATAN2(4, 3)").addExpectedValue("Alpha", "A1", Math.atan2(4, 3)).run();
 55  }
 56
 57  @Test
 58  public void test_ATANH() {
 59    runner().addCell("Alpha", "A1", "=ATANH(0.489733)").addExpectedValue("Alpha", "A1", 0.5357090350574656).run();
 60  }
 61
 62  @Test
 63  public void test_COS() {
 64    runner().addCell("Alpha", "A1", "=COS(4)").addExpectedValue("Alpha", "A1", Math.cos(4)).run();
 65  }
 66
 67  @Test
 68  public void test_COSH() {
 69    runner().addCell("Alpha", "A1", "=COSH(4)").addExpectedValue("Alpha", "A1", Math.cosh(4)).run();
 70  }
 71
 72  @Test
 73  public void test_COT() {
 74    runner().addCell("Alpha", "A1", "=COT(4)").addExpectedValue("Alpha", "A1", 1 / Math.tan(4)).run();
 75  }
 76
 77  @Test
 78  public void test_DIVIDE() {
 79    runner().addCell("Alpha", "A1", "=DIVIDE(1.0, 2.0)").addExpectedValue("Alpha", "A1", 0.5).run();
 80  }
 81
 82  @Test
 83  public void test_EVEN() {
 84    runner().addCell("Alpha", "A1", "=EVEN(3.0)").addExpectedValue("Alpha", "A1", 4.0).run();
 85  }
 86
 87  @Test
 88  public void test_INT() {
 89    runner().addCell("Alpha", "A1", "=INT(16.129821)").addExpectedValue("Alpha", "A1", 16.0).run();
 90  }
 91
 92  @Test
 93  public void test_ISEVEN() {
 94    runner().addCell("Alpha", "A1", "=ISEVEN(9)").addExpectedValue("Alpha", "A1", false).run();
 95  }
 96
 97  @Test
 98  public void test_ISODD() {
 99    runner().addCell("Alpha", "A1", "=ISODD(9)").addExpectedValue("Alpha", "A1", true).run();
100  }
101
102  @Test
103  public void test_LN() {
104    runner().addCell("Alpha", "A1", "=LN(128)").addExpectedValue("Alpha", "A1", 4.852030263919617).run();
105  }
106
107  @Test
108  public void test_LOG10() {
109    runner().addCell("Alpha", "A1", "=LOG10(100)").addExpectedValue("Alpha", "A1", 2.0).run();
110  }
111
112  @Test
113  public void test_LOG() {
114    runner().addCell("Alpha", "A1", "=LOG(128, 2)").addExpectedValue("Alpha", "A1", 7.0).run();
115  }
116
117  @Test
118  public void test_MINUS() {
119    runner().addCell("Alpha", "A1", "=MINUS(1.0, 2.0)").addExpectedValue("Alpha", "A1", -1.0).run();
120  }
121
122  @Test
123  public void test_MOD() {
124    runner().addCell("Alpha", "A1", "=MOD(128, 44)").addExpectedValue("Alpha", "A1", 40.0).run();
125  }
126
127  @Test
128  public void test_MULTIPLY() {
129    runner().addCell("Alpha", "A1", "=MULTIPLY(2.0, 4.0)").addExpectedValue("Alpha", "A1", 8.0).run();
130  }
131
132  @Test
133  public void test_ODD() {
134    runner().addCell("Alpha", "A1", "=ODD(2.0)").addExpectedValue("Alpha", "A1", 3.0).run();
135  }
136
137  @Test
138  public void test_PI() {
139    runner().addCell("Alpha", "A1", "=PI()").addExpectedValue("Alpha", "A1", Math.PI).run();
140  }
141
142  @Test
143  public void test_POW() {
144    runner().addCell("Alpha", "A1", "=POW(2.0, 6.0)").addExpectedValue("Alpha", "A1", 64.0).run();
145  }
146
147  @Test
148  public void test_POWER() {
149    runner().addCell("Alpha", "A1", "=POWER(2.0, 6.0)").addExpectedValue("Alpha", "A1", 64.0).run();
150  }
151
152  @Test
153  public void test_PRODUCT() {
154    runner().addCell("Alpha", "A1", "=PRODUCT(2.0, 6.0, 4.0)").addExpectedValue("Alpha", "A1", 48.0).run();
155  }
156
157  @Test
158  public void test_QUOTIENT() {
159    runner().addCell("Alpha", "A1", "=QUOTIENT(7.0, 2.0)").addExpectedValue("Alpha", "A1", 3.0).run();
160  }
161
162  @Test
163  public void test_RANDBETWEEN() {
164    // TODO:
165  }
166
167  @Test
168  public void test_RAND() {
169    // TODO:
170  }
171
172  @Test
173  public void test_ROUND() {
174    runner().addCell("Alpha", "A1", "=ROUND(16.129821, 3.0)").addExpectedValue("Alpha", "A1", 16.13).run();
175  }
176
177  @Test
178  public void test_ROUNDDOWN() {
179    runner().addCell("Alpha", "A1", "=ROUNDDOWN(16.129821)").addExpectedValue("Alpha", "A1", 16.0).run();
180  }
181
182  @Test
183  public void test_ROUNDUP() {
184    runner().addCell("Alpha", "A1", "=ROUNDUP(16.129821)").addExpectedValue("Alpha", "A1", 17.0).run();
185  }
186
187  @Test
188  public void test_SIGN() {
189    runner().addCell("Alpha", "A1", "=SIGN(128)").addExpectedValue("Alpha", "A1", 1.0).run();
190  }
191
192  @Test
193  public void test_SIN() {
194    runner().addCell("Alpha", "A1", "=SIN(1)").addExpectedValue("Alpha", "A1", Math.sin(1)).run();
195  }
196
197  @Test
198  public void test_SINH() {
199    runner().addCell("Alpha", "A1", "=SINH(1)").addExpectedValue("Alpha", "A1", Math.sinh(1)).run();
200  }
201
202  @Test
203  public void test_SQRT() {
204    runner().addCell("Alpha", "A1", "=SQRT(4)").addExpectedValue("Alpha", "A1", Math.sqrt(4)).run();
205  }
206
207  @Test
208  public void test_SQRTPI() {
209    runner().addCell("Alpha", "A1", "=SQRTPI(4)").addExpectedValue("Alpha", "A1", 3.5449077018110318).run();
210  }
211
212  @Test
213  public void test_TAN() {
214    runner().addCell("Alpha", "A1", "=TAN(4)").addExpectedValue("Alpha", "A1", Math.tan(4)).run();
215  }
216
217  @Test
218  public void test_TANH() {
219    runner().addCell("Alpha", "A1", "=TANH(4)").addExpectedValue("Alpha", "A1", Math.tanh(4)).run();
220  }
221
222  @Test
223  public void test_UMINUS() {
224    runner().addCell("Alpha", "A1", "=UMINUS(7.0)").addExpectedValue("Alpha", "A1", -7.0).run();
225  }
226
227  @Test
228  public void test_UPLUS() {
229    runner().addCell("Alpha", "A1", "=UPLUS(\"7.0\")").addExpectedValue("Alpha", "A1", 7.0).run();
230  }
231
232  @Test
233  public void test_UNARY_PERCENT() {
234    runner().addCell("Alpha", "A1", "=UNARY_PERCENT(17.0)").addExpectedValue("Alpha", "A1", 0.17).run();
235  }
236}