good jovi posted:The whiteboard paint is cool, but for some reason people LOVE using it on dark walls. There's like 4 markers that are actually visible on a dark wall, and only for the first few minutes before they dry out and become useless. Also you have to sand the wall REALLY well or erasing anything becomes a huge chore. It's better than those loving pieces of glass that some people insist on using as whiteboards. Use a pen on one and you can feel it die instantly in your hands
|
|
# ? Oct 11, 2018 20:14 |
|
|
# ? May 28, 2024 23:46 |
|
spog posted:Excel does that too.
|
# ? Oct 11, 2018 20:15 |
spog posted:Excel does that too. Not if you just open a CSV or other text format file directly. You have to use the External Data From Text (or Text to columns) function to actually get the text import wizard. Also do not ever deliver comma-separated files to international users and expect it to "just work" in Excel. If Windows is configured to use comma as decimal separator, as it's common in much of continental Europe, it will expect and write semicolon-separated files instead. If you just double-click a comma-separated CSV file in Explorer, it won't load properly in Excel. Tab-separated is better, but I don't think Excel sets up a file association for a tab-separated values type. (One module of our ERP system delivers files with .TSV extension, and I had to manually set up a file association for the few users depending on that module.) Honestly, if you're developing software and want to deliver spreadsheet data to users, do not fall in the trap of text-based formats. Write some OOXML or ODF files in proper format, and make sure cells have appropriate formats too. You'll be sure dates and numeric strings are handled properly, too, doing that. It's more work, but it delivers far more quality to end users.
|
|
# ? Oct 11, 2018 20:26 |
|
Thanks Ants posted:Excel does it if you File -> Open, but not if you got there by just double-clicking the CSV and having it open in Excel. It's infuriating.
|
# ? Oct 11, 2018 20:49 |
|
A lot of people in this thread using Excel for what sed and awk are made for.
|
# ? Oct 11, 2018 20:59 |
*builds extremely desktop-app-like web tool for dealing with tabular data, based around records with unique IDs and sorting, and supporting all spreadsheet-like functionality for moving records around while retaining consistent non-user-modifiable metadata* Client: "Cool, now can you make it export to XLS so we can edit it in Excel and upload it back into the system?" ... Client: "CSV is ok too"
|
|
# ? Oct 11, 2018 21:15 |
|
mllaneza posted:A lot of people in this world using Excel for what multiple other programs are made for.
|
# ? Oct 11, 2018 21:37 |
|
The Macaroni posted:Exactly. I mean, Excel can handle a CSV properly, but the fact that Microsoft buried functionality several clicks deep for dealing with an extremely common data format is maddening. And then they hit you on the back end as well, making it cumbersome to save to that same extremely common format. Ah, gotcha. Yes, agreed that is an annoying issue and yet another of the way that Word and Excel get something just a little wrong and it ends up being far more irritating than you would expect it to. It's a lovely little import wizard when you do get there, though. Saved my rear end with files with dodgy CSV outputs on more than one occasion.
|
# ? Oct 11, 2018 21:40 |
|
You know, I literally never had that problem with excel handling multiple huge CSV files in my last job. And today I was part of the first company-wide reply all chain in my short time at this multi-national company with multiple thousand employees, many of whom just today realised they are still on the mailing list for whatever piece of software died yesterday On the other hand, this was such a shitshow that I kept applying and I'm now in the negotiating salary phase of ing.
|
# ? Oct 11, 2018 22:03 |
|
Why the gently caress do people insist on naming things so looooooooooooong? You don't need 16 folders deep with descriptive names and 4 digit prefixes for sorting and 200+ character file names! You don't! No one does! It's madness!! ARRGH!!
|
# ? Oct 12, 2018 05:20 |
|
Antioch posted:Why the gently caress do people insist on naming things so looooooooooooong? You don't need 16 folders deep with descriptive names and 4 digit prefixes for sorting and 200+ character file names! You don't! No one does! It's madness!! ARRGH!! bonus points if it's the reason your touchy as hell vertical market application shits itself while installing.
|
# ? Oct 12, 2018 06:03 |
|
One of the things that really annoy me about Excel is that their formula language is different for different language versions of the software So in English you'd do ISNUMBER and in dutch it's ISGETAL, SUM is SOM, AVERAGE is GEMIDDELDE. It's infuriating Thank god I don't deal with Excel on a regular basis and don't have to deal with end users.
|
# ? Oct 12, 2018 08:19 |
|
spankmeister posted:One of the things that really annoy me about Excel is that their formula language is different for different language versions of the software absolutely this I hate it so much who the gently caress localizes programming function names????
|
# ? Oct 12, 2018 09:21 |
|
ISNUMBER is already localised.
|
# ? Oct 12, 2018 09:51 |
Three computers in the last couple days had fatal errors during windows updates and had to have windows refreshed. Two more have been reported this morning. It's all a coincidence and not the start of anything.
|
|
# ? Oct 12, 2018 10:39 |
|
Ominous
|
# ? Oct 12, 2018 10:41 |
Found the culprit: https://community.sophos.com/produc...-error-c0000022 Fortunately we don't have many users with windows 8.1 machines, but the CFO and a director are two of them!
|
|
# ? Oct 12, 2018 11:01 |
|
spankmeister posted:One of the things that really annoy me about Excel is that their formula language is different for different language versions of the software At least it lets you open other language version files while dynamically translating the formula language*. What's worst is that you can't enter other language formulas and you have to go looking for one of those translation sites for Excel formulas and hope they also properly change the commas into semicolons. *If you have macros or formulas that reference graphs, filenames or other metadata you're poo poo out of luck, unless you feel like adding an IF statement that checks for errors and then switched to the other language version for every language your sheet might get opened in.
|
# ? Oct 12, 2018 11:33 |
|
Exchange does something similar - it names the folders in a mailbox according to the language that the user has selected, rather than handling localisation on the client. So you write a script that does something to calendars and it will fail on anybody that isn’t using English as their language.
|
# ? Oct 12, 2018 12:44 |
|
It's depressing that I can think of a solution for this which they probably already have partially implemented.
|
# ? Oct 12, 2018 13:07 |
|
Ghostlight posted:A lot of people in this world using Excel for what multiple other programs are made for.
|
# ? Oct 12, 2018 13:56 |
|
Ghostlight posted:A lot of people in this world using Excel for what multiple other programs are made for. A lot of developers in this world are writing programs to replace years and decades old excel spreadsheets that have reached their EOL. I know I wrote my share. Some spreadsheets/processes are harder to replace than others though.
|
# ? Oct 12, 2018 13:58 |
|
Volguus posted:A lot of developers in this world are writing programs to replace years and decades old excel spreadsheets that have reached their EOL. I know I wrote my share. Some spreadsheets/processes are harder to replace than others though. One piece of very niche software we use is doubling down on Excel.. They have managed to write a program that quotes and builds pole barns and other similar structures almost entirely as a massive Excel macro. Did you know Excel can render isometric views of structures? Neither did I... but they made it happen somehow. It also has a few companion utilities to accomplish the things Excel cannot and they appear to be written in VB6. It has always been terrible... Simply building a quote can bring a modern i7 to its knees for several seconds. It crashes randomly, a lot. Their installer/updater has issues with UAC or any user without admin access for that matter. It used to not support screen resolutions above 1024x768 correctly, which made it a pain in the rear end when LCDs started really taking over. (users would have to change to 1024x768 to run the program). They fixed that problem, only to then not support widescreen resolutions when that started to become a thing Their head developer told me widescreens where a fad that wouldn't last and they where not going to bother supporting those resolutions. Troubleshooting it remotely can be a bitch.. If ANY remote screen sharing software is actively sharing the screen, the program will crash with a Excel "cannot paste" error when you move between steps. That's my terrible misuse of Excel story.
|
# ? Oct 12, 2018 14:20 |
|
siggy2021 posted:The owner of our company wants a floor to ceiling, edge to edge whiteboard with no seams in one of our conference rooms. Then one on the opposite wall in that room as well. The paint cant work, but if you boss is willing to spend, look at a product called Walltalker. It's basically a wallpaper that is a proper dry erase surface, and they also make a magnetic one. It's mad money, though.
|
# ? Oct 12, 2018 14:33 |
|
stevewm posted:One piece of very niche software we use is doubling down on Excel.. I worked more than a decade ago for a short while for a civil engineering company. They were employing engineers and scientists to do all kinds of studies on buildings, weather patterns, etc. They loving looved excel. Excel and Fortran. The 2005 excel could do poo poo that would blow your mind. Luckily I never had to touch that crap, but i did have to understand it to make the replacements.
|
# ? Oct 12, 2018 14:40 |
|
stevewm posted:Did you know Excel can render isometric views of structures? Neither did I... but they made it happen somehow. It also has a few companion utilities to accomplish the things Excel cannot and they appear to be written in VB6. https://www.youtube.com/watch?v=-gYb5GUs0dM
|
# ? Oct 12, 2018 15:08 |
Unfortunately, Microsoft long ago made the decision that to become more respectable as a company they could no longer include easter-eggs. Too bad they kept including bloatware, preventing them from being respectable.
|
|
# ? Oct 12, 2018 15:17 |
|
Antioch posted:Why the gently caress do people insist on naming things so looooooooooooong? You don't need 16 folders deep with descriptive names and 4 digit prefixes for sorting and 200+ character file names! You don't! No one does! It's madness!! ARRGH!! Even better when there's more folders than files so it's just making things harder to get to without improving anything.
|
# ? Oct 12, 2018 15:52 |
|
Antioch posted:Why the gently caress do people insist on naming things so looooooooooooong? You don't need 16 folders deep with descriptive names and 4 digit prefixes for sorting and 200+ character file names! You don't! No one does! It's madness!! ARRGH!! Z:\Company Name\Accounting\Reports\Q3\Company Name Accounting Q3 Report.xls
|
# ? Oct 12, 2018 16:06 |
|
Bob Morales posted:Z:\Company Name\Accounting\Reports\Q3\Company Name Accounting Q3 Report.xls Z:\Company Name\Accounting\Reports\Q3\Company Name Accounting Q3 Report-2017-final version 3 (2).xls
|
# ? Oct 12, 2018 16:12 |
|
Proteus Jones posted:Z:\Company Name\Accounting\Reports\Q3\Company Name Accounting Q3 Report-2017-final version 3 (2).xls Z:\Company Name\Accounting\Reports\Q3\test\prod\temp\temp(4).csv
|
# ? Oct 12, 2018 16:14 |
|
Proteus Jones posted:Z:\Company Name\Accounting\Reports\Q3\Company Name Accounting Q3 Report-2017-final version 3 (2)-USE THIS ONE.xls
|
# ? Oct 12, 2018 16:16 |
|
All of these file names are Exhibit A on why I consciously decided to become a misanthrope
|
# ? Oct 12, 2018 16:19 |
|
Oh you and your nested folder names that actually have a basis in reality. Try: Z:\Division\Common\Learning\Region\Nursing\Region[again, because why not]\Prac\Trn\Final\Web\IP2006 v2 draft.ZIP See that filename? It stands for Infection Prevention. So when a ticket comes in saying "Hey, the Infection Prevention web class isn't working, can you update the content?"--yeah, good luck finding that content if the one person in the office with the institutional memory is on vacation. I started demanding that content experts paste the network path in one of the database custom fields, but that didn't cover the 10 years of files that existed before I made that rule.
|
# ? Oct 12, 2018 16:19 |
|
We have a client with an absolutely atrocious naming/folder convention. They're using sharepoint online and have stuff like: SiteName\LocationNameHere\ProjectNameHere\SubProjectName\SubProjectTasks\SubProjectTask1\SubProjectSubTasks\SubProjectSubTask1\actualcontentfilesMAYBE - this will end up being like 300 characters once their full site name is attached which is like 40 characters in and of itself I forget exactly what worked and what didn't, but they couldn't use OneDrive to access sharepoint because of character limits and something with excel/word would puke, maybe it's using excel/word to load from OneDrive? Either way, their poo poo was horrible.
|
# ? Oct 12, 2018 16:23 |
|
Volguus posted:A lot of developers in this world are writing programs to replace years and decades old excel spreadsheets that have reached their EOL. I know I wrote my share. Some spreadsheets/processes are harder to replace than others though. In TYOOL 2018 at a company that has a full Dynamics CRM, AX, Experlogix and a fully staffed Power BI team, we still do sales forecasting/historicals off of some god awful beast of a spreadsheet that requires an OLEDB connector. also got this from the $CFO last night: "I would like to meet with you on a confidential matter tomorrow."
|
# ? Oct 12, 2018 19:11 |
|
DigitalMocking posted:In TYOOL 2018 at a company that has a full Dynamics CRM, AX, Experlogix and a fully staffed Power BI team, we still do sales forecasting/historicals off of some god awful beast of a spreadsheet that requires an OLEDB connector. It's porn
|
# ? Oct 12, 2018 19:18 |
|
MF_James posted:It's porn to make, watch, or discuss someone getting caught with it at work?
|
# ? Oct 12, 2018 20:00 |
|
Johnny Aztec posted:to make, watch, or discuss someone getting caught with it at work? He wants to discuss catching someone paying to make porn at the office because he was not offered a free copy to watch!
|
# ? Oct 12, 2018 20:03 |
|
|
# ? May 28, 2024 23:46 |
|
Johnny Aztec posted:to make, watch, or discuss someone getting caught with it at work?
|
# ? Oct 12, 2018 20:25 |