Hacker Newsnew | past | comments | ask | show | jobs | submit | countmora's commentslogin

If you import with PowerQuery you can explicitly specify the data type for each column.


I wish more people stop hating on Excel. It's an incredible tool with cool stuff baked in (Python support, PowerQuery, etc.). Just because some people misuse it as database or it doesn't scale well beyond a couple of 10k rows does not make it a bad product. For 90% of daily office tasks it's just fine.


> Just because some people misuse it as database or it doesn't scale well beyond a couple of 10k rows does not make it a bad product.

It's not just that making it a bad product. Those are minor annoyances when compared with it trying to keep your data hostage in opaque formats[1] and exfiltrating your data to the cloud[2].

[1] https://blog.documentfoundation.org/blog/2025/07/18/artifici...

[2] https://superuser.com/questions/1903431/how-to-stop-excel-36...


The recent releases with new functions are great, there's a lot that can be done in a format that both pervasive and familiar. And Power Query is indeed a useful addition.

Is Python is still a metered cloud runtime?


I don't think it's as bad as people make it, and certainly we can't blame non-technical users if they like it, for many tasks it's the only tool that's simultaneously usable by normal people and powerful enough.

It suffers from trying to do too many things at once, though. Excel 3 is enough for those use cases without being a complete nightmare for everyone else. Electronic spreadsheets as a concepts are genius, it's the implementation I hate.


Too many at once? Apparently, you can insert Python code into Excel now, which then gets executed into whatever Azure's equivalent of lambda is. I was recently introduced to someone at work who vibe coded an entire Python application in it and burned through their teams worth of cloud credits.


When Python in Excel was announced I was initially pretty excited until I found out that it executes in Azure.

WHY wouldn't Microsoft just run it in the local interpreter on the machine?


> WHY wouldn't Microsoft just run it in the local interpreter on the machine?

Probably to tighten vendor lock-in.


Excel is fantastic. I love it.

But using a spreadsheet to store data is completely reasonable. We delude ourselves as technically experienced people when we imply otherwise. When Excel fucks up data (perhaps the most unforgivable sin in all of software) with unexplainably bad defaults and UX for auto-formatting (i.e. "trying to be clever"), it's absolutely out of touch to point the finger at the end user.


> unexplainably bad defaults and UX for auto-formatting

Agree. Soooo many leading zeroes have been striped from ZIP codes.

Equally as bad is no visual indicator to distinguish formula cell from static cells. Easy to silently overwrite formulas with a careless paste.


Don't want to be that guy, but [1] says

>Robots and Screen Scraping: You may not use data mining, robots, screen scraping, or similar data gathering and extraction tools on this site, except with our express written consent as noted below.

[1] www.imdb.com/conditions/


I am not disagreeing with you, I was just pointing out that the cli tool does not use the API but scrapes.


> "Unicode" button label way off center

Its actually the center of the button, I made a video for context: https://imgur.com/a/1Y9O8dS

> The 8/10/16 selector being off center in its own position

Might be due to the image compression, it looks fine on my MB.


> Its actually the center of the button

Upvoted for putting in the effort, and because you make a correct point.

But the Unicode button is perceptually off center, because ASCII is a smaller word, and there's no visible boundary between the buttons. This comes up a lot in iconography, the classic example is a play triangle (like the media control) in a circle. Placing the triangle in the geometric center won't look centered, it needs to be a tiny bit to the right of that to account for the shape.

No separation between the buttons means you can't see the bounds which the words are centered in, so it looks off.

The 8 and 10 have the same problem, for the same reason. A visible background-gray line between the buttons would solve this problem, it should be 'squircled' to make it I-shaped and match the outer edges.


From zooming into your clip both ASCII and Unicode are wrong:

- ASCII is off center ~43/50 pixel margins

- Unicode is off center ~20/25 pixel margins

- Both have different margin sizes

- The button sizes of both are the same.

- The Hide button is offset from both 8/10/16 selector and ascii/unicode buttons

- Even if everything was correct, because there is no contrast between "Off" and background, it's going to look wrong anyway


The selector issue is very visible in your video still: you can see black pixels at the top of the selected number where it shows the selector background, but none at the bottom because it's misaligned and the selection bubble is slightly outside its box.

Edit: zooming in closer it's maybe not outside the box at all, but there's some odd aliasing artifacts or something making the space above the highlight look bigger than the space below.

Honestly I don't think it makes it any better if the Unicode text is theoretically centered; the fact that there's zero separation between the options, and such poor spacing that it's difficult to tell and feels awkward either way is still terrible design.


I think royalties from <1k streams are basically nothing anyway. Giving up the ability to distribute your music for free and reach more people would be a terrible idea.


> We’re also building tools to help detect misleading content such as a detection classifier that can tell when a video was generated by Sora.

I am curious of how optimised their approach is and what hardware you would need to analyse videos at reasonable speed.


I was still curious about the exact response, therefore I see no harm in posting that.


Will Google introduce a special error message in reference to this xkcd in the future for the fun?

After all, the Python project has "import antigravity".


2005 google would. 2023 google I don’t think would.


If you have a newer macOS version on an entry Intel machine, ordinary tasks can cause a lot of fan noise. You can activate Low Power Mode [1] to reduce clock speed and therefore the fan will not be as loud. See if the reduced clock speed does not interfere with your daily tasks.

[1] https://www.howtogeek.com/771767/how-to-enable-low-power-mod...


> unfortunately the tokenizer was trained on this subreddit

Do you have a source for that or was it just an assumption?


It's pretty much guaranteed. Where else on the internet would this sequence of characters appear so frequently that it gets selected as one of the internet's top ~50,000 words?

Also, that Reddit is frequently used to train LLMs is widely known. It's an unusually clean source of conversational text because you can slice threads (i.e. pick a root comment, then pick a child, then a child of the child etc and then concatenate the results), and you'll get a coherent conversation. There are relatively few places on the internet where that is true. For example most phpBB forums conflate many different conversations into single threads, with ad-hoc quoting being used to disambiguate which post is replying to which. That makes it a lot harder to generate sample conversations from.


>There are relatively few places on the internet where that is true

Imageboards.

DailyMail.

Slashdot.

Even a somethingawful dump would have been superior.


Slashdot doesn't have the volume. Don't know about image boards but are they threaded and do they cover as many topics?

The Daily Mail (the newspaper) has been used for training LLMs in the past, yes. I don't know if it still is.


imageboards sure do -- poorly.

listen, some of the niche corners of that world aren't so bad, but it ain't the place to be training AI to do something, unless that something is a hate crime


So filter the content before you use it. Clearly openAI did the bare minimum on this front.


There was a video[0] on Computerphile about this topic

[0] https://www.youtube.com/watch?v=WO2X3oZEJOA


See the old SolidGoldMagikarp drama- it's happened before.


It is so frustrating when there is nothing at the top that forwards to the main page,e.g., a project name or logo.

I managed it by clicking on the How to Install guide and then on the download image link.



Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: