Using lightweight references to present a worksheet
Using lightweight references to present a worksheet including receiving, from a first user account, a request for a worksheet presenting a data set from a database, wherein the worksheet was generated by a second user account; determining that the request was not generated from the second user account; and in response to the determination that the request is not from the second user account, presenting the worksheet in a view mode, wherein permissions in the view mode prevent destructive edits to the worksheet and allow additive edits to the worksheet.
1. A method of using lightweight references to present a worksheet, the method comprising:
receiving, from a first user account, a request for a worksheet presenting a data set from a database, wherein the worksheet was generated by a second user account;
determining that the request was not generated from the second user account by determining that user account information associated with the request differs from user account information associated with ownership of the worksheet; and
in response to the determination that the request is not from the second user account, presenting the worksheet in a view mode,
wherein permissions in the view mode prevent viewing hidden columns in the worksheet and changing an existing filter in the worksheet, and
wherein the permissions in the view mode allow adding filters to the worksheet and adding columns to the worksheet.
2. The method of claim 1 , further comprising:
receiving, from the first user account, a request to modify a hierarchy in the worksheet; and
denying the request to modify the hierarchy in the worksheet based on the permissions in the view mode.
3. The method of claim 1 , further comprising:
receiving, from the first user account, a request to add a column to the worksheet; and
allowing the request to add the column to the worksheet based on the permissions in the view mode.
4. The method of claim 3 , further comprising:
receiving, from the first user account, a subsequent request to save changes to the worksheet as a new worksheet; and
allowing the subsequent request to save the changes to the worksheet as the new worksheet based on the permissions in the view mode.
5. The method of claim 1 , wherein the worksheet comprises a level hierarchy with at least one level collapsed, and wherein presenting the worksheet in the view mode comprises hiding data in the at least one collapsed level.
6. The method of claim 1 , wherein presenting the worksheet in the view mode comprises:
retrieving worksheet metadata for the worksheet using a reference to the worksheet metadata in the request;
creating, using the worksheet metadata, a lightweight referencing worksheet presenting at least a subset of the data set presented in the worksheet; and
presenting the lightweight referencing worksheet in the view mode with permissions that prevent destructive edits to the lightweight referencing worksheet and allow additive edits to the lightweight referencing worksheet.
7. An apparatus for using lightweight references to present a worksheet, the apparatus comprising a computer processor, a computer memory operatively coupled to the computer processor, the computer memory having disposed within it computer program instructions that, when executed by the computer processor, cause the apparatus to carry out the steps of:
receiving, from a first user account, a request for a worksheet presenting a data set from a database, wherein the worksheet was generated by a second user account;
determining that the request was not generated from the second user account by determining that user account information associated with the request differs from user account information associated with ownership of the worksheet; and
in response to the determination that the request is not from the second user account, presenting the worksheet in a view mode,
wherein permissions in the view mode prevent viewing hidden columns in the worksheet and changing an existing filter in the worksheet, and
wherein the permissions in the view mode allow adding filters to the worksheet and adding columns to the worksheet.
8. The apparatus of claim 7 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
receiving, from the first user account, a request to modify a hierarchy in the worksheet; and
denying the request to modify the hierarchy in the worksheet based on the permissions in the view mode.
9. The apparatus of claim 7 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
receiving, from the first user account, a request to add a column to the worksheet; and
allowing the request to add the column to the worksheet based on the permissions in the view mode.
10. The apparatus of claim 9 , wherein the computer program instructions further cause the apparatus to carry out the steps of:
receiving, from the first user account, a subsequent request to save changes to the worksheet as a new worksheet; and
allowing the subsequent request to save the changes to the worksheet as the new worksheet based on the permissions in the view mode.
11. The apparatus of claim 7 , wherein the worksheet comprises a level hierarchy with at least one level collapsed, and wherein presenting the worksheet in the view mode comprises hiding data in the at least one collapsed level.
12. The apparatus of claim 7 , wherein presenting the worksheet in the view mode comprises:
retrieving worksheet metadata for the worksheet using a reference to the worksheet metadata in the request;
creating, using the worksheet metadata, a lightweight referencing worksheet presenting at least a subset of the data set presented in the worksheet; and
presenting the lightweight referencing worksheet in the view mode with permissions that prevent destructive edits to the lightweight referencing worksheet and allow additive edits to the lightweight referencing worksheet.
13. A computer program product for using lightweight references to present a worksheet, the computer program product disposed upon a non-transitory computer readable medium, the computer program product comprising computer program instructions that, when executed, cause a computer to carry out the steps of:
receiving, from a first user account, a request for a worksheet presenting a data set from a database, wherein the worksheet was generated by a second user account;
determining that the request was not generated from the second user account by determining that user account information associated with the request differs from user account information associated with ownership of the worksheet; and
in response to the determination that the request is not from the second user account, presenting the worksheet in a view mode,
wherein permissions in the view mode prevent viewing hidden columns in the worksheet and changing an existing filter in the worksheet, and
wherein the permissions in the view mode allow adding filters to the worksheet and adding columns to the worksheet.
14. The computer program product of claim 13 , wherein the computer program instructions further cause the computer to carry out the steps of:
receiving, from the first user account, a request to modify a hierarchy in the worksheet; and
denying the request to modify the hierarchy in the worksheet based on the permissions in the view mode.
15. The computer program product of claim 13 , wherein the computer program instructions further cause the computer to carry out the steps of:
receiving, from the first user account, a request to add a column to the worksheet; and
allowing the request to add the column to the worksheet based on the permissions in the view mode.
16. The computer program product of claim 15 , wherein the computer program instructions further cause the computer to carry out the steps of:
receiving, from the first user account, a subsequent request to save changes to the worksheet as a new worksheet; and
allowing the subsequent request to save the changes to the worksheet as the new worksheet based on the permissions in the view mode.
17. The computer program product of claim 13 , wherein the worksheet comprises a level hierarchy with at least one level collapsed, and wherein presenting the worksheet in the view mode comprises hiding data in the at least one collapsed level.
18. The computer program product of claim 13 , wherein presenting the worksheet in the view mode comprises:
retrieving worksheet metadata for the worksheet using a reference to the worksheet metadata in the request;
creating, using the worksheet metadata, a lightweight referencing worksheet presenting at least a subset of the data set presented in the worksheet; and
presenting the lightweight referencing worksheet in the view mode with permissions that prevent destructive edits to the lightweight referencing worksheet and allow additive edits to the lightweight referencing worksheet.