Items tagged with: askfedi
Edit2: Solved! Thanks everyone!
#Blind #Microsoft #excel users and others who, for whatever reason, only use the keyboard, NOT THE MOUSE: How the hell do I tell Excell to continue a pattern in a column without selecting it and clicking on the bottom left side of the screen or whatever?
Let's say I have a column with 1 in A1, 2 in A2, 3 in A3, so forth, and want that to go on for 150 cells or so. How the hell do I do it? Because I know I used to know, but I cannot find it.
It's not control+d. That just fills the whole column with 1's. It's not copy-paste; that does adjust properly for formulas, but for this, it doesn't. There is surely an option somewhere in the menus, but I cannot find it.
Alternatively, I'd also be happy to learn of ways to do this in #OpenOffice #Calc, so long as they are keyboard-only and accessible. LibreOffice doesn't work all that well here, at least Writer doesn't, but I could double-check if that extends to other programs.
#AskFedi #AskMastodon #ScreemReader
Edit: a couple folks suggested using formulas for this, adding so the first cell would be 1, the second A1 +1, etc. That works quite well for most use cases! It would mean the order of the numbers would stay the same when reordering the table though, so if I was using this to autocomplete a list of years, then sold by the comumn Income ... bam, the income of each year's not right anymore.
Also suggested was Home>Fill>Series. I do not see a Series option in the Fill menu at all, Bewilderingly. I'll try to switch my language to English to see if that's the issue, but I pressed all the things, so pretty sure it's not there for me in Office 365. Could someone with that version check whether it works for them?
Edit2: I figured out how to get to the series option! Turns out it was there, I just didn't realise I had to select the right type of series. For those curious, for the Slovenian version, that's Alt +N, FI, V, Enter.
For some reason, when I send commands to a bot with a mention, whether I do so in public or unlisted visibility, other people who don't follow the bot get my toot, and I don't want to bother them.
I thought the visibility rule for the fedi was: a post will appear in your home timeline if, 1) you're mentioned in it, or, 2) you follow the poster AND everyone else mentioned in the post.
Is this incorrect? Is there a way I can send commands to the bot without cluttering up other people's TLs and without using a DM?
Researched this a while back but didn't find anything, so I'll ask here.
I'm looking for a flatfile CMS that would let me a) manage everything in a git repo and b) add logic to my site somehow.
Something like Netlify gets part of it right. You can manage content via git and include functions that are mounted at /.netlify/functions, but I can't host that myself and their prices are/were insane.
https://getgrav.org is closest to what I want and I'm using it now, but its git-sync plugin is a little vicious beast that will murder whatever repo you sync it with unless you set it up just so, and I'm not looking forward to trying to get that right again. No, I'm not being hyperbolic. https://github.com/trilbymedia/grav-plugin-git-sync/issues/213
If possible, I'd also like to tweak pages pre-render so I can, for instance, not show site sections/links if a user is authenticated or similar. I can do PHP if I must, but I'm way more familiar with just about every other ecosystem. #AskFedi
The really excellent PeerTube instance https://tilvids.com now has a bug that stops people on Mastodon etc being able to follow Tilvids accounts:
-Existing follows work fine, but new follows turn into "Follow request sent" messages and don't go through (PT doesn't use requests).
-Messaged Tilvids about this and they rebooted server, but it didn't help.
-Posted on PT Github but no help so far.
Any suggestions for how to fix this?