ExceLint-addin icon indicating copy to clipboard operation
ExceLint-addin copied to clipboard

Reveal Structure sometimes doesn't work

Open richb-hanover opened this issue 3 years ago • 2 comments
trafficstars

See Updated info in the next comment


Describe the bug Using ExceLint on macOS 10.15.7, MS Excel Version 16.61.1 (22052000). I open the ExceLint addin, click Reveal Structure, and nothing gets highlighted.

Other spreadsheets (some quite complicated) work just as expected. I'm confused. Here's a screen recording on Youtube: https://youtu.be/OO3_9iOFHms

Please let me know what other troubleshooting information I could provide. Thanks.

To Reproduce Steps to reproduce the behavior:

  1. Watch video

Expected behavior Highlight similar formulas

Screenshots See Video

Desktop (please complete the following information):

  • OS: macOS 10.15.7
  • Browser - N/A-
  • Version Excel Version 16.61.1 (22052000)

Smartphone (please complete the following information):

  • Device: - N/A -
  • OS: [e.g. iOS8.1]
  • Browser [e.g. stock browser, Safari]
  • Version [e.g. 22]

Additional context Add any other context about the problem here.

richb-hanover avatar Jun 13 '22 12:06 richb-hanover

Update: When I click Reveal Structure I notice that top shows that the CPU of my MacBook goes to 100% with the process `com.apple.WebKit.WebContent' for a little over two minutes (2min, 12 sec).

At that point, the cells color in as expected in the Reveal Structure display. But...

  • Excel is frozen (spinning beach ball) and I cannot review the structure
  • htop shows Microsoft Excel is using ~100% of the CPU
  • Force Quit shows Excel is not responding
  • Force-quitting gets out of trouble, but of course I lose all the coloring information.

What other troubleshooting information could I provide? Thanks.

richb-hanover avatar Jun 13 '22 14:06 richb-hanover

Is this still an issue? (I'm assuming so but not sure.) If you can provide a spreadsheet so we can reproduce the issue, that'd be helpful.

emeryberger avatar Jun 05 '24 02:06 emeryberger