Skip to content

[Website] Incorrect Code Example in Documentation Website (Hyperlink & Formula Usage) #759

@bengbengbalabalabeng

Description

@bengbengbalabalabeng

The documentation contains inaccurate code examples regarding the usage of WriteCellData. Specifically, the current examples for setting hyperlinks and formulas do not align with the actual API, which may lead to implementation failures for users.

1. WriteCellData does not have a hyperlink() method

Image

URL: Fesod Write Extra Hyperlinks - Code Example

Correct Usage:

WriteCellData<String> cellData = new WriteCellData<>("点击访问");
HyperlinkData hyperlinkData = new HyperlinkData();
hyperlinkData.setAddress("https://example.com");
hyperlinkData.setHyperlinkType(HyperlinkData.HyperlinkType.URL);
cellData.setHyperlinkData(hyperlinkData);

2. WriteCellData(String) constructor treats input as plain text, not a formula

Image

URL: Fesod Write Extra Formulas - Code Example

Correct Usage:

WriteCellData<String> cellData = new WriteCellData<>();
FormulaData formulaData = new FormulaData();
formulaData.setFormulaValue("SUM(A1:A10)");
// Or
// formulaData.setFormulaValue("=SUM(A1:A10)");
cellData.setFormulaData(formulaData);

Are you willing to submit a PR?

  • I'm willing to submit a PR!

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions