shared formulas not loaded in read_only mode

Issue #896 wontfix
Jonathan Clarke created an issue

As in the title: shared formulas are not loaded in read_only mode, but they do work otherwise (with read_only=False)...

As read_only mode is considerably faster for loading spreadsheets, it would be useful if it could support shared formulas - any pointers as to what is missing in the read_only worksheet implementation to make this work - or is it something that would affect load speed significantly?

Thanks!

Comments (3)

  1. CharlieC

    I don't think it would be easy to add this to the library. The OOXML file format for worksheets leaves a lot to be desired. Shared formulae are stored in the first cell of the range for which they're valid but neither random nor columnar access is advisable. If you know where the formulae are then you could write your own code for the unpacking.

  2. Log in to comment