microsoftgraph / microsoftgraph/msgraph-sdk-dotnet

[Client bug]: Missing methods for workbook range resource type in v5

Open
#1,873 13 comments 1 reaction 1 assignee View on GitHub

@andrueastman is already working on this.

Since Oct 6, 2023.

Bug Bug: metadata OpenApi
Dominant language
C#
Stars
789
Forks
264
Avg merge
15h 17m
Merged PRs (30d)
3

Description

Describe the bug
In the current version 5.9.0 users can get a set of one or more workbook cells.

There is no way to update/insert/delete/merge/unmerge/clear range and get/update range format.

API calls

GET /me/drive/items/{id}/workbook/worksheets/{id|name}/range(address='<address>')
GET /me/drive/root:/{item-path}:/workbook/worksheets/{id|name}/range(address='<address>')
GET /me/drive/items/{id}/workbook/tables/{id|name}/columns/{id|name}/range
GET /me/drive/root:/{item-path}:/workbook/tables/{id|name}/columns/{id|name}/range

v5 client methods

graphClient.Drives["driveId"].Items["itemId"].Workbook.Names["name"].Range.GetAsync()
graphClient.Drives["driveId"].Items["itemId"].Workbook.Tables["tableName"].Range.GetAsync()
graphClient.Drives["driveId"].Items["itemId"].Workbook.Worksheets["worksheet"].Range.GetAsync()

There is a RangeRequestBuilder class in different namespaces.

Microsoft.Graph.Drives.Item.Items.Item.Workbook.Names.Item.RangeNamespace.RangeRequestBuilder
Microsoft.Graph.Drives.Item.Items.Item.Workbook.Tables.Item.Columns.Item.RangeNamespace.RangeRequestBuilder
Microsoft.Graph.Drives.Item.Items.Item.Workbook.Tables.Item.RangeNamespace.RangeRequestBuilder
Microsoft.Graph.Drives.Item.Items.Item.Workbook.Tables.Item.Rows.Item.RangeNamespace.RangeRequestBuilder
Microsoft.Graph.Drives.Item.Items.Item.Workbook.Worksheets.Item.Names.Item.RangeNamespace.RangeRequestBuilder
Microsoft.Graph.Drives.Item.Items.Item.Workbook.Worksheets.Item.RangeNamespace.RangeRequestBuilder
Microsoft.Graph.Drives.Item.Items.Item.Workbook.Worksheets.Item.Tables.Item.Columns.Item.RangeNamespace.RangeRequestBuilder
Microsoft.Graph.Drives.Item.Items.Item.Workbook.Worksheets.Item.Tables.Item.RangeNamespace.RangeRequestBuilder
Microsoft.Graph.Drives.Item.Items.Item.Workbook.Worksheets.Item.Tables.Item.Rows.Item.RangeNamespace.RangeRequestBuilder

All RangeRequestBuilder classes are missing methods for the following endpoints

update range
insert range
delete range
merge range
unmerge range
clear range
get range format
update range format
bounding rect
cell
column
columns after
columns before
entire row
intersection
last cell
last column
last row
offset range
row
rows above
rows below
used range
resized range
visible view

To Reproduce
Steps to reproduce the behavior:

  1. Check all RangeRequestBuilder classes.
  2. There is only GetAsync() method
  3. Other methods are missing

Expected behavior
All RangeRequestBuilder classes contains all methods.

Client version
5.9.0

Desktop (please complete the following information):

  • OS: Windows 11

Additional context
Add any other context about the problem here.

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.