Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Get the formatted cell value when setting RawCellValue as true 获取单元格值格式化后的值,设置RawCellValue无效 #1446

Closed
abicai opened this issue Jan 12, 2023 · 2 comments
Labels
wontfix This will not be worked on

Comments

@abicai
Copy link

abicai commented Jan 12, 2023

image
例如获取这里面的US$1800 实际得到的是1800 获取不到格式化后的值
f.GetCellValue(sheetName,"G10", excelize.Options{
RawCellValue: true,
})

@xuri
Copy link
Member

xuri commented Jan 12, 2023

Thanks for your issue. The field RawCellValue is used to specify get the cell value without applying the number format style, so this behavior is in expect, if you wanna get the formatted result, please set the RawCellValue value as false. In addition, the library support applying partial built-in and custom number format, this feature working in progress, so as the documentation noted, if the cell format can be applied to the value of a cell, the applied value will be returned, otherwise, the original value will be returned. Please also reference issue #660.

@xuri xuri changed the title 获取单元格值格式化后的值,设置RawCellValue无效 Get the formatted cell value when setting RawCellValue as true 获取单元格值格式化后的值,设置RawCellValue无效 Jan 12, 2023
@xuri xuri added the wontfix This will not be worked on label Jan 12, 2023
@xuri
Copy link
Member

xuri commented Jan 12, 2023

I closed this issue, if you have any questions, please let me know to reopen this anytime.

@xuri xuri closed this as completed Jan 12, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
wontfix This will not be worked on
Projects
None yet
Development

No branches or pull requests

2 participants