Progress® Telerik® UI for Blazor Feedback Portal
Back to Feed
Request a Feature Report a Bug
Unplanned
Last Updated: 20 Nov 2024 13:10 by Jeremy
Jeremy
Created on: 12 Aug 2024 19:26
Category: Spreadsheet
Type: Feature Request
2
Define columns and rows in the markup

<TelerikSpreadsheet Height="500px" Width="100%">
    <SpreadsheetSheets>
        <SpreadsheetSheet Name="Sheet1">
            <SpreadsheetSheetColumns>
                <SpreadsheetSheetColumn Index="0" Width="100px"></SpreadsheetSheetColumn>
                <SpreadsheetSheetColumn Index="1" Width="200px"></SpreadsheetSheetColumn>
            </SpreadsheetSheetColumns>
            <SpreadsheetSheetRows>
                <SpreadsheetSheetRow Index="0">
                    <SpreadsheetSheetCell Value="Item"></SpreadsheetSheetCell>
                    <SpreadsheetSheetCell Value="Price"></SpreadsheetSheetCell>
                </SpreadsheetSheetRow>
                <SpreadsheetSheetRow Index="1">
                    <SpreadsheetSheetCell Value="Apples"></SpreadsheetSheetCell>
                    <SpreadsheetSheetCell Value="1.50"></SpreadsheetSheetCell>
                </SpreadsheetSheetRow>
                <SpreadsheetSheetRow Index="2">
                    <SpreadsheetSheetCell Value="Bananas"></SpreadsheetSheetCell>
                    <SpreadsheetSheetCell Value="2.00"></SpreadsheetSheetCell>
                </SpreadsheetSheetRow>
            </SpreadsheetSheetRows>
        </SpreadsheetSheet>
    </SpreadsheetSheets>
</TelerikSpreadsheet>

6 comments
Jeremy
Posted on: 20 Nov 2024 13:10
Tsvetomir, how am I supposed to Document Processing in a web environment with Blazor, are there examples?  I looked at the Github repos and it only shows XAML files.  Any help would be appreciated because this component is still useless to anyone that needs advanced spreadsheet capability.  Wijmo is not preferred, but is required at this point.
ADMIN
Tsvetomir
Posted on: 04 Sep 2024 10:58

Hello Jeremy,

Thank you for providing more information about your scenario and for your patience while we were reviewing the request.

As a result of a discussion with the team, we've agreed that such an enhancement in the Spreadsheet component should be implemented in the future. With that being said, I'm changing the status of the feature request to "Unplanned". As a creator, you are automatically subscribed to get further status updates.

For the time being, a possible workaround is to:

  1. Use the Telerik Document Processing Libraries to create an Excel file.
  2. Convert the generated Excel file into byte[].
  3. Pass it to the Spreadsheet component.

Regards,
Tsvetomir
Progress Telerik

Love the Telerik and Kendo UI products and believe more people should try them? Invite a fellow developer to become a Progress customer and each of you can get a $50 Amazon gift voucher.

Jeremy
Posted on: 19 Aug 2024 18:12
Adding additional details.  I am looking for something like the Telerik.Web.Spreadsheet from the Aspnet.Core project where there is a Fluent implementation and Models for Workbooks, Sheets, Rows, Columns and Cells.  The Blazor UI only seems to define Toolbars and Events in CS and relies heavily if not entirely on the JavaScript (Kendo) implementation.  Using C# to generate spreadsheets is required for us and I don't see any way to make that work, if I am missing something please let me know, but I expected the implementation to be similar to the Aspnet.Core approach, waited all of this time for the release and then can't really use it.
Jeremy
Posted on: 19 Aug 2024 16:46
We need the ability to define the sheet programmatically because we currently use Wijmo spreadsheet and generate the actual document from structured data that is in a database.  Specifically, If I have a list of say Account Numbers, I want to take that list and create a Row for every account number, then I may want to show Period Balances and have those values populate the columns for each row from our Ledger Data.  Let me know if you need additional information.
Jeremy
Posted on: 19 Aug 2024 16:43

Tsvetomir from what I can tell there is no ability to define a spread sheet programmatically in c# either via code or using a Template.  From the examples on the site and my own testing, the spreadsheet is loaded from a file and then saved as a file.  I do not see a way to define a spreadsheet and it's underlying structure from a data store where the data store defines the sheets, rows, columns and formulas.  The markup I provided was an example. 

ADMIN
Tsvetomir
Posted on: 16 Aug 2024 07:23

Hello Jeremy,

Thank you for reaching out! Based on the code snippet you've shared, it seems you're trying to hardcode specific values directly into the Telerik Spreadsheet component by defining columns and rows in the markup. We want to make sure we fully understand your goals with this feature request.

To better assist you, could you please provide more details by answering the following questions:

  • What specific problem or need are you addressing by defining columns and rows directly in the markup?
  • How do you plan to use these hardcoded values within your application's workflow?
  • What outcomes or benefits are you hoping to achieve with this approach?

Your responses will help us better understand your requirements, and we'll discuss them with our team to determine if this feature request aligns with our development plans. I look forward hearing back from you.

Regards,
Tsvetomir
Progress Telerik

Do you have a stake in the designеr-developer collaboration process? If so, take our survey to share your perspective and become part of this global research. You’ll be among the first to know once the results are out.
-> Start The State of Designer-Developer Collaboration Survey 2024

Create an account Log In
View
Type
Status
Category