UWP excel style grid

Question

0.00/5 (No votes)

See more:

I'm currently converting a reasonably complex excel spreadsheet calculation tool to UWP.

From my online research there is no 'grid' in the traditional sense under UWP, unless you use a third party tool like Syncfusion.

I currently have several Grids (5 rows x 49 columns), however as XAML Binding doesn't map to Dictionaries well, I've had to create a property per 'cell' to bind (245 properties per grid), not to mention all of the OnPropertyChanged calls.

I've done one grid and it works fine - however I've got another 4 to implement, then another 5 (14 x 49) data entry grids.

This seems like a LOT of effort, so I can't help but think I've missed something and that there must be an easier way.

Does anyone have any suggestions?

Thanks in advance.

What I have tried:

Sledge hammer approach - property & textbox grid per cell. I've unsuccessfully tried using a Collection and Converter.

Posted 6-Mar-17 13:53pm

Rodimus74

Updated 6-Mar-17 14:59pm

Add a Solution

Comments

johannesnestler 7-Mar-17 9:57am

have you questioned why there is no "DataGrid" in UWP Standard controls? Because I had the same "problem" I thought a little about it... my conclusion: Because it is really difficult to provide a Control with (from user perspective) expected behaviour on all supported platforms (just try it with minimal resolution on a phone...). I ended with a simple listbox and a DataTemplate for one row (per visualstate), and a Header Control to set sort direction... Maybe I try the telerik lib recommendet by Graeme_Grant - the others I tried, didn't meet my expectations... just my 2c

Rodimus74 8-Mar-17 19:12pm

Thank you, yes I did question the UI. But the simple fact is, the data is row/column data - so a excel like component is the most appropriate.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Graeme_Grant · Accepted Answer · 2017-03-06T14:59:00

Telerik's commercial UWP control suite very recently went Open Source (ie: free) and has a powerful Grid control:
* Website: UI for Universal Windows Platform, Windows 10 UI | Telerik[^]
* Github: telerik/UI-For-UWP: This repo contains the source code for Telerik UI for Universal Windows Platform (UWP), which includes 20+ UI controls for developers building UWP applications.[^]

Syncfusion also have a commercial UWP control suite that you can use for free under the Community License:
* Website: Comprehensive collection of UWP controls including Chart, Gauge, map and date picker for developing Windows Store/metro style apps[^]
* Community License: 800+ Free controls and frameworks for .NET (Windows Forms, WPF, ASP.NET MVC, ASP.NET Web Forms, LightSwitch, Silverlight, Windows Phone, WinRT, Windows 8), iOS, Android, Xamarin and JavaScript platforms[^]

Microsoft also have a community-driven extended control suite that you might want to check out:
* Annoucement (with links): Microsoft releases UWP Community Toolkit 1.3, with new OneDrive and Surface Dial support and more - MSPoweruser[^]

UWP excel style grid

1 solution

Solution 1

Add your solution here

Preview 0

UWP excel style grid

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us