394 reputation
1314
bio website
location
age
visits member for 4 years, 1 month
seen Aug 11 at 21:14

Sep
14
awarded  Popular Question
Jul
7
awarded  Famous Question
Jul
4
awarded  Curious
Jul
3
comment Is there a way to scroll, by pixel, instead of by cell, in either Excel or OpenOffice Calc?
Sharepoint isn't free software, it even has a monthly subscription system. Excel is ubiquitous. We get random student workers, sometimes in different states depending on who we're working with, and often email is our only contact. We can't rely on them to have Excel, but they can get OpenOffice easily, or Google Docs. SharePoint must be used "just so", with a proper browser, or edit histories and other things are lost. It's much easier to manage an individual file and keep old versions neatly organized as necessary.
Jul
3
comment Is there a way to scroll, by pixel, instead of by cell, in either Excel or OpenOffice Calc?
It seems that in Apple iWorks Numbers, smooth scrolling was available. And in Google Docs, when you click File > "See Revision History", smooth scrolling is available, but not when editing.
Jul
3
comment Is there a way to scroll, by pixel, instead of by cell, in either Excel or OpenOffice Calc?
Yeah, I just realized that.
Jul
3
comment Is there a way to scroll, by pixel, instead of by cell, in either Excel or OpenOffice Calc?
SharePoint won't do what I need. The spreadsheets are nice, because I can always dump them into a database, or create them from a database as a CSV file. Oh, and that middle mouse button thing only works while scrolling... once you let the button go, it snaps back to whole cells :(
Jul
3
comment Is there a way to scroll, by pixel, instead of by cell, in either Excel or OpenOffice Calc?
Thanks! I will check out SharePoint.
Jul
3
comment Enable smooth scrolling in Excel for large cells
Charlie, that would make sense if it was impossible to scroll smoothly, but it's not a problem with the rendering engine, because clearly you can scroll smoothly with middle mouse button. It's not like the grid is ridgidly fixed in the upper left and they're just shifting cell contents into that static grid. The middle mouse button smooth scrolling proves that's not the issue. This is simply a design flaw, in that the scrollbars always force it to jump to the next cell. The behavior could easily be switched off, they just don't make it an option.
Jul
3
answered Is there a way to scroll, by pixel, instead of by cell, in either Excel or OpenOffice Calc?
Jul
3
comment Is there a way to scroll, by pixel, instead of by cell, in either Excel or OpenOffice Calc?
Lol, you CAN scroll smoothly if you use the middle mouse button. Problem solved.
Jul
3
comment Is there a way to scroll, by pixel, instead of by cell, in either Excel or OpenOffice Calc?
Hmmm.... this may be a duplicate of: superuser.com/questions/47908/…
Jul
3
comment Is there a way to scroll, by pixel, instead of by cell, in either Excel or OpenOffice Calc?
superuser.com/questions/47908/…
Jul
3
comment Is there a way to scroll, by pixel, instead of by cell, in either Excel or OpenOffice Calc?
It's the best tool for the job right now. It exists, it stores data in a grid. It allows for calculations and comparisons of cell content, auto numbering, easy to rearrange rows by dragging. Has sheet tabs allowing us to have a separate named sheet for each lesson. It's a common format, editable by many programs. Word doesn't do anything remotely close to that. If you actually have a better tool in mind, let me know. We don't have the funding or time to develop an online, database-backed application, which would be ideal. So again.. if you know of an existing tool, please let me know.
Jul
3
comment Is there a way to scroll, by pixel, instead of by cell, in either Excel or OpenOffice Calc?
PDF isn't editable and interrupts the workflow. I could take a screenshot and scroll it in paint too. That doesn't help. I'm going to build it into Google Docs spreadsheet using the Maps algorithm for displaying an infinite number of adjacent cells. I'll wait forever for Microsoft to do anything.
Jul
3
comment Is there a way to scroll, by pixel, instead of by cell, in either Excel or OpenOffice Calc?
And that is utterly irrelevant, because I find the snapping to cells while scrolling irritating, even for cells with "normally sized" contents.
Jul
3
asked Is there a way to scroll, by pixel, instead of by cell, in either Excel or OpenOffice Calc?
Jun
16
awarded  Nice Answer
Jun
1
comment Why does remote desktop screen go black and stay that way for a minute whenver I restore a window from a maximized state, or maximize the window?
Thanks. This works. It's annoying to have to do it, but it does force the window to redraw and begin rendering again. Interestingly, after clicking cancel and resuming work on the desktop, when I resize the window, instead of the screen going black, it shows the old cached copy of the Ctrl+Alt+End screen. Pressing Ctrl+Alt+End again seems to wake it up. I just wonder why this is happening whereas it never was a problem before. This just makes me wnat to use VLC and downgrade to XP. Still not touching Windows 8 until they bring back Aero Glass.
Jun
1
comment Why does remote desktop screen go black and stay that way for a minute whenver I restore a window from a maximized state, or maximize the window?
That's what I ended up doing, but it's nowhere near as smooth as desktop composition, and when you're developing an app which specifically uses the Aero Glass effects, and even switched the whole thing over to WPF since WinForms doesn't handle the alpha channel on controls correctly... turning off composition really kills the experience. It's like reverting to Windows XP. Glad I'm not the only one who has observed this behavior when resizing the window.