I have a requirement to create an application in SharePoint 2010 where the user interface presented is like a grid/spreadsheet. But each cell in the grid needs to represent a SharePoint item in a SharePoint list in the background.
Each cell will record data such as comments, a time and a colour (the colour is important for the UI as it links back to a project). I know about data sheet view but this does not have all the functionality that is needed for a slick UI.
I have seen some web based grids like jqxGrid but I don't know how to implement the one cell to one list item relationship in the application in this frameworks.
Or I could try SPGridView but this may not go far enough to create a slick UI that is required.
Could somebody give me some direction or suggestions/help please?