Re:The worst of the two worlds: Excel meets Outlook
by kh1 on Sunday February 14, 2021 @12:07AM
(#26129861)
True. The problem is people share the bug tracking spreadsheet over email, and you have to find out the latest version from inbox. I still don't know what the best solution could be for both business people and IT people.
For word documents, I write in markdown and check in to git which allows me to compare the difference, etc. And I use pandoc when I distribute it as a proper document.
Re:The worst of the two worlds: Excel meets Outlook
by jasdine817 on Sunday February 14, 2021 @07:05AM
(#26131674)
People do this in my company even despite us having SharePoint which has decent enough support for collaborative capabilities and should in theory get rid of any need for different document versions, but that escapes many people.
Re:The worst of the two worlds: Excel meets Outlook
by aksss on Sunday February 14, 2021 @01:54PM
(#26134995)
This seems like a conversation from 2010. I'm not saying that to insult, but it's literally the kind of conversation I was having in a corporate environment 10+ years ago.
Now, why can't you just share the link to the Excel spreadsheet and work collaboratively on the same document? If it's stored in SharePoint or OneDrive, this is trivial. There's a "Share" button in the top right corner, and you can do it from Windows Explorer as well. There's little value in emailing versions around anymore, particularly internally.
Re:The worst of the two worlds: Excel meets Outlook
by higerordermap on Sunday February 14, 2021 @02:09AM
(#26130318)
A shared Google sheet works well for most people.
Re:The worst of the two worlds: Excel meets Outlook
by unnouinceput on Sunday February 14, 2021 @07:43AM
(#26131925)
Your example is a bad one in regards to users, be it devs or otherwise, but is a good example of how half-backed software is then given as example. In your case, if the goal was to only get values from dropdown, then make those cells behave properly. Constraints are easy to implement to allow only get values from dropdown and no typing allowed.
So I'd blame the original developer of said Excel form instead of its dev users.
Re:The worst of the two worlds: Excel meets Outlook
by byhemechi on Sunday February 14, 2021 @05:37PM
(#26136953)
What you say about word processors is pretty accurate. I'm pretty sure I can use word well enough, but I always just end up writing markdown because it's pretty much impossible to screw up the formatting with that.
Re:The worst of the two worlds: Excel meets Outlook
by hackerbrother on Sunday February 14, 2021 @09:01AM
(#26132433)
Ha! I literally did just learn about column filters the other day, after many years of coding.
For exampe: We used it once as a bug tracking tool and all business people could easily work with it while developers didn't understand that they should use the drop-downs in the cells to define the status and not type something in the cell. We had to continously fix the sheet and explain the developers. While they were complaining about Excel,it was obvious that the lack of basic knowledge of how to use it properly was just lacking.
The same is true even to a greater extent for Word processors. Only a small part of the users can properly format a document with a correct usage of headings and sections.