ReoGrid Forum

Fast and powerful .NET Spreadsheet Component

You are not logged in.

Announcement

This forum has been archived and no longer accepts new user registrations. Please report your questions, problems, and feedback to the issue page of ReoGrid on GitHub. Thank you for your cooperation.

https://github.com/unvell/ReoGrid/issues

Pages: 1

#1 2016-04-11 12:16:52

lmr123
Member
Registered: 2016-03-22
Posts: 3

导出Excel时负数显示问题。

表格里的负数导出Excel时，虽然实际值也是负数，但是显示的是正数。
能不能直接导出Excel负数看到的直接就是负数。

Offline

#2 2016-04-12 00:52:36

oops
Moderator
Registered: 2015-11-03
Posts: 54

Re: 导出Excel时负数显示问题。

试了一下没能再现。那个单元格有Data Format设置么？如果有请贴一点代码。

Offline

#3 2016-04-12 03:27:12

lmr123
Member
Registered: 2016-03-22
Posts: 3

Re: 导出Excel时负数显示问题。

RangePosition AmountRange = new RangePosition(4, 2, this.sheet.RowCount - 3, this.sheet.ColumnCount - 3);
                sheet.SetRangeDataFormat(AmountRange, CellDataFormatFlag.Number,
                new unvell.ReoGrid.DataFormat.NumberDataFormatter.NumberFormatArgs
                 {
                     DecimalPlaces = 2,
                     UseSeparator = true
                 });

Offline

#4 2017-01-01 11:03:19

jiangxun
Member
Registered: 2017-01-01
Posts: 4

Re: 导出Excel时负数显示问题。

能给出vb.net代码吗？

Offline

Pages: 1

Board footer

Powered by FluxBB