this post was submitted on 20 Apr 2024
979 points (97.2% liked)
linuxmemes
21272 readers
493 users here now
Hint: :q!
Sister communities:
- LemmyMemes: Memes
- LemmyShitpost: Anything and everything goes.
- RISA: Star Trek memes and shitposts
Community rules (click to expand)
1. Follow the site-wide rules
- Instance-wide TOS: https://legal.lemmy.world/tos/
- Lemmy code of conduct: https://join-lemmy.org/docs/code_of_conduct.html
2. Be civil
- Understand the difference between a joke and an insult.
- Do not harrass or attack members of the community for any reason.
- Leave remarks of "peasantry" to the PCMR community. If you dislike an OS/service/application, attack the thing you dislike, not the individuals who use it. Some people may not have a choice.
- Bigotry will not be tolerated.
- These rules are somewhat loosened when the subject is a public figure. Still, do not attack their person or incite harrassment.
3. Post Linux-related content
- Including Unix and BSD.
- Non-Linux content is acceptable as long as it makes a reference to Linux. For example, the poorly made mockery of
sudoin Windows. - No porn. Even if you watch it on a Linux machine.
4. No recent reposts
- Everybody uses Arch btw, can't quit Vim, and wants to interject for a moment. You can stop now.
Please report posts and comments that break these rules!
founded 1 year ago
MODERATORS
you are viewing a single comment's thread
view the rest of the comments
view the rest of the comments
You also can't open two spreadsheets that have the same filename. I'm sure that's led to a helpdesk call or two.
I lost a lot of respect for Microsoft when I first saw that issue. It's such an easy to avoid limitation. Like probably a similar level of difficulty to remove that limitation than to write the error message explaining it, unless it's more of a spaghetti mess than I'm expecting it to be.
It’s to do with the ability to work with data across all open workbooks:
You can reference
[Workbook.xlsx]Sheet1!B2but if you have two excel workbooks open, both namedWorkbook.xlsxwhich one should be used?If you want to reference other files, you should use a less ambiguous way to refer to them. Like a relative path or full absolute path. The fact that that weakness is because of a half-baked feature like that actually makes me lose even more respect.
Edit: thanks for the info though, it does add some missing context.
Whichever one has the smallest relative path to the workbook using it? How does it find the workbook if it isn't open already?
It doesn’t.
So throw an error at runtime on that macro, most workbooks aren't the target of a macro