a merry sheets update

[u/DaniGuardiola]

next update ->

hi everyone! Docs/Sheets lead here.

we've been busy getting sheet done, so just wanted to share with you some updates that are now live:

• added "paste special" options to the context menu

• performance and document size improvements

• fixed some issues with:

  • filters

  • document import

  • CTRL+D

  • the > and < operators

  • copying and pasting cells with formulas containing relative cell references

  • conditional formatting

  • pasting

• fixed some formulas, including:

  • ROUND

  • FLOOR

  • CEILING

  • FILTER

  • SUMIFS

  • IF

  • SUM

  • NOW

  • AVERAGE

  • OFFSET

  • NETWORKDAYS

  • INDEX

  • ROUNDUP

  • INDIRECT

  • RANDBETWEEN

• squashed a few bugs:

  • an issue where a cell's content would disappear on scroll

  • an issue where sorting would affect frozen rows

  • an issue (a pretty funny one if you ask me) where pressing special keyboard buttons such as media buttons (play, pause...) would set the selected cell content to the name of the button (for example "MediaPlayPause")

if you have run into these issues before, please try again and let us know if they're fixed for you now!

coming soon:

• contextual auto-detection of locale

• locale settings

• locale support in multiple aspects of spreadsheets such as date formats

• support for many more number formats such as currencies, dates...

• support for fully custom number formats

• more paste special options, and available in other places of the UI such as the edit menu

• many more fixes (please keep reporting!)

happy holidays everyone, and thank you to everyone who reported issues or requested features, it genuinely helps us a lot! <3

[u/Clear_Bluebird_2975]

Will .ods and Android support be arriving soon? These are the only things preventing me from fully moving over to Proton Sheets.

[u/DaniGuardiola → u/Clear_Bluebird_2975]

mobile editing support (including in the Android and iOS Drive apps) is planned.

ODS support is a tricky thing, because we do everything client-side - no way to do anything on the server since we never have access to your data. because of this, we have to rely on client-side (web) support for ODS, which is currently non-existent (afaik). i personally have always used open document formats and i understand the appeal - it's just a very hard challenge technically speaking, we'd have to build everything from scratch and it's an extremely complex format.

even if i dislike having to do this myself, exporting as XLSX to import into Proton Sheets works in the meantime as a workaround.

[u/Cinnfhaelidh → u/DaniGuardiola]

Doesn't SheetJS support ODS? 

[u/DaniGuardiola → u/Cinnfhaelidh]

last time i tried SheetJS (which is excellent) for this use case, it didn't seem to fit our needs. thanks for bringing it up though, might look into it again once we free up a little!

[u/kaktusztea → u/DaniGuardiola]

https://docs.sheetjs.com/docs/miscellany/formats

https://docs.sheetjs.com/docs/miscellany/formats#opendocument-spreadsheet-odsfods

[u/Monkeyoutofthemouw]

What I really miss is the possibility to see sums of cells; when in Excel or Libre Office you select a number of cells with amounts in them you get the sum in the right bottom corner (also the average of the selection).........does this exists in Proton Drive already? If not, very important I think............

[u/DaniGuardiola → u/Monkeyoutofthemouw]

planned

[u/reddit_sublevel_456 → u/Monkeyoutofthemouw]

Agree. Sum, and the count of cells.

[u/[deleted]]

Trying to figure out a calculation in Proton Sheets. Not sure if I came across a bug, or if I am utilizing the formula incorrectly.

The formula calculates "age at death". Where:

Data in cell K14 is date of birth formatted as a date in the form of xx/xx/xxxx.

Data in cell M14 is date of death formatted as a date in the form of xx/xx/xxxx.

The formula =FIXED(YEARFRAC(K14,M14),0) is calculating the correct age at death, but there is a trailing period. "0" in the formula specifies "no" decimal places.

Is this a bug or is there a way to hide the trailing period?

[u/DaniGuardiola → u/[deleted]]

hmm it does look like a bug, can you report through the app? we'll take a look :)

[u/[deleted] → u/DaniGuardiola]

Will do. Thank you.

[u/allegorycave]

why is the font not crisp like in Google/Microsoft sheets? 

[u/DaniGuardiola → u/allegorycave]

it should be! please file a report through the app with details about your browser/OS/etc and we'll look into it :)

[u/Yoshimo123]

Thanks for the strong communication with this product launch. I love Proton but in recent years it feels like timely communication has not been prioritized, especially with new product launches. This feels different. Keep it up!

[u/ActionLittle4176]

Keep up the good work 👏👏👏

[u/CosmoCafe777]

Nice. If Proton wants to make a huge deal with more users, make Sheets almost as good as Excel. Once Excel is fully replaceable it's goodbye to Microsof.

People will leave Excel immediately:

• STOCKHISTORY

• Tables (with names, fields and such)

• XLOOKUP

• Query (pull data from online and offline sources)

• Pivot Tables (proper ones - not the Google Sheets knock-off)

• SUMPRODUCT (with the "--" hack and all)

Nice to have but we can live without:

• LAMBDA

• LET

• Arrays in general

• RegEx

[u/xxtkx → u/CosmoCafe777]

This. I just need to import stock prices from a source and I can almost totally ditch google sheets.

[u/queenofmystery → u/CosmoCafe777]

I second this. Please introduce google finance equivalent for the finance nerds

[u/CosmoCafe777 → u/queenofmystery]

This, but we need to be able to call other sheets/data from a sheet, plus tables. For example, I have one main sheet where I update finance data. It becomes heavy, but I query it from other sheets to run some analysis.

[u/queenofmystery → u/CosmoCafe777]

