ReoGrid Forum
You are not logged in.
- Topics: Active | Unanswered
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.
#1 2015-01-18 20:49:24
- boldtm
- Member
- Registered: 2015-01-18
- Posts: 7
A few issues...
Hi, Jing!
When formula refers to empty cell (eg. =A3+A4 and A4 is empty), result is empty cell, in the other hand SUM function in formula gives proper results treating empty cell value as zero.
Sole "d" as DateTime pattern in format settings window (ReoGridEditor) is ignored instead of showing number of day, but adding another character to pattern eg. space returns adequate results.
It seems that setting borders to get crossed cell isn't working, even though such options exists in ReoGridEditor cell settings' window
Version: 0.8.8.3
-boldtm
PS. ReoGrid is great! 
Last edited by boldtm (2015-01-19 00:18:19)
Offline
#2 2015-01-19 08:54:08
- Jingwood
- Moderator
- From: jing at reogrid.net
- Registered: 2014-06-03
- Posts: 615
Re: A few issues...
Hi boldtm, Thanks! Hope you like it.
1 and 2: These problems will be resolved in next release.
3: Diagonal line in cells currently has not been supported, it has low priority.
There is a bypass method to implement similar effect, by using the owner draw feature of Custom Cell Body
best, Jing
Offline
#3 2015-01-23 07:39:38
- Jingwood
- Moderator
- From: jing at reogrid.net
- Registered: 2014-06-03
- Posts: 615
Re: A few issues...
For issue 1: 0.8.8.4 introduced new extension into FormulaExtension class:
FormulaExtension.EmptyCellReferenceProviderDefinition:
Func<Worksheet, ReoGridPos, ReoGridCell, object> EmptyCellReferenceProvider { get; set; }This provider will be invoked when formula refers to a cell that is empty or null. Let this property as null will use number zero in formula calculation. In other case users could use this provider to return a null or any desired values in their applications.
Offline