Topic on Talk:Quarry

Tracked in Phabricator
Task T175285 Resolved

Excel has a "feature" that limits cells of type "link" (URLs) to 255 characters. Quarry has been updated to check for errors from the Excel writing library and instead write the cell out as a plain string.

Hi again, Zhuyifei1999. Maybe you remember, a couple of month ago you created for me a new download option, excel. I see now it has a bug. I prefer to ask you here, not in phab, because maybe you aware of this. When I download the same 4441 query you saved, the result has all the article names, but only some URLs. What do you think about this? Thank you.

Uh, works for me (LibreOffice Calc). I don't have Microsoft Excel so I have no idea why it is not working on Excel.

So what's we can do, Zhuyifei1999? Nobody can work when half a data is deleted. Thank you.

I'll ask some friends of mine who has Excel to check them; might take some time though. If I forget (or take too long) please file a ticket in Phabricator.

Very well, Zhuyifei1999. Can I suggest a possible cause? It's from my work experience as programmer, it has nothing to do with wiki.

Cannot reproduce for https://quarry.wmflabs.org/run/202117/output/0/xlsx?download=true on Microsoft Excel for Mac, Version 15.37

Well, Zhuyifei1999, that means it's more possible I'm right. If I am, the problem is with some fields with more than 256 bytes length. Thank you.

Can you test that out? Eg. with SELECT "SOMETEXT"; varying the length of the text. Since there is no way for me to find any text missing I cannot easily help you, unfortunately.

Try 21263, please. I have there a lot of long links. Thank you.

Ok I can reproduce this on LibreOffice Calc, Version 5.1.6.2. Filed phab:T175285 to track this.

Thank you.