Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Spreadsheets apps as end user development tool / spreadsheet formulas as a form of funtional programming
I have found Can we migrate office suite related questions to the Power Users community?, apparently, with a score of +7, 3 answers, but it looks like no decision have made so far.
Despite not having taken a decision so far, that discussion makes me wonder if end-user development questions are on-topic here. I think that Software Development is not limited to questions from professional developers, so they should be on-topic while meeting the scope criteria.
On the other hand, as it's allowed to have overlapping across Codidact communities, it should not be any problem to have questions related to spreadsheets (files, applications, formulas, etc.) here and on other sites like Power Users. Correct?
According to Wikipedia, end-user development (EUD)
...or end-user programming (EUP) refers to activities and tools that allow end-users – people who are not professional software developers – to program computers.
In the spreadsheet it's mentioned that
Spreadsheets are a popular end-user development tool.\[46\]
Another term, citizen developers, has been used to refer to non-professional software developers that embrace quests to achieve business goals like digital transformation powered by "low code / no code" platforms. In a future discussion, I would also like to ask if the integration of no-code / low-code app through services like Zappier, Make, or Google Cloud Application Integration service could be considered on topic here.
1 answer
While I personally agree (take my upvote) I'd note that programming spreadsheet has multiple levels.
Level 0: I use spreadsheet, sometimes with some functions, like count
or sum
of something conditional.
Level 1: I do pivots often, along with lookups, references, and many others.
And so it goes, including levels like games-inside-spreadsheet etc. The latter levels may be unlikely to get answers on power users.
EDIT: @Lundin had a great idea to make VBA the differentiator. I'm in favour. /endOfEdit
I'd also add to feature request (if we'll make one) to have a "migration" section in the community description. Within I'd welcome simple statements like "Spreadsheet programming questions are migrated to Power Users community, since rationale". Similarly, when one writes a question and tries to use related tags, I'd pop up a perhaps-migrate-this warning.
0 comment threads