Steve Campbell4

Q: Warning at File opening

In my job I receive an Excel spreadsheet template from a vendor using windows machines.

 

Using Numbers 3.2.2, on opening the Excel file a warning dialog appears.  One item warns of a missing font and another item warns that the "sheet protection" has been removed.

 

My task is to enter data in certain cells and return the document to the vendor company who says they can't receive the document into their system because the sheet protection has been removed.

 

Is there any way to turn off, or otherwise disable, Numbers from automatically removing the sheet protection when the document launches?

 

Thanks for your help.

Steve

Posted on Sep 27, 2016 12:49 PM

Close

Q: Warning at File opening

  • All replies
  • Helpful answers

  • by Wayne Contello,Helpful

    Wayne Contello Wayne Contello Sep 27, 2016 2:32 PM in response to Steve Campbell4
    Level 6 (19,282 points)
    iWork
    Sep 27, 2016 2:32 PM in response to Steve Campbell4

    Steve,

     

    Numbers often removes features it does not support in excel.  If this is required for your job I suggest the best, and most reliable solution, is to acquire a legal copy of MS Excel for your computer.  You can try LibreOffice (which is free) to see if that will work.

  • by Steve Campbell4,

    Steve Campbell4 Steve Campbell4 Sep 27, 2016 2:41 PM in response to Wayne Contello
    Level 1 (9 points)
    iWork
    Sep 27, 2016 2:41 PM in response to Wayne Contello

    Thanks Wayne,  I downloaded OpenOffice and I'm fairly confident it doesn't play with sheet permissions.  I would hope Apple's design team could modify Numbers to at least allow unsupported features to bypass being stripped out automatically on loading the file.  Sheet protection is a low level activity that perhaps could be set aside during file modification and re-appended upon save?  Thanks again

  • by Wayne Contello,

    Wayne Contello Wayne Contello Sep 27, 2016 3:03 PM in response to Steve Campbell4
    Level 6 (19,282 points)
    iWork
    Sep 27, 2016 3:03 PM in response to Steve Campbell4

    Steve,

     

    1) you can always post direct feedback to Apple using the menu item "Numbers > Provide Numbers Feedback"

    2) Know that Numbers imports and excel file (meaning it translates the excel to Number) leads me to believe that the feature simply doesn't exist and so there is no way to "translate" feature.

     

    No-one here is an Apple employee... we are users like you.

     

    All the best,