gnumeric issueshttps://gitlab.gnome.org/GNOME/gnumeric/-/issues2023-09-09T16:03:17Zhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/706Number format resets when unrelated changes made to range in Format Cells dialog2023-09-09T16:03:17ZKevin DaughtridgeNumber format resets when unrelated changes made to range in Format Cells dialogInput numbers in two or more contiguous cells. Change the number format from the default on one or more, but not all, of those cells. Select all the cells. Open the Format Changes dialog. Make one or more changes in tabs other than the N...Input numbers in two or more contiguous cells. Change the number format from the default on one or more, but not all, of those cells. Select all the cells. Open the Format Changes dialog. Make one or more changes in tabs other than the Number tab. Click OK or Apply. The changes will be applied, but the number format on all the cells in the range will be reset to the default.
No other settings from the dialog are similarly reset. If the number format is consistent across the range, it is not reset. The equivalent toolbar buttons for these settings do not reset the number format, but of course they do not cover the full range of possible settings (especially for borders).https://gitlab.gnome.org/GNOME/gnumeric/-/issues/694Graphics non visible in the last version2023-06-24T14:01:18ZkorokiGraphics non visible in the last versionSystem:
Arch Linux updated today
Gnome 43.2 in wayland session
Intel graphics (ADL GT2)
gnumeric 1.12.54
The graphics (figures) are not visible in the spreadsheet. I attach a video.
![Enregistrament_de_pantalla_des_de_2023-02-01_14-48...System:
Arch Linux updated today
Gnome 43.2 in wayland session
Intel graphics (ADL GT2)
gnumeric 1.12.54
The graphics (figures) are not visible in the spreadsheet. I attach a video.
![Enregistrament_de_pantalla_des_de_2023-02-01_14-48-35](/uploads/28b4490faa2152c2ed35bbfd96361dae/Enregistrament_de_pantalla_des_de_2023-02-01_14-48-35.webm)https://gitlab.gnome.org/GNOME/gnumeric/-/issues/593Gnumeric help toolbox blinks2023-02-01T19:25:01ZJoseph YulityGnumeric help toolbox blinksI have Fedora 34 Workstation running on Wayland, Gnumeric 1.12.50 (installed using dnf), kernel 5.13.14-200.fc34.x86_64.
in Gnumeric, when I type a function and I follow it by an open bracket `(`, a help toolbox is displayed, but it imm...I have Fedora 34 Workstation running on Wayland, Gnumeric 1.12.50 (installed using dnf), kernel 5.13.14-200.fc34.x86_64.
in Gnumeric, when I type a function and I follow it by an open bracket `(`, a help toolbox is displayed, but it immediately vanishes. The toolbox immediately goes way. It blinks.
How can I make it more persistent?
[This video](https://youtu.be/pJGPz7QD55U) shows what I mean.https://gitlab.gnome.org/GNOME/gnumeric/-/issues/470ssconvert to tex utf8 characters error2020-05-13T05:59:15ZYLXDXXssconvert to tex utf8 characters erroruse this command
```
ssconvert --export-type=Gnumeric_html:latex 1.ods 1.tex
```
if `1.ods` Contains Chinese characters, In `1.tex` , Chinese characters will be converted into question marks (?).
Chinese characters cannot be processed ...use this command
```
ssconvert --export-type=Gnumeric_html:latex 1.ods 1.tex
```
if `1.ods` Contains Chinese characters, In `1.tex` , Chinese characters will be converted into question marks (?).
Chinese characters cannot be processed correctly.
Please fixhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/460Pasting an external selection fails after copy/pasting a cell2023-07-11T10:03:44ZHelge HaftingPasting an external selection fails after copy/pasting a cellI have a workload where I mark a row of numbers in an xterm, then right-click a cell in gnumeric and select paste. The numbers are then pastes into gnumeric, each number in a cell of its own.
Then I select another row of numbers, and so...I have a workload where I mark a row of numbers in an xterm, then right-click a cell in gnumeric and select paste. The numbers are then pastes into gnumeric, each number in a cell of its own.
Then I select another row of numbers, and so on. Boring, but it works.
Then gnumeric failed for me. I noticed an error in the spreadsheet. I corrected it by selecting a cell, used ctrl+c to copy it, and ctrl+v to paste it where it was needed.
Then I selected another number row in xterm, tried to paste in gnumeric, and NOTHING HAPPENED. Pasting was dead, it was not possible to paste the external seleection any more.
I found a workaround: stopping gnumeric and re-starting it, reinstated the paste-from-selection functionality. But restarting the spreadsheet software is not a productive way to work. :-(
Steps to reproduce:
1. start gnumeric. An empty spreadsheet is fine. Select numbers in some terminal, paste them into gnumeric.
2. copy a cell using ctrl+c <select some other empty cell using the mouse> ctrl+v
3. Select numbers in some terminal, note that the cannot be pasted into gnumeric.
I noticed this on arch linux and artix linux. I use wayland, but that should not matter. The external pasting works fine, until an internal copy-paste is done.https://gitlab.gnome.org/GNOME/gnumeric/-/issues/424printing color2019-11-08T06:38:43Zdenis mavroudisprinting colorhow can i change the print colorhow can i change the print colorhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/242[Win32] Right-click on sheet tab opens it on wrong monitor (with two monitors)2018-05-22T14:06:22ZBugzilla[Win32] Right-click on sheet tab opens it on wrong monitor (with two monitors)## Submitted by car..@..web.de
**[Link to original bug (#720182)](https://bugzilla.gnome.org/show_bug.cgi?id=720182)**
## Description
Hey,
I am experiencing a minor issue with the tab location when trying to rename or move a sheet ...## Submitted by car..@..web.de
**[Link to original bug (#720182)](https://bugzilla.gnome.org/show_bug.cgi?id=720182)**
## Description
Hey,
I am experiencing a minor issue with the tab location when trying to rename or move a sheet inside gnumeric with a two monitor system. When right-clicking the sheet to be renamed on my right monitor, the according tab opens on the left monitor. The tab itself works fine, though. The problem occured in the two most recent gnumeric-versions (1.12.8 and 1.12.9, windows)
Version: 1.12.xhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/205implement rich text also for serie titles2018-05-22T13:55:16ZBugzillaimplement rich text also for serie titles## Submitted by Frédéric Parrenin `@parrenin`
**[Link to original bug (#689961)](https://bugzilla.gnome.org/show_bug.cgi?id=689961)**
## Description
Currently, it is possible to enter rich text with a markup langage in axis title, b...## Submitted by Frédéric Parrenin `@parrenin`
**[Link to original bug (#689961)](https://bugzilla.gnome.org/show_bug.cgi?id=689961)**
## Description
Currently, it is possible to enter rich text with a markup langage in axis title, but this functionnality is not available for serie title.
Version: git masterhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/764gnumeric-1.12.57 needs >=goffice-0.10.572024-03-16T00:45:56ZSam Jamesgnumeric-1.12.57 needs >=goffice-0.10.57Originally reported downstream in Gentoo at https://bugs.gentoo.org/925169.
`>=goffice-0.1.57` is needed for `go_quad_scalbn` which was added in upstream commit https://gitlab.gnome.org/GNOME/goffice/-/commit/cb43fc29f3def2b4fca2d84d919...Originally reported downstream in Gentoo at https://bugs.gentoo.org/925169.
`>=goffice-0.1.57` is needed for `go_quad_scalbn` which was added in upstream commit https://gitlab.gnome.org/GNOME/goffice/-/commit/cb43fc29f3def2b4fca2d84d9199681ad70bc41b.https://gitlab.gnome.org/GNOME/gnumeric/-/issues/763xlsx import: some cells' values missing2024-03-13T22:00:31ZIldar Mulyukovxlsx import: some cells' values missingIt's a DELL generated file. The column J is empty.
LibreOffice shows the values just fine.It's a DELL generated file. The column J is empty.
LibreOffice shows the values just fine.https://gitlab.gnome.org/GNOME/gnumeric/-/issues/762TESTS: t590x.pl SHA's: don't match here, neither binary64 nor decimal64.2024-02-28T00:52:34Zb. s.TESTS: t590x.pl SHA's: don't match here, neither binary64 nor decimal64.Most likely a silly fail here, but I'm running out of ideas
what may be wrong.
```
-------------------------------------------------------------------------------
t5900-sc.pl: Check the sc importer.
New SHA-1 is 7b9f7418c24bdd89...Most likely a silly fail here, but I'm running out of ideas
what may be wrong.
```
-------------------------------------------------------------------------------
t5900-sc.pl: Check the sc importer.
New SHA-1 is 7b9f7418c24bdd89d6b8e0e60f256d6268a99101; expected was 4fb115f8b93d5f4ff826a38dc67ca4e74671de6a
```
and similar for **bin64** as well as **Dec64**, even in complete fresh install.
t5902-applix.pl passes.
I don't expect match for all datatypes and combination of options,
but to have one would be nice to know the tests don't hide other fails.
--- long story ---
I used to frickle around with 'long' version,
'e' vs. 'E' notation and 'SHORTREP_FILES', thus was used to
mismatches in these tests.
Now tried to come back to a 'pass' state ... didn't work out.
Tried to reset to zero by 'git stash -m xxxx' - 'sudo make clean' -
'make' - 'sudo make install' in goffice and gnumeric ... still differences.
Even tried a total fresh clone, autogen, make, sudo make install ...
no success.
log files in sequence of action:
[01_goffice_clone.log](/uploads/55801a38ac162b8736e076459a5bd7df/01_goffice_clone.log)
[02_goffice_configure_first_run_error.log](/uploads/33fa415d3605d92047cf78c96f9f3ecb/02_goffice_configure_first_run_error.log)
[03_goffice_configure_second_run_success.log](/uploads/bab6d52517e5296c564ce06a3d96b42a/03_goffice_configure_second_run_success.log)
[04_goffice_make.log](/uploads/09dcc5a55e2d80c9371e832ba97d734d/04_goffice_make.log)
[05_goffice_make_install.log](/uploads/98a50223674aaacdc2d119e20eb857aa/05_goffice_make_install.log)
[06_gnumeric_clone.log](/uploads/3334de042a8f4ef24950b22109d80a52/06_gnumeric_clone.log)
[07_gnumeric_configure_first_run_error.log](/uploads/9e28f3da30fb42e27cacf90436471c3e/07_gnumeric_configure_first_run_error.log)
[08_gnumeric_configure_second_run_success.log](/uploads/59f590095a417bb37abc48c65e8c6a07/08_gnumeric_configure_second_run_success.log)
[09_gnumeric_make.log](/uploads/53d2925a9be8624275e5bfec90451dee/09_gnumeric_make.log)
[10_gnumeric_make_install.log](/uploads/6e881bd4476abd0156e1f578ff9a3905/10_gnumeric_make_install.log)
[11_t5900-sc.pl.log](/uploads/5d7be1cb67bf394ddce1790c2ef74ff3/11_t5900-sc.pl.log)
[12_t5901-qpro.pl.log](/uploads/675beb34678b84b0a2196103dbd1fb95/12_t5901-qpro.pl.log)
[13_t5902-applix.pl.log](/uploads/da3164787e9baece3f64a52d35e5d45f/13_t5902-applix.pl.log)
[14_t5903-sylk.pl.log](/uploads/d4025f78e5c43883ff5a31a5dc9b88c6/14_t5903-sylk.pl.log)
[15_t5904-mps.pl.log](/uploads/470a4d02b65c670af97afc60efae1a33/15_t5904-mps.pl.log)
[16_t5905-guppi.pl.log](/uploads/c9d0c8183c039bcd1a1b0941ab7648ee/16_t5905-guppi.pl.log)
[17_t5906-dif.pl.log](/uploads/2fa81a3619a32bb92c4e0f1c76327f19/17_t5906-dif.pl.log)
[21_goffice_configure_with_decimal64.log](/uploads/c0b2cd532bf64d6ccfbdc2488c0c3c3f/21_goffice_configure_with_decimal64.log)
[22_goffice_make_with_decimal64.log](/uploads/22c4af41b00e4c48095480925ed50f4a/22_goffice_make_with_decimal64.log)
[23_goffice_make_install_with_decimal64.log](/uploads/8e4a0a790bcaa9237133cb2cd39217e2/23_goffice_make_install_with_decimal64.log)
[31_t5900-sc.pl.log](/uploads/fa53bae1f576edb635ca98a0e96de383/31_t5900-sc.pl.log)
[32_t5901-qpro.pl.log](/uploads/ee8ef57a7738733c5e763bb8be44a984/32_t5901-qpro.pl.log)
[33_t5902-applix.pl.log](/uploads/68c0f6751d02d364be8b4dba0910a688/33_t5902-applix.pl.log)
[34_t5903-sylk.pl.log](/uploads/6253835ae820845834b87b080d6935eb/34_t5903-sylk.pl.log)
[35_t5904-mps.pl.log](/uploads/8aa32af91ba3f9d21c745fc710ad583b/35_t5904-mps.pl.log)
[36_t5905_guppi.pl.log](/uploads/2f5a049b372154236b05c4aff8b26478/36_t5905_guppi.pl.log)
[37_t5906-dif.pl.log](/uploads/676137e504330ffdd216c40a13d8b95b/37_t5906-dif.pl.log)
[41_gnumeric_configure_with_decimal64.log](/uploads/32567bfc99402ddbe019d135d19339c9/41_gnumeric_configure_with_decimal64.log)
[42_gnumeric_make_with_decimal64.log](/uploads/02295392475c6f8ab88ce21bac9dc52b/42_gnumeric_make_with_decimal64.log)
[43_gnumeric_make_install_with_decimal64.log](/uploads/0f7f24b21fcd1f3cc29dbc7aeed654cd/43_gnumeric_make_install_with_decimal64.log)
[51_t5900-sc.pl.log](/uploads/cbbb77de7b213eb40ba9931b87013d1d/51_t5900-sc.pl.log)
[52_t5901-qpro.pl.log](/uploads/ba69987c903cc937b94e9c7dbdad6141/52_t5901-qpro.pl.log)
[53_t5902-applix.pl.log](/uploads/a8fe6efd61a64bded86adde9aa60b1aa/53_t5902-applix.pl.log)
[54_t5903-sylk.pl.log](/uploads/6ec3dc462967f113daffdf41c2760829/54_t5903-sylk.pl.log)
[55_t5904-mps.pl.log](/uploads/937d22ecc7b9fddf116a045e4fc5f0de/55_t5904-mps.pl.log)
[56_t5905_guppi.pl.log](/uploads/73f4f020f00d795bdbf7fe89898af384/56_t5905_guppi.pl.log)
[57_t5906-dif.pl.log](/uploads/f0b7c1e047a5b38dd65143dda0deeb12/57_t5906-dif.pl.log)https://gitlab.gnome.org/GNOME/gnumeric/-/issues/761TYPOs: Error summary, comment and reopen for new spottings ( consider spammin...2024-02-26T16:09:49Zb. s.TYPOs: Error summary, comment and reopen for new spottings ( consider spamming with separate reports overkill ).Utilies / Utilities : in src/value.c and src/value-sheet.c,Utilies / Utilities : in src/value.c and src/value-sheet.c,https://gitlab.gnome.org/GNOME/gnumeric/-/issues/760Support filepicker portal2024-03-01T19:50:37ZRandomos NamosSupport filepicker portalHey, even after passing `GTK_USE_PORTAL=1` to the Flatpak, it doesnt use the native portal.
This makes the flatpak unusable as permissions are too restricted, but also it makes it weird to use on non-GNOME desktops.
Using 1.12.57 FlatpakHey, even after passing `GTK_USE_PORTAL=1` to the Flatpak, it doesnt use the native portal.
This makes the flatpak unusable as permissions are too restricted, but also it makes it weird to use on non-GNOME desktops.
Using 1.12.57 Flatpakhttps://gitlab.gnome.org/GNOME/gnumeric/-/issues/759MATH: flt.nextafter: needs 'dispatch' for gnumeric-long ( and Dec64 ),2024-02-18T19:42:23Zb. s.MATH: flt.nextafter: needs 'dispatch' for gnumeric-long ( and Dec64 ),'=flt.nextafter( 0.5, 0 )' produces
0.4999999999999999445 in **gnumeric [bin80]** while
0.49999999999999999997 is 'nearer'.'=flt.nextafter( 0.5, 0 )' produces
0.4999999999999999445 in **gnumeric [bin80]** while
0.49999999999999999997 is 'nearer'.https://gitlab.gnome.org/GNOME/gnumeric/-/issues/758Gnumeric 1.12.57 needs Pango 1.46 or later and should check appropriately2024-02-14T01:28:28ZPeter TribbleGnumeric 1.12.57 needs Pango 1.46 or later and should check appropriatelyAttempting to compile gnumeric 1.12.57 on my system fails with:
html.c: In function 'underline_span_pango':
html.c:148:7: error: 'PANGO_UNDERLINE_SINGLE_LINE' undeclared (first use in this function); did you mean 'PANGO_UNDERLINE_SINGLE...Attempting to compile gnumeric 1.12.57 on my system fails with:
html.c: In function 'underline_span_pango':
html.c:148:7: error: 'PANGO_UNDERLINE_SINGLE_LINE' undeclared (first use in this function); did you mean 'PANGO_UNDERLINE_SINGLE'?
148 | case PANGO_UNDERLINE_SINGLE_LINE:
| ^~~~~~~~~~~~~~~~~~~~~~~~~~~
| PANGO_UNDERLINE_SINGLE
html.c:148:7: note: each undeclared identifier is reported only once for each function it appears in
html.c:153:7: error: 'PANGO_UNDERLINE_DOUBLE_LINE' undeclared (first use in this function); did you mean 'PANGO_UNDERLINE_DOUBLE'?
153 | case PANGO_UNDERLINE_DOUBLE_LINE:
| ^~~~~~~~~~~~~~~~~~~~~~~~~~~
| PANGO_UNDERLINE_DOUBLE
CC font.lo
html.c:156:7: error: 'PANGO_UNDERLINE_ERROR_LINE' undeclared (first use in this function); did you mean 'PANGO_UNDERLINE_ERROR'?
156 | case PANGO_UNDERLINE_ERROR_LINE:
| ^~~~~~~~~~~~~~~~~~~~~~~~~~
| PANGO_UNDERLINE_ERROR
These were defined in Pango as of 1.46; my system has Pango 1.44.7 (I should update).
The bug here is that the Pango version check doesn't account for this; as far as I can tell from configure.ac, it's happy to accept anything back to 1.24.0.https://gitlab.gnome.org/GNOME/gnumeric/-/issues/757Destructive autocorrect of non-date strings2024-02-12T09:12:30ZEd SiefkerDestructive autocorrect of non-date stringsWhen opening a text file with date-like text, Gnumeric interprets as a date and replaces the actual data with a date string.
This occurs even when all auto-correct options are turned off.
e.g. 4-4.5 is converted to 4/4/2005
I am awar...When opening a text file with date-like text, Gnumeric interprets as a date and replaces the actual data with a date string.
This occurs even when all auto-correct options are turned off.
e.g. 4-4.5 is converted to 4/4/2005
I am aware that prepending ' to a string will cause it to be interpreted literally, but this is not a sufficient solution. I am not generating these files and have no way to insert characters before importing them into Gnumeric.https://gitlab.gnome.org/GNOME/gnumeric/-/issues/756GUI: gnumeric dialog action blocks mouse click in other programs2024-02-11T09:13:48Zb. s.GUI: gnumeric dialog action blocks mouse click in other programsNormally one can use the mouse and work in other
programs while gnumeric is busy with some activity,
in some actions the keyboard works, while mouse is
blocked.
Simple example:
- create a cell with value 1 and background lig...Normally one can use the mouse and work in other
programs while gnumeric is busy with some activity,
in some actions the keyboard works, while mouse is
blocked.
Simple example:
- create a cell with value 1 and background light yellow,
- copy that cell to a large range, e.g. B3:AY65536,
( this takes long time, but that's another issue )
in this time you can click other windows and work there,
- remove background formatting from one column, e.g. AX,
click 'Background' in toolbar and then 'Clear Background',
( again takes long time, but that's another issue )
in this time the mouse cursor moves with my touchpad,
but no effect when I click somewhere,
re-gains normal work when gnumeric action is finished.
Think to remember that it was better some time ago,
but not sure about.
( debian / Kali Linux, actual 1.12.57 )
( me bad is always an option, apologize if )https://gitlab.gnome.org/GNOME/gnumeric/-/issues/755UI: undo - redo: delayed refresh: e.g. '= 5 + 4' -> 82024-02-11T16:41:55Zb. s.UI: undo - redo: delayed refresh: e.g. '= 5 + 4' -> 8Little oddity but may trap users.
Undo - redo doesn't instantly refresh results.
( can't say if always, can't say if single action
affected, just spotted one reproducible case. )
Simple sample:
- '= 5 + 3' in cell B2, sho...Little oddity but may trap users.
Undo - redo doesn't instantly refresh results.
( can't say if always, can't say if single action
affected, just spotted one reproducible case. )
Simple sample:
- '= 5 + 3' in cell B2, shows '8',
- change to '= 5 + 4', shows '9',
- undo ( ctrl-Z ), shows '8',
- redo ( ctrl-Y ), still shows '8'
until some other action triggering refresh,
- if you place focus on B2 before redo you get a display with:
- formula bar: '= 5 + 4', and
- cell result: '8'.
( debian / Kali Linux, actual 1.12.57, recalc **is** automatic )
( me bad is always an option, apologize if )https://gitlab.gnome.org/GNOME/gnumeric/-/issues/754Cannot copy text from Gnome Text Editor to Gnumeric2024-02-11T20:01:40ZFrédéric ParreninCannot copy text from Gnome Text Editor to GnumericI sometimes copy datasets from text files to Gnumeric.\
Previously, I was using Gedit and was copying/pasting into Gnumeric, that was working fine.\
I recently tried to switch to Gnome Text Editor, but that does not work.\
I can copy fro...I sometimes copy datasets from text files to Gnumeric.\
Previously, I was using Gedit and was copying/pasting into Gnumeric, that was working fine.\
I recently tried to switch to Gnome Text Editor, but that does not work.\
I can copy from Gnome Text Editor to Gedit and then to Gnumeric, but not directly from Gnome Text Editor to Gnumeric.\
I am not sure if this is a Gnome Text Editor issue or a Gnumeric issue.https://gitlab.gnome.org/GNOME/gnumeric/-/issues/753Release 1.12.57 for Ubuntu 14.042024-02-12T03:20:12ZFrédéric ParreninRelease 1.12.57 for Ubuntu 14.04I was just thinking that, if it is not too much work, it could be a good idea to release Gnumeric-1.12.57 in time for Ubuntu 24.04.\
There have been many interesting fixes since 1.12.56 and it would be good if they can benefit Ubuntu use...I was just thinking that, if it is not too much work, it could be a good idea to release Gnumeric-1.12.57 in time for Ubuntu 24.04.\
There have been many interesting fixes since 1.12.56 and it would be good if they can benefit Ubuntu users.\
From this web page:\
https://discourse.ubuntu.com/t/24-04-feature-freeze-and-transitions/41948 \
it seems the feature freeze date for Ubuntu 24.04 is February, 29th.