CSC in ONLYOFFICE: Cosecant of a Radian Angle
How to use the ONLYOFFICE CSC function: documented radians/numeric input, worksheet examples, reciprocal formulas, limitations and platform notes.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in ONLYOFFICE Spreadsheet Editor. How formula examples are checked
Quick answer. CSC(number) returns the cosecant of a radian angle. Mathematically, cosecant is 1 divided by sine, where sine is nonzero. See ONLYOFFICE’s current CSC reference for the vendor’s one-argument signature. The examples are independently calculated mathematical expectations; native ONLYOFFICE execution was not performed.
What CSC does—and what its number means
Cosecant is useful when an opposite side and an angle are known and a hypotenuse is required, or as a reciprocal-sine factor. The mathematical definition is:
CSC(x)=1/SIN(x) whenever SIN(x)≠0. This identity is a mathematical derivation, not an execution claim for ONLYOFFICE.
Exact official syntax, arguments, and defaults
=CSC(number)
| Argument | Position | Required? | Input type and unit described by ONLYOFFICE | Default |
|---|---|---|---|---|
number |
1 | Yes; the only documented argument | Numeric angle in radians; its absolute value must be strictly less than 2^27 (134,217,728) | No optional argument/default documented |
The official page explicitly states the strict bound abs(number)<2^27; an argument equal to the boundary is outside the documented input range. It does not establish a particular returned error code for violating that limit, nor specify how blank cells, quoted numerals or Boolean inputs are coerced. This guide uses ordinary numeric cells. Official evidence.
Documented radian angles: The values in column A are deliberately degrees for human readability, but the input actually given to SEC/CSC/COT is RADIANS(A2) and so on. This transformation is essential.
Reproduce the worksheet from a blank file
- Open an editable spreadsheet in ONLYOFFICE Spreadsheet Editor. Its current function-entry guide shows Formula → Function or manually entering a formula beginning with
=. - Put
angle (°)in A1 andCSC resultin B1. Type the following numeric values, one per row, into A2:A9: 30, 45, 60, 90, 120, 150, 270, 330. - Enter
=CSC(RADIANS(A2))in B2 and fill down through B9. The row references should change automatically. Use English formula language for these exact names. - Compare B2:B9 to the independent mathematical expectations, not to claimed screenshots or observed runtime outputs:
| Cell / row | Value in column A | Enter in column B (or fill down) | Independently calculated expectation |
|---|---|---|---|
| A2 | 30 | =CSC(RADIANS(A2)) |
≈ 2 |
| A3 | 45 | =CSC(RADIANS(A3)) |
≈ 1.4142135624 |
| A4 | 60 | =CSC(RADIANS(A4)) |
≈ 1.1547005384 |
| A5 | 90 | =CSC(RADIANS(A5)) |
≈ 1 |
| A6 | 120 | =CSC(RADIANS(A6)) |
≈ 1.1547005384 |
| A7 | 150 | =CSC(RADIANS(A7)) |
≈ 2 |
| A8 | 270 | =CSC(RADIANS(A8)) |
≈ -1 |
| A9 | 330 | =CSC(RADIANS(A9)) |
≈ -2 |
- For extra verification, open Formula → Function and search for
CSCas described in the vendor’s insertion instructions. This checks that the feature is exposed in your installation; it is not proof that every historical release supports it.
Additional reproducible formulas and independently calculated results
These are directly pasteable English-language examples in separate empty cells. They are expected results from independent mathematical calculations, not native ONLYOFFICE observations. Answers marked ≈ are rounded for display; compare a few decimals.
| English-locale formula | Mathematical expected result | Why it matters |
|---|---|---|
=CSC(PI()/2) |
≈ 1 | cosecant of 90° |
=CSC(RADIANS(30)) |
≈ 2 | 30° conversion |
=7*CSC(RADIANS(30)) |
≈ 14 | hypotenuse from opposite 7 |
=CSC(RADIANS(45)) |
≈ 1.4142135624 | 45° conversion |
=CSC(RADIANS(150)) |
≈ 2 | quadrant II, positive sine |
=CSC(-PI()/2) |
≈ -1 | negative cosecant |
=CSC(RADIANS(270)) |
≈ -1 | negative vertical axis, sine −1 |
=CSC(RADIANS(60)) |
≈ 1.1547005384 | 60° conversion |
=CSC(RADIANS(30))*SIN(RADIANS(30)) |
≈ 1 | identity near 1 |
=CSC(PI()/6)/CSC(PI()/2) |
≈ 2 | ratio of two cosecants |
=ABS(CSC(-PI()/6)) |
≈ 2 | nonnegative magnitude |
=1/SIN(RADIANS(45)) |
≈ 1.4142135624 | independent reciprocal expression |
Advanced applications and important mathematical limits
1. Find a right-triangle hypotenuse from the opposite side
Suppose the opposite side is 7 units and the acute angle is 30°. Since sin(angle)=opposite/hypotenuse, =7*CSC(RADIANS(30)) has an independent mathematical expectation of 14 units. This is a geometric relation for a right triangle; it does not mean that every cosecant result is a length.
2. Check the reciprocal identity
For inputs where sine is nonzero, CSC(x)*SIN(x)=1 in real arithmetic. Enter =CSC(RADIANS(30))*SIN(RADIANS(30)); the expected result is approximately 1. A finite-precision difference in the last digit is not necessarily a faulty function.
3. Understand negative angles and periodicity
Cosecant is odd: CSC(-x)=-CSC(x) for admissible x. For example =CSC(-PI()/2) has expected result −1. It also repeats every full turn (2π radians) in exact mathematics, but avoid evaluating the function right at an integer multiple of π, where the underlying sine is zero.
Errors, apparent surprises and safe troubleshooting
| Formula or symptom | Explanation and action |
|---|---|
=CSC(0) |
The reciprocal of sine is mathematically undefined because sine(0)=0. The vendor page does not specify the exact error code for this case; treat it as a boundary test requiring native execution. |
=CSC(PI()) |
Mathematically undefined at a multiple of π; floating-point approximations of π can produce a very large finite number instead of an error. |
=CSC(30) when you mean 30° |
The documented unit is radians. Use CSC(RADIANS(30)) for a degree-based angle. |
=CSC(134217728) |
Outside the documented range: the vendor requires absolute argument strictly smaller than 2^27. The function page does not promise a specific error code; do not assert one. |
A quoted numeral ("1"), blank reference, logical TRUE or multiple arguments |
The one-argument vendor reference does not specify coercion or precise errors for these cases. Enter a genuine numeric value and check the real Desktop/web version instead of assuming behaviour from a different spreadsheet program. |
| Formula name appears unknown | Check the installed ONLYOFFICE editor version, Formula Language, and actual Function picker. A vendor’s current unversioned help article is not a guarantee about an old or custom-hosted installation. |
| Last decimal digits differ | Formatting, finite-precision π/radian conversion, argument reduction or transcendental evaluation can affect displayed digits. Use a tolerance rather than exact floating-point equality. |
A safer check for boundary-sensitive formulas
If your model will ever evaluate a mathematically singular point, test the domain before evaluation rather than relying on a specific error message or last-digit numerical coincidence. Avoid building critical logic around comparing COS(RADIANS(90)) or SIN(PI()) to exactly zero; floating-point values near the mathematical singularity need a numeric tolerance. This is mathematical design advice, not a verified ONLYOFFICE evaluation rule.
Related ONLYOFFICE references
- RADIANS — official ONLYOFFICE documentation (checked 2026-10-13 UTC).
- SIN — official ONLYOFFICE documentation (checked 2026-10-13 UTC).
Documentation and evidence classification (checked 2026-10-13 UTC)
- ONLYOFFICE function-page evidence: CSC documents the displayed formula name, the one-argument signature, an input described as an angle in radians, and the magnitude restriction. It does not document native results for this article’s custom worksheet.
- Function entry workflow: ONLYOFFICE Docs: Inserting functions describes selecting Formula → Function, searching by name, and entering formulas with an equals sign. It gives English formula examples using commas as argument separators.
- Regional settings: Spreadsheet Editor Advanced Settings describes Formula Language, region, and decimal/thousands separators. Examples here use the English function name and decimal dot. Verify formula translation and separators in your installation rather than asserting a tested locale matrix.
- Product editions and versions: The ONLYOFFICE Docs changelog lists Docs 10.0.0, released 10 October 2026, whereas the Desktop Editors changelog separately lists Desktop Editors 9.4.0, released 19 May 2026. The official Desktop GitHub releases also lists 10.0.0 released 13 October 2026. These release references do not establish the first version supporting this function, nor prove Desktop/web runtime parity.
- Runtime confidence: Custom numerical expectations were independently recalculated at high precision. Native ONLYOFFICE Desktop/web execution and locale-specific parsing were not tested.
Native compatibility checks
For compatibility checks, record the named Docs web version and Desktop build, cell results, function availability, extreme-input behavior and relevant singular boundaries. Repeat with the formula language and regional settings actually used.