cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Announcements
Musicians, convert your MuseScore files to PDF to play music on the go! Learn more here.

Integrations

Find solutions to issues with third-party integrations from the Dropbox Community. Share advice and help members with their integration questions.

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Spreadsheet Functionality

Spreadsheet Functionality

Charlie W.6
New member | Level 2

Problem: While Dropbox Paper is rich with productivity features, it lacks the ability to perform tabular (cell-based, row/column) calculations, requiring customers to use an external application and often have their data cached outside of Dropbox.

 

Solution: Integrate basic arithmetic into Dropbox Paper's table feature, and explore developing a separate spreadsheet application.

  1. Integration idea: add math statements to Paper's tables, based on orientation from current cell or using a coordinate system.
    1. Orientation from current cell example, calculate using a value from one cell over from the LEFT(L):
      1. Orientation could be: Above (A), Below (B), Left (L), Right (R)
      2. Caffeine calculation for OZ value: =(L1*11.8)
      3. DATEOZCAFFEINE
        08/14/2325295
    2. Coordinate system (traditional spreadsheet ColRow) example:
      1. C2 cell calculation: =(B2*11.8)
      2.  ABC
        1DATEOZCAFFEINE
        208/14/2325295
    3. The syntax is similar with both, but the underlying approach is different based on Dropbox developer preference.
      1. Sum a column of cells:
        1. Orientation method: =(A10:A1)
        2. Coordinate method: =(C1:C10)
      2. Calculate various cells:
        1. Orientation method: =(L1*RA3)
        2. Coordinate method: =(C3*F15)

Comments: Developing, supporting, and growing a separate spreadsheet application is a large task and can be a slippery slope with scope creep, and create competition with existing partnerships. By beginning with adding basic arithmetic into Paper's table feature, Dropbox can benefit from monitoring usage and feedback to determine which spreadsheet functions should be prioritized for their customers. In the end, customers may only need more sophisticated Paper table features, and not a full-blown spreadsheet application.

 

Note: The orientation method seems overly complicated from a development and usage perspective, but I thought it might spark some other ideas or conversation in the comment section.

1 Reply 1

Megan
Dropbox Staff

Hi @Charlie W.6, I hope you're doing well! 

 

Your feedback regarding Paper has been very valuable and I will endeavor to make sure your voice is heard.

 

I will pass on your comments to the relevant departments so that we can further improve our product.

 

If you need anything else, let me know! 


Megan
Community Moderator @ Dropbox
dropbox.com/support


Heart Did this post help you? If so, give it a Like below to let us know.
:arrows_counterclockwise: Need help with something else? Ask me a question!
:pushpin: Find Tips & Tricks Discover more ways to use Dropbox here!
:arrows_counterclockwise: Interested in Community Groups? Click here to join!

Need more support?
Who's talking

Top contributors to this post

  • User avatar
    Megan Dropbox Staff
What do Dropbox user levels mean?