search

xuri / excelize-wasm

A WebAssembly build of the Go Excelize library for reading and writing Microsoft Excel™ (XLAM / XLSM / XLSX / XLTM / XLTX) spreadsheets
https://xuri.me/excelize
BSD 3-Clause "New" or "Revised" License
197 stars 34 forks source link

[Feature request] Provide options for data validation drop list #8

Open gltjk opened 1 year ago

gltjk commented 1 year ago

Description

I am trying to replicate the official dependent drop list example with excelize-wasm but I can't provide items for the drop list.

In the type definition of DataValidation it can be seen that there's no place for list options -- none of the types are arrays.

According to the documentation, the correct way of providing options in Go is .SetSqrefDropList method but I cannot find its counterpart in JavaScript.

Is it not implemented yet or have I missed something?

Steps to reproduce the issue:

  1. N/A

Describe the results you received: There is no way to provide drop list options.

Describe the results you expected: There is a way to provide drop list options.

Output of node -v: v20.1.0

Output of npm -v: 9.6.4

Output of go version: go version go1.20.4 darwin/amd64

Excelize version or commit ID: excelize-wasm@0.0.3

Environment details (OS, Microsoft Excel™ version, Browser version, physical, etc.):

OS: macOS 13.3.1 (22E261)
Excel version: 16.73 (23050701)
xuri commented 1 year ago

Thanks for your issue. This package doesn't support this currently. I'll add this feature later.

Jangts commented 1 year ago

I engaged the same problem. I set kinds of values to the property Formula1 while the type was list, but none of them worked.