Skip to content

How can we improve Proton Drive?

← Proton Drive

Proton Sheets - Formulas ex ods/xlsx files returns errors

Doing a copy/paste from an ods/xlsx file returns errors where formulas where introduced (#Name!]...
... and it doesn't overtake the formatting (bold, underline, etc.).

It's better to start from scratch when it goes about formulas/formatting.

3 votes

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Cedric shared this idea  ·   ·  Report…  ·  Admin →

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Susan Hopkins commented  ·   ·  Report

    Not sure if this will work for every situation, but I just fixed it after changing one setting. When proton sheets document is open, I selected File > Settings > Locale > and switched from the default which was auto United States, and switched it to United States.

    Then I imported my file, and unchecked the option for it to "Convert text to numbers, dates, and formulas".

    All of the errors that showed as #NAME? anytime there was a $ with a - - all showed up properly! Hope this helps others :)

Proton Drive: New feature

Categories