CELL in WPS Spreadsheet: Inspect an Explicit Cell Reference

The official WPS CELL lesson documents the behavior used here. It identifies WPS Office for Windows Personal. Reviewed October 19, 2026, this Chinese-language evidence does not establish an exact introduction build, every current edition, or English-global, Mac, Linux, web or mobile behavior. No new WPS execution or native screenshot was possible; the examples are independent controls or explicitly conditional fixtures.

=CELL(info_type,reference)

• info_type: a quoted text selector, such as “row”, “col”, “contents” or “filename”.
• reference: the cell whose information is requested. Use a single cell in these examples.

The official image table was visually checked for these modes. It defines row and column numbers, contents as the value rather than the formula, and filename as a file name with full path. The article says omitted references use a changing contextual cell; this guide always supplies the reference and makes no active-cell assumption.

Create this small sheet:

Use separate result cells in column D:

The last formula requests 84, not the formula text =B3*2. This is useful in a workbook diagnostic area: position and current value answer different questions. Do not use contents mode when the goal is to document the formula itself.

These outputs are derived from explicit coordinates and arithmetic, not captured from a target WPS installation.

In a workbook you have already saved, enter =CELL("filename",B3) in a separate cell. The official lesson demonstrates filename mode for retrieving file-path information.

A conditional fixture could name a fictitious workbook C:\Training\Inventory.xlsx. If that is the workbook containing the referenced cell, the result should identify that file and path according to the installed WPS implementation. This guide intentionally does not invent the exact returned string, workbook/sheet delimiters, or a path observed on our machine.

Check the reported identity against the workbook actually open before including it in an audit footer. This mode concerns the referenced file; it should not be substituted for a general current-directory query. See INFO for that separate environment question.

A path may reveal a user name, client name or project location. Review it before exporting a workbook or posting a support screenshot. A diagnostic formula is not a reason to disclose a real private path in sample documentation.

The image table includes an unsaved-workbook statement, but this guide does not claim an observed unsaved result in any current build. Save a disposable training workbook and verify the intended workflow rather than relying on an untested empty-string assumption.

• Quote selectors: use “row”, not a bare word interpreted as a name.
• Keep the reference explicit when comparing results across cells or workbooks.
• For a multi-cell reference, the source describes the top-left cell; these examples avoid ambiguity by using one cell.
• Format-related modes need their own checks. The source says custom-format changes may require recalculation; no exhaustive format-code mapping is reproduced here.
• Use ROW when only a row number is needed, and COLUMN for the corresponding column task.
• Exact filename formatting, protected-cell behavior and locale-specific output remain separate verification contracts.

• WPS CELL lesson

Expected outputs are derived from the explicit fixtures and documented operation. They are not results observed in an installed WPS build. Check the intended edition before relying on these formulas in a shared workbook.