Communities

Writing
Writing
Codidact Meta
Codidact Meta
The Great Outdoors
The Great Outdoors
Photography & Video
Photography & Video
Scientific Speculation
Scientific Speculation
Cooking
Cooking
Electrical Engineering
Electrical Engineering
Judaism
Judaism
Languages & Linguistics
Languages & Linguistics
Software Development
Software Development
Mathematics
Mathematics
Christianity
Christianity
Code Golf
Code Golf
Music
Music
Physics
Physics
Linux Systems
Linux Systems
Power Users
Power Users
Tabletop RPGs
Tabletop RPGs
Community Proposals
Community Proposals
tag:snake search within a tag
answers:0 unanswered questions
user:xxxx search by author id
score:0.5 posts with 0.5+ score
"snake oil" exact phrase
votes:4 posts with 4+ votes
created:<1w created < 1 week ago
post_type:xxxx type of post
Search help
Notifications
Mark all as read See all your notifications »
Meta

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.

Comments on Spreadsheets apps as end user development tool / spreadsheet formulas as a form of funtional programming

Parent

Spreadsheets apps as end user development tool / spreadsheet formulas as a form of funtional programming

+3
−0

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.

History
Why does this post require moderator attention?
You might want to add some details to your flag.
Why should this post be closed?

0 comment threads

Post
+2
−0

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.

History
Why does this post require moderator attention?
You might want to add some details to your flag.

2 comment threads

Instead of usage level lets talk about the baseline for asking a software development question (2 comments)
Maybe draw the line at VBA? (3 comments)
Maybe draw the line at VBA?
Lundin‭ wrote 11 months ago

Maybe we could draw the line of what's considered programming at VBA? VBA essentially being an integrated programming language. Sure you can do lots of programming-like things with excel formulas, but it is as clunky as can be...

LAFK‭ wrote 11 months ago

Yup! I'd quite agree with this being a very nice line to draw.

Alexei‭ wrote 11 months ago

I also agree with the idea of VBA-related questions being on-topic and the formula-related or other Excel usage ones as off-topic, unless they are linked to the usage of certain Excel generation libraries (e.g. ClosedXML, EPPlus) which might have affected formulas and/or other features.