[16:00:33] soo dsaez. hi. [16:00:51] hi leila [16:01:12] dsaez: if you join Staff Community Time meeting now, it will be your first one I guess. It's mostly for staff to have some time to talk about different things that are going on. The IRC channel for it is #wikimedia-staff. [16:01:19] links are all in your calendar. [16:03:18] ok [16:06:23] leila: Cannot join #wikimedia-staff (Channel is invite only). [16:07:13] yeah. let me ask for help re that, dsaez [16:09:22] 10Quarry: Quarry XLSX cells for long urls are wrongly empty - https://phabricator.wikimedia.org/T175285#3588797 (10zhuyifei1999) [16:10:41] dsaez: you have an email about how to join that channel. [16:12:08] thx [16:16:24] 10Quarry: Quarry XLSX cells for long urls are wrongly empty - https://phabricator.wikimedia.org/T175285#3588868 (10zhuyifei1999) (Originally reported by @IKhitron on https://www.mediawiki.org/wiki/Topic:Txnc2f9ndpwke6w4) [16:24:41] 10Quarry: Quarry XLSX cells for long urls are wrongly empty - https://phabricator.wikimedia.org/T175285#3588895 (10zhuyifei1999) https://quarry.wmflabs.org/query/21425, 2048 characters plain text can be downloaded. [16:29:30] 10Quarry: Quarry XLSX cells for long urls are wrongly empty - https://phabricator.wikimedia.org/T175285#3588907 (10zhuyifei1999) https://quarry.wmflabs.org/query/21426, 151 characters url can be but 279 cannot. [16:43:34] 10Quarry: Quarry XLSX cells for long urls are wrongly empty - https://phabricator.wikimedia.org/T175285#3588921 (10zhuyifei1999) The same happens with xlsxwriter 0.9.9 instead of 0.5.2. [16:44:37] 10Quarry: Quarry XLSX cells for long urls are wrongly empty - https://phabricator.wikimedia.org/T175285#3588922 (10zhuyifei1999) ``` Sep 7 16:42:41 jessie python[26945]: /srv/venv/local/lib/python2.7/site-packages/xlsxwriter/worksheet.py:831: UserWarning: Ignoring URL 'http://www.example.com/aaaaaaaaaaaaaaaaaaa... [16:45:55] 10Quarry: Quarry XLSX cells for long urls are wrongly empty - https://phabricator.wikimedia.org/T175285#3588924 (10IKhitron) Wait a moment, it's excel's bug??? [16:51:29] 10Quarry: Quarry XLSX cells for long urls are wrongly empty - https://phabricator.wikimedia.org/T175285#3588928 (10zhuyifei1999) This is raised in https://github.com/jmcnamara/XlsxWriter/blob/b4c4b499ffb3db8e0fa1b306880bcbcb3675fd4d/xlsxwriter/worksheet.py#L828 What do you think of forcing string instead of url... [16:52:16] 10Quarry: Quarry XLSX cells for long urls are wrongly empty - https://phabricator.wikimedia.org/T175285#3588931 (10zhuyifei1999) >>! In T175285#3588924, @IKhitron wrote: > Wait a moment, it's excel's bug??? Yes, you can't possible add urls longer than 255 chars apparently. [16:52:21] 10Quarry: Quarry XLSX cells for long urls are wrongly empty - https://phabricator.wikimedia.org/T175285#3588932 (10IKhitron) Excellent for me.