you are viewing a single comment's thread
view the rest of the comments
[–] 12 points 1 week ago (4 children)

The spreadsheet one hurts. I'm currently going over a colleague's fancy spreadsheet and have decided that only an AI can edit it in the future, because the formulas are written in a way that need to be interacted with from a script or command-line tool and nobody's going to do that.

  • source
  • parent
  • hideshow 4 child comments
  • [–] 1 point 1 week ago (3 children)

    Office scripts are difficult yes

  • source
  • parent
  • hideshow 3 child comments
  • [–] 2 points 1 week ago (2 children)

    There are Python tools for interacting with xlsx which are pretty nice, but I'm not going to use that to edit a spreadsheet. Kind of defeats the purpose.

  • source
  • parent
  • hideshow 2 child comments
  • [–] 2 points 1 week ago (1 child)

    Well I can give an example of why a tool like that is useful.

    Export data for a client form internal system but that export looks like shit.

    I could spend an hour cleaning it up (multiplied by the number of other workers needing to do similar things) or I could write an office script and create essentially an import template that formats it nicely.

    I'm choosing the latter every time.

  • source
  • parent
  • hideshow 1 child comment