Hi,
On Mon, Jul 28, 2025 at 10:44:36AM -0500, Richard Owlett wrote:
Does Debian have a spreadsheet program that can competently
read/write xlsx format?
I have never had an issue with LibreCalc's xls support. If an xls
file is so complicated that LibreOffice can't read/write it properly,
I suspect you will find it unusable in anything but Microsoft
software since that is their proprietary format.
Does Debian have a spreadsheet program that can competently read/write xlsx format?
On 7/28/25 10:52 AM, Andy Smith wrote:
Hi,
On Mon, Jul 28, 2025 at 10:44:36AM -0500, Richard Owlett wrote:
Does Debian have a spreadsheet program that can competently
read/write xlsx format?
I have never had an issue with LibreCalc's xls support. If an xls
file is so complicated that LibreOffice can't read/write it
properly, I suspect you will find it unusable in anything but
Microsoft software since that is their proprietary format.
If that were the case, shouldn't it have complained on read also?
On 7/28/25 10:52 AM, Andy Smith wrote:
I have never had an issue with LibreCalc's xls support. If an xls file
is so complicated that LibreOffice can't read/write it properly, I
suspect you will find it unusable in anything but Microsoft software
since that is their proprietary format.
If that were the case, shouldn't it have complained on read also?
I found a USDA published spreadsheet[1] [in xlsx format] containing
needed data. I saved it to a local directory with no problems.
I copied it to another directory to prevent accidents.
I opened it - Debian defaulted to LibreOffice Calc.
I tried to save it [unedited] to file2.xlsx. Got dire warning and
suggestion to save in ODF format.
Does Debian have a spreadsheet program that can competently
read/write xlsx format? [never happy with LibreOffice text processing $#^$%YU]
On 2025-07-28 at 11:52, Andy Smith wrote:
I suspect you will find it unusable in anything but Microsoft
software since that is their proprietary format.
I did see a blog post somewhere recently from someone griping about how unnecessarily dense, complex, and impenetrable the Microsoft Office
document formats are, to such an extent that it makes implementing
support for them difficult verging on impossible. There was the
suggestion that Microsoft chose that development path on purpose, specifically in order to make it harder for anyone else to interoperate properly with those formats.
I found a USDA published spreadsheet[1] [in xlsx format] containing
needed data. I saved it to a local directory with no problems.
I copied it to another directory to prevent accidents.
I opened it - Debian defaulted to LibreOffice Calc.
I tried to save it [unedited] to file2.xlsx. Got dire warning and
suggestion to save in ODF format.
Does Debian have a spreadsheet program that can competently
read/write xlsx format? [never happy with LibreOffice text processing $#^$%YU]
I tried to save it [unedited] to file2.xlsx. Got dire warning and suggestion to save in ODF format.
Does Debian have a spreadsheet program that can competently read/write xlsx format? [never happy with LibreOffice text processing $#^$%YU]
I found a USDA published spreadsheet[1] [in xlsx format] containing needed data. I saved it to a local directory with no problems.
I copied it to another directory to prevent accidents.
I opened it - Debian defaulted to LibreOffice Calc.
I tried to save it [unedited] to file2.xlsx. Got dire warning and suggestion to save in ODF format.
Does Debian have a spreadsheet program that can competently read/write xlsx format? [never happy with LibreOffice text processing $#^$%YU]
TIA
[1] https://www.fns.usda.gov/sites/default/files/media/file/TFP-2021-Disaggregated-Market-Basket.xlsx
On Mon, Jul 28, 2025 at 10:44:36AM -0500, Richard Owlett wrote:
I tried to save it [unedited] to file2.xlsx. Got dire warning and suggestion >> to save in ODF format.
I think you can configure away the "dire warning" and make LibreOffice
save as xlsx by default, if you want.
Does Debian have a spreadsheet program that can competently read/write xlsx >> format? [never happy with LibreOffice text processing $#^$%YU]
LibreOffice is very good at this.
What was the actual problem (except for the warning)?
/ralph
I did see a blog post somewhere recently from someone griping about how unnecessarily dense, complex, and impenetrable the Microsoft Office
document formats are, to such an extent that it makes implementing
support for them difficult verging on impossible [...]
suggestion that Microsoft chose that development path on purpose, specifically in order to make it harder for anyone else to interoperate properly with those formats.
On Mon, Jul 28, 2025 at 10:44:36AM -0500, Richard Owlett wrote:
I found a USDA published spreadsheet[1] [in xlsx format] containing needed >> data. I saved it to a local directory with no problems.
I copied it to another directory to prevent accidents.
I opened it - Debian defaulted to LibreOffice Calc.
I tried to save it [unedited] to file2.xlsx. Got dire warning and suggestion >> to save in ODF format.
Does Debian have a spreadsheet program that can competently read/write xlsx >> format? [never happy with LibreOffice text processing $#^$%YU]
Libreoffice generally works - but you could always try Gnumeric from
the GNOME project.
It does help if you can try things for yourself if this is practicable
and *then* come back and say "X worked, Y didn't work". Some assembly required, as they say, or at least a willingness to show and share your workings to allow the rest of us to see *exactly* what you are talking
about.
With every good wish, as ever,
Andy Cater
(amacater@debian.org)
TIA
[1] https://www.fns.usda.gov/sites/default/files/media/file/TFP-2021-Disaggregated-Market-Basket.xlsx
[1] https://www.fns.usda.gov/sites/default/files/media/file/TFP-2021-Disaggregated-Market-Basket.xlsx
From here, anything that can handle CSV input should be able to deal with this. Having the internal commas within the two description fields, with double quotes around them, is fairly common, and any decent CSV libraryshould be able to cope with that.
Reading a document is often easier to implement than writing it out correctly. Reading is also safer, because you're not overwriting any
data; if you try to save the document, you might be doing so to an
existing filename, and if the resulting format is invalid by the
standards of whatever you want to read it next, then you've just caused
data loss.
Also gnumeric seemed faster.
On 7/28/25 12:22 PM, Andrew M.A. Cater wrote:
Libreoffice generally works - but you could always try Gnumeric from
the GNOME project.
Someone else suggested Gnumeric.
Tried it. It appears more satisfactory. For me personally, Gnu has a better track record than LibreOffice.
On 7/28/25 20:13, Richard Owlett wrote:
Also gnumeric seemed faster.
That's definitely true.
I'm using gnumeric for essentially all my spreadsheet stuff.
But it doesn't have as many functions as Excel.
And it doesn't really support conditional formatting where
the format depends on other cells.
LibreOffice claims to support this, but I couldn't get it
working.
On Mon, 28 Jul 2025 20:43:52 +0200
Detlef Vollmann <dv@vollmann.ch> wrote:
On 7/28/25 20:13, Richard Owlett wrote:
Also gnumeric seemed faster.
That's definitely true.
I'm using gnumeric for essentially all my spreadsheet stuff.
But it doesn't have as many functions as Excel.
And it doesn't really support conditional formatting where
the format depends on other cells.
LibreOffice claims to support this, but I couldn't get it
working.
I've had that working, changing the background colour of cells depending
on value, but it has been flaky in the distant past. I'm using sid, so
the problem might have been present more recently on stable.
On Mon, Jul 28, 2025 at 10:44:36 -0500, Richard Owlett wrote:
[1] https://www.fns.usda.gov/sites/default/files/media/file/TFP-2021-Disaggregated-Market-Basket.xlsx
I was unable to download this with wget -- it just hung for a while.
But when I pasted the URL directly into a web browser, the browser was
able to download it.
Is there Debian software that can work with, and especially convert, WordPerfect files?
Is there Debian software that can work with, and especially convert, WordPerfect files?
Sysop: | Keyop |
---|---|
Location: | Huddersfield, West Yorkshire, UK |
Users: | 546 |
Nodes: | 16 (2 / 14) |
Uptime: | 151:25:28 |
Calls: | 10,383 |
Files: | 14,054 |
Messages: | 6,417,800 |