The Lounge - CodeProject

Dan Neely19-Aug-15 3:30

19-Aug-15 3:30

Not quite. In 2013 you don't have the all spreadsheets in a process share the same top level window limitation. You DO however still have all the other all spreadsheets are in a single process limitations; and out of the box 2013 is worse in this regard in some ways. Notably, and this is one that would enrage me enough at times that even when I didn't need to look at two XLSs at the same time I'd run multiple processes, all spreadsheets in a single process ahare a single undo buffer. Meaning that if you:

0) Open 2 spreadsheets.
1) Make a change in file 1.
2) Make a change in file 2.
3) Make a change in file 1.
4) Hit under twice in file 1.

Will undo the 2nd change in file 1, the only change in file 2, but still have the first change in file 1. This generally would bite me when I started editing a table and realized I was making enough changes that instead of being able to comfortably show them with strikeouts/different font colors (Word style track changes in Excel please).

With 2010 and prior I'd open a new temp XLS in a different process paste the updated table to it. Hammer undo in the original, and then paste the updated one back next to the original.

2013 broke this workflow. By default it has a helpful feature where if it sees you have two excel processes running it combines them into one and terminates the second without closing any of your files. This does have some benefits because copy/pasting between processes loses some things that can be copied within a process (although why they couldn't just make in/out process copy/paste work the same is beyond me) and reduces resource requirements; but it wrecked my workflow and initially left me thinking that the only workaround was to save my temp to disk so I could subvert the retarded unified undo buffer.

Eventually I found out there was a flag /X I could pass the shortcut on my taskbar to force it to launch a new process that wouldn't be merged instead of cluttering my computer up with temps I'd never remember to delete.

Did you ever see history portrayed as an old man with a wise brow and pulseless heart, waging all things in the balance of reason?
Is not rather the genius of history like an eternal, imploring maiden, full of fire, with a burning heart and flaming soul, humanly warm and humanly beautiful?
--Zachris Topelius

Training a telescope on one’s own belly button will only reveal lint. You like that? You go right on staring at it. I prefer looking at galaxies.
-- Sarah Hoyt

Re: MSOffice and multiple screens

Bassam Abdul-Baki20-Aug-15 14:00

Bassam Abdul-Baki

20-Aug-15 14:00

Undo does suck in multiple Excel files.

Web - BM - RSS - Math - LinkedIn

Suggested Name for Android 7

Power Puff Boy18-Aug-15 22:22

Power Puff Boy

18-Aug-15 22:22

The name for Android 6 has been announced: Marshmallow. Let's look ahead and start planning the future: Android 7.

I suggest Android F. F as in 'Froot Loop'.
Any better ideas?

Kitty at my foot and I waAAAant to touch it...

modified 19-Aug-15 6:25am.

Welcome to the Lounge

“That which can be asserted without evidence, can be dismissed without evidence.”