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

[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

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

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!

[allanehareddy]

Hi, I’d like to work on this issue.
I will verify the incorrect code example on the documentation website and submit a fix PR.
Please let me know if that’s okay.

[bengbengbalabalabeng]

Hi, I’d like to work on this issue. I will verify the incorrect code example on the documentation website and submit a fix PR. Please let me know if that’s okay.

Thank you! I’ve already submitted a similar PR (#766). If you're interested, feel free to review it together with the community members. 😊