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

#1 2016-01-29 15:03:14

genI3
Member
From: Russia
Registered: 2016-01-29
Posts: 6

Incorrect displaying hidden scrollbar and opening files

I used ReoGrid from NuGet package in WPF.

When I try to hide scrollbar and tabcontrol, I get white line in place of scrollbar:
0edef126b4.png

When I try to load previously saved "*.xlsx" file, I get NullReferenceException, irrespective of loading method:

   in fo.a(IWorkbook A_0, bu A_1, WorkbookSheet A_2)
   in fo.a(IWorkbook A_0, Stream A_1)
   in cu.Load(IWorkbook workbook, Stream stream, Encoding encoding, Object arg)
   in d6.Load(Stream stream, FileFormat fileFormat, Encoding encoding)
   in d6.Load(String path, FileFormat fileFormat, Encoding encoding)
   in unvell.ReoGrid.ReoGridControl.Load(String path, FileFormat fileFormat, Encoding encoding)
   in unvell.ReoGrid.ReoGridControl.Load(String path, FileFormat fileFormat)
   in Test.LoadFromFile(String path) в C:\*\Test.cs:line 222

or

   in fo.a(IWorkbook A_0, bu A_1, WorkbookSheet A_2)
   in fo.a(IWorkbook A_0, Stream A_1)
   in cu.Load(IWorkbook workbook, Stream stream, Encoding encoding, Object arg)
   in d6.Load(Stream stream, FileFormat fileFormat, Encoding encoding)
   in d6.Load(String path, FileFormat fileFormat, Encoding encoding)
   in d6.Load(String path, FileFormat fileFormat)
   in Test.LoadFromFile(String path) в C:\*\Test.cs:line 223

Offline

#2 2016-01-30 00:46:29

Jingwood
Moderator
From: jing at reogrid.net
Registered: 2014-06-03
Posts: 615

Re: Incorrect displaying hidden scrollbar and opening files

Thanks. I will check this problem.

Offline

#3 2016-02-15 10:41:26

genI3
Member
From: Russia
Registered: 2016-01-29
Posts: 6

Re: Incorrect displaying hidden scrollbar and opening files

If it help, I attach the file was saved by using Save(FileName, FileFormat.Excel2007).
Initially, the first row of each worksheet has been frozen.
It normally opens with MS Excell (but row freeze state not saved) and throwing exception if I open it in ReoGrid.

Last edited by genI3 (2016-02-15 10:43:11)

Offline

#4 2016-02-15 14:53:37

Jingwood
Moderator
From: jing at reogrid.net
Registered: 2014-06-03
Posts: 615

Re: Incorrect displaying hidden scrollbar and opening files

Thanks! I've tested by using your test file. Very helpful. And these two problems has been fixed and will be available soon in next release.

1. Extra padding after hiding scrollbars and tab control.
2. Loading generated Excel file error.

For the second problem, you have to regenerate the Excel file by the latest version because this xlsx file generated by current version incorrectly.

Offline

#5 2016-02-16 06:20:35

genI3
Member
From: Russia
Registered: 2016-01-29
Posts: 6

Re: Incorrect displaying hidden scrollbar and opening files

Thank you!
That's great!

Offline

#6 2016-02-17 07:04:17

Jingwood
Moderator
From: jing at reogrid.net
Registered: 2014-06-03
Posts: 615

Re: Incorrect displaying hidden scrollbar and opening files

The new version has been released at: https://reogrid.net/download

From 1.1 the freeze settings will also be saved and loaded into/from Excel file.

Offline

#7 2016-02-17 10:25:18

genI3
Member
From: Russia
Registered: 2016-01-29
Posts: 6

Re: Incorrect displaying hidden scrollbar and opening files

I'm not sure that it is necessary to open a new topic, so I continue here.
In version 1.1.0:
1. When I hide the horizontal scrollbar and SheetTabControl during application startup - a vertical scrollbar does not stretch to the height of the grid control. Also there is a small flaw - a few pixels scrollbar gets out of the grid control border. Horizontal scrollbar also does not stretch to the widht of the grid control, if I not hide it.
230a8968ba.jpg
015124d1ef.png
2. When I hide horizontal scrollbar at application startup and hide SheetTabControl at runtime - I have the white space at the bottom of the control again (what disappears at not known events). Try to return SheetTabControl in the same time is bound to fail.
3. MemoryWorkbook not opening files with frozen cells now, is it possible to expect a change in this fact at the next releases?

Last edited by genI3 (2016-02-17 10:26:09)

Offline

#8 2016-02-17 14:47:49

Jingwood
Moderator
From: jing at reogrid.net
Registered: 2014-06-03
Posts: 615

Re: Incorrect displaying hidden scrollbar and opening files

OK I will release update version for fixing these problem soon. Thanks.

Offline

#9 2016-02-27 08:34:26

Jingwood
Moderator
From: jing at reogrid.net
Registered: 2014-06-03
Posts: 615

Re: Incorrect displaying hidden scrollbar and opening files

Version 1.2 fixes these problems.

Border extra padding pixel has been removed.
346.png

When hide horizontal scroll-bar, sheet tab expended to full width.
351.png

When hide both horizontal scroll-bar and sheet tab, vertical scroll-bar expended to full height.
348.png

When sheet tab hidden, horizontal scroll-bar expended to full width.
347.png

When vertical scroll-bar hidden:
349.png

When all scroll-bars and sheet tab hidden:
350.png

Release package will be available within two days.

Offline

#10 2016-02-27 15:11:53

Jingwood
Moderator
From: jing at reogrid.net
Registered: 2014-06-03
Posts: 615

Re: Incorrect displaying hidden scrollbar and opening files

This problem has been fixed in version 1.2, which can be downloaded from: https://reogrid.net/download. Thanks for reporting!

Offline

#11 2016-02-29 06:30:23

genI3
Member
From: Russia
Registered: 2016-01-29
Posts: 6

Re: Incorrect displaying hidden scrollbar and opening files

Thank you! Everything works fine!

Offline

Board footer

Powered by FluxBB