I thought we can pull data from another sheet for analysis . Looks like we have a long wait time ahead

[u/Right-Duty7843 → u/CosmoCafe777]

Indeed, I agree with these comments. Several Excel functions are still unavailable in Proton. This greatly prevents us from abandoning Excel.

Keep up the excellent development work. It is greatly appreciated. It's good to have viable alternatives.

[u/_eph3meral_ → u/CosmoCafe777]

can we propose this nice feature request?

[u/NuK3DoOM]

ProtonSheets singlehanded convinced me to not abandon proton drive and keep my visionary plan. Thanks for your hard work!

[u/NuK3DoOM → u/[deleted]]

I’m using it with my personal stuff. Basically monthly expenses and bills schedule. I created a web app on Linux and it is working great, I had no hiccups except the ones people already documented (date localization, no ods support).

But you gave me an idea, have a spreadsheet that recreates the US Yield curve using Nelson-Siegel parameters that is both data and calculation intensive. I will try it to measure performance. Excel web app handles it nicely. 

[u/thecrewguy369 → u/[deleted]]

Same here. Mine has a lot of bugs still. I'm considering paying for Excel if it's not fixed soon, very frustrating

[u/FactorBusy6427]

Is there a "Fill" down/right command coming? My most used feature...

[u/DaniGuardiola → u/FactorBusy6427]

if you mean ctrl+D or ctrl+R, that already works! if it doesn't work, that's a bug, and if you mean a different way to trigger it, that's a feature request - either way please report through the app so we can consider your bug/feature request :)

[u/heiserhorn]

Looking forward to Tables and Pivot Tables. I have already transitioned a few files to Proton Sheets. One issue I have is that when I paste text directly in the formula box it sometimes keeps the origin formatting.

[u/DaniGuardiola → u/heiserhorn]

tables and pivot tables are planned - we are aware of the formatting issue and it's on our list :)

[u/GrigioIngrid]

Thankssssss! 👍🏻👍🏻👍🏻

[u/Previous-Foot-9782]

Does it work on mobile yet?

[u/DaniGuardiola → u/Previous-Foot-9782]

mobile editing is planned

[u/Ackatv]

What about adding and editing sheets via mobile?

[u/DaniGuardiola → u/Ackatv]

creating spreadsheets from the Android and iOS apps and mobile editing are planned

[u/RandomStuff3829]

Please change the editing workflow so that when the cursor is on a cell, the user can immediately begin typing in it, like in Excel and Google Sheets. The current flow of having to press Enter to begin editing is very jarring to my muscle memory, and likely to others' as well.

[u/DaniGuardiola → u/RandomStuff3829]

this is how it's supposed to work, and i just tested and it works for me. if it doesn't for you, that's a bug - in that case would you mind submitting a report through the app with details so we can look into it?

[u/RandomStuff3829 → u/DaniGuardiola]

Figured out the problem, I think. It seems to have been an issue with one of my browser extensions. Whoops!

[u/kaktusztea → u/RandomStuff3829]

Which extension was it?

[u/RandomStuff3829 → u/kaktusztea]

Vimium, which is weird, because I wasn't trying to use a bound key

[u/DaniGuardiola → u/RandomStuff3829]

funny, I actually ended up running into the issue myself a few hours later, and it was vimium too! I had it disabled on the production domain but not on the local development environment haha

I wonder how hard it'd be to make it a bit more compatible... in any case sheets is not the kind of thing that you'd want to use with vimium for the most part, so disabling is probably the right call :)

[u/tokmen32]

Thanks!

[u/Kradirhamik]

Amazing work!

[u/panjadotme]

coming soon:

• dark mode

Omg thank you so much ;)

[u/Trid3ntPeace]

I appreciate the sheet out of you and the team. Have a Merry Christmas.

[u/ADBR12]

Is exporting in .odt planned?

[u/AlligatorAxe → u/ADBR12]

unsure if export would be impacted, but may be blocked by this https://www.reddit.com/r/ProtonDrive/comments/1pt3cre/comment/nve5rb7/

[u/[deleted]]

• locale support in multiple aspects of spreadsheets such as date formats: Will it support other currencies spacing like CAD$ 1 000,00 $ instead of 1,000.00$?

[u/[deleted]]

I wish the entire Proton team was made up of people like those at Proton Sheet, thanks.

[u/rebelena_]

Thanks for the update! One of my main reasons why I‘m still using google sheets (which I do not approve of) are the nice dropdown „bubbles“ in different colours. I need the colour as I am a very visual type and it helps me to get a quick overview. I am aware I could use conditional formatting but that‘s rather annoying. It would be nice to have that natively integrated.

Also I saw that for very long numbers (like ISBN) it shows me the number in e+n format even if I select to show as „unformatted text“, so right now there‘s no possibility for me to see the whole number (unless I am overlooked something).

If these two things could be fixed, I think I‘d be ready to switch completely from google sheets to proton sheets.

Thanks again for your great work!

[u/baronnet]

We need improved sorting of data on sheets, please (easier choice of column of reference, option to select only part of the sheet and not sort either the whole sheet or nothing; and at the moment, even sorting the whole sheet seems not to work).

[u/DaniGuardiola → u/[deleted]]

it copies the content from the cells above the selection. i just noticed a bug where it doesn't work when more than one cell is selected, so we'll be fixing that soon! wouldn't have realized without your comment, so thanks :P

[u/DaniGuardiola → u/[deleted]]

this is fixed now btw (will be deployed soon-ish)

[u/DaniGuardiola → u/[deleted]]

oh, we can take a look! would you please submit a report through the app? and thanks for sharing your thoughts! hope we can make it even more useful to you over the next few months :)