ONLYOFFICE STDEVPA: Population Spread with Text and Logical Values

• Introduced: The first introduction release and date are not established by the checked sources.
• Availability: Currently documented in ONLYOFFICE’s rolling Spreadsheet Editor help; no final supported-version endpoint is established.
• Scope: Ten scalar cases were executed in Desktop Editors Community 10.0.0.169 on Linux x64. Docs, other desktop builds and mobile clients were not tested.
• Checked: October 14, 2026, against the official STDEVPA reference, source code and saved native results. Additional worksheet and illustration reconstructions were independently calculated.

STDEVPA(value1, [value2], ...)

The official entry documents one leading value argument and optional further arguments, up to 255 values. A range can supply multiple observations. This argument limit is not a claim that a range is limited to 255 cells. Use the separator accepted by your spreadsheet locale; the formulas below follow the English help’s comma notation.

The official help says text and FALSE contribute zero, TRUE contributes one, and empty cells are ignored. The pinned implementation explicitly maps strings to zero and uses the population denominator n inside the square root.

The native cases below confirm those outcomes for ordinary text, the exact numeric string 2, logical values, a true empty reference and a formula returning empty text. A formula result of "" is text, so it is not the same tested input as a genuinely empty cell. The source revision is separately scoped and is not asserted to identify every shipped build.

Create a sheet named TypedDispersion, leaving space through column J and row 16. Enter the following inputs in column B. Labels can go in A; put outputs in G so no formula overwrites an input.

Do not enter quote characters around the text in B8 or B12. If B12 is converted to a numeric cell during import, it is no longer the same test. The native fixture’s input types were checked from the saved workbook, not inferred from appearance.

The following results were observed after an explicit workbook recalculation in Desktop Editors Community 10.0.0.169, Linux x64 and verified in its saved output. Displayed decimals are rounded to ten places.

The exact numeric string 2 contributes zero in both the reference and literal tests, just like ordinary text. The true empty-cell reference is excluded, while B14’s empty-text formula contributes zero. Consequently, the broad mixed range in G15 agrees with G8. These observations do not establish every imported text grammar, array-constant or empty-set result.

G8 corresponds to the five numbers 4,6,0,1,0. Their mean is 2.2, and their squared-deviation total is 28.8. Dividing by five gives variance 5.76; its square root is 2.4.

For an independently calculated Boolean example, create FlagPopulation. Put =TRUE() in A2:A4 and =FALSE() in A5. In C2 enter =STDEVPA(A2:A5) for approximately 0.4330127019. In C3 enter =VARPA(A2:A5) for 0.1875. In C5 enter =AVERAGEA(A2:A5) for 0.75. In C4 enter =SQRT(C5*(1-C5)) for the same standard deviation: three out of four flags are TRUE, so the zero/one population has p=0.75.

Copy the sheet to AllFlagsTrue and change A5 to =TRUE(). C5 becomes 1, and C2:C4 become 0. The mean-based formula now follows the changed flags instead of retaining a fixed 0.75 assumption.

The all-TRUE result means the four flags agree. It does not establish completeness, accuracy or absence of future variation. These flag worksheets are independent model examples beyond the ten native probes above.

On a separate VendorGrid sheet, enter this 4-by-4 grid in A1:D4. Numeric entries are numbers, text is ordinary text, and the TRUE/FALSE entries are formulas producing logical values.

In F2 enter =STDEVPA(A1:D4). The independently reconstructed result is approximately 3.9006209442, matching the precision shown in the vendor illustration. This entire illustration was not part of the native ten-case fixture. Its displayed values do not, on their own, prove the original screenshot workbook’s stored types.

The examples do not establish exact errors for empty datasets, error cells, huge magnitudes or malformed arguments.

AVERAGEA supplies the zero/one mean in the flag example. STDEV.P has a separately documented numeric-oriented contract. STDEVA calculates sample standard deviation; VARPA calculates population variance.