Gentoo Forums
Gentoo Forums
Gentoo Forums
Quick Search: in
[SOLVED]LibreOffice - spreadsheet converting number to words
View unanswered posts
View posts from last 24 hours

 
Reply to topic    Gentoo Forums Forum Index Desktop Environments
View previous topic :: View next topic  
Author Message
Joseph_sys
Advocate
Advocate


Joined: 08 Jun 2004
Posts: 2571
Location: Edmonton, AB

PostPosted: Sun Jul 09, 2017 5:54 am    Post subject: [SOLVED]LibreOffice - spreadsheet converting number to words Reply with quote

I'm using one of those extension (macro) in libreoffice which converts
number to text: numbertext-0.9.5.oxt

So for example in a spreadsheet I have formula =MONEYTEXT(E34,"CAD")
and it gives me: Err.504 (Function parameter is not valid, for example,
text instead of a number, or a domain reference instead of cell
reference.) which is impossible as it worked before.

I just upgraded to: libreoffice-5.2.7.2
and the formula above worked fine in: libreoffice-5.2.3.3-r1 (but this ver. is no
longer in portage).
_________________
#Thelma


Last edited by Joseph_sys on Sun Jul 09, 2017 5:17 pm; edited 1 time in total
Back to top
View user's profile Send private message
Etal
Veteran
Veteran


Joined: 15 Jul 2005
Posts: 1696

PostPosted: Sun Jul 09, 2017 2:15 pm    Post subject: Reply with quote

Sounds like a regression. I would report it to LibreOffice upstream.

In the meantime, you could try restoring the 5.2.3.3-r1 ebuild from this revision:
https://gitweb.gentoo.org/repo/gentoo.git/tree/app-office/libreoffice?id=acf6854e365506853b6c34b17665480e5ce4f011
_________________
“And even in authoritarian countries, information networks are helping people discover new facts and making governments more accountable.”– Hillary Clinton, Jan. 21, 2010
Back to top
View user's profile Send private message
Joseph_sys
Advocate
Advocate


Joined: 08 Jun 2004
Posts: 2571
Location: Edmonton, AB

PostPosted: Sun Jul 09, 2017 3:20 pm    Post subject: Reply with quote

Etal wrote:
Sounds like a regression. I would report it to LibreOffice upstream.

In the meantime, you could try restoring the 5.2.3.3-r1 ebuild from this revision:
https://gitweb.gentoo.org/repo/gentoo.git/tree/app-office/libreoffice?id=acf6854e365506853b6c34b17665480e5ce4f011


I'm trying to install older version from overlay. I found:
https://gpo.zugaina.org/app-office/libreoffice
run "layman -a geki" (it was added OK)
but "eshowkw libreoffice" does not list older versions. Why?
Code:
eshowkw libreoffice
Keywords for app-office/libreoffice:
           |                                 |   u   | 
           | a a         p s   a     n r     |   n   | 
           | l m   h i   p p   r m m i i s   | e u s | r
           | p d a p a p c a x m i 6 o s 3   | a s l | e
           | h 6 r p 6 p 6 r 8 6 p 8 s c 9 s | p e o | p
           | a 4 m a 4 c 4 c 6 4 s k 2 v 0 h | i d t | o
-----------+---------------------------------+-------+-------
[I]5.2.7.2 | o + ~ o o o o o + o o o o o o o | 6 o 0 | gentoo
   5.3.3.2 | o ~ ~ o o o o o ~ o o o o o o o | 6 #   | gentoo
   5.3.4.2 | o ~ ~ o o o o o ~ o o o o o o o | 6 o   | gentoo
  5.3.9999 | o o o o o o o o o o o o o o o o | 6 #   | gentoo
  5.4.9999 | o o o o o o o o o o o o o o o o | 6 #   | gentoo
      9999 | o o o o o o o o o o o o o o o o | 6 o   | gentoo

_________________
#Thelma
Back to top
View user's profile Send private message
Hu
Moderator
Moderator


Joined: 06 Mar 2007
Posts: 14169

PostPosted: Sun Jul 09, 2017 4:23 pm    Post subject: Reply with quote

From man eshowkw:
man eshowkw:
OPTIONS
       -O | --overlays
              Search overlays (default: False)
Try passing --overlays. Alternatively, just tell Portage to pretend-install the version you want. If it shows an error, you have more configuration changes to make. Otherwise, it's ready to try.
Back to top
View user's profile Send private message
Joseph_sys
Advocate
Advocate


Joined: 08 Jun 2004
Posts: 2571
Location: Edmonton, AB

PostPosted: Sun Jul 09, 2017 5:16 pm    Post subject: Reply with quote

I compiled next version libreoffice-5.3.3.2 and formula
Code:
=MONEYTEXT(E34,"CAD")
works with "numbertext-0.9.5.oxt" so I think I'll stick with it for a while.
_________________
#Thelma
Back to top
View user's profile Send private message
Joseph_sys
Advocate
Advocate


Joined: 08 Jun 2004
Posts: 2571
Location: Edmonton, AB

PostPosted: Sun Jul 09, 2017 5:23 pm    Post subject: Reply with quote

Hu wrote:
From man eshowkw:
man eshowkw:
OPTIONS
       -O | --overlays
              Search overlays (default: False)
Try passing --overlays. Alternatively, just tell Portage to pretend-install the version you want. If it shows an error, you have more configuration changes to make. Otherwise, it's ready to try.


I've pulled overlay "geki" which should show "libreoffice-5.2.4.2" but
Code:
eshowkw -O libreoffice
Keywords for app-office/libreoffice:
           |                                 |   u   | 
           | a a         p s   a     n r     |   n   | 
           | l m   h i   p p   r m m i i s   | e u s | r
           | p d a p a p c a x m i 6 o s 3   | a s l | e
           | h 6 r p 6 p 6 r 8 6 p 8 s c 9 s | p e o | p
           | a 4 m a 4 c 4 c 6 4 s k 2 v 0 h | i d t | o
-----------+---------------------------------+-------+-------
   5.2.7.2 | o + ~ o o o o o + o o o o o o o | 6 o 0 | gentoo
[I]5.3.3.2 | o ~ ~ o o o o o ~ o o o o o o o | 6 #   | gentoo
   5.3.3.2 | o ~ ~ o o o o o ~ o o o o o o o | 6 #   | geki 
   5.3.4.2 | o ~ ~ o o o o o ~ o o o o o o o | 6 #   | gentoo
   5.3.4.2 | o ~ ~ o o o o o ~ o o o o o o o | 6 o   | geki 
  5.3.9999 | o o o o o o o o o o o o o o o o | 6 #   | gentoo
  5.4.9999 | o o o o o o o o o o o o o o o o | 6 #   | gentoo
      9999 | o o o o o o o o o o o o o o o o | 6 o   | gentoo
is not showing it :-/
_________________
#Thelma
Back to top
View user's profile Send private message
asturm
Developer
Developer


Joined: 05 Apr 2007
Posts: 7135
Location: Austria

PostPosted: Sun Jul 09, 2017 5:25 pm    Post subject: Reply with quote

So did you report the bug to LibreOffice?
_________________
backend.cpp:92:2: warning: #warning TODO - this error message is about as useful as a cooling unit in the arctic
Back to top
View user's profile Send private message
Joseph_sys
Advocate
Advocate


Joined: 08 Jun 2004
Posts: 2571
Location: Edmonton, AB

PostPosted: Sun Jul 09, 2017 5:27 pm    Post subject: Reply with quote

asturm wrote:
So did you report the bug to LibreOffice?


Yes, I did:
https://bugs.documentfoundation.org/show_bug.cgi?id=109036
_________________
#Thelma
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic    Gentoo Forums Forum Index Desktop Environments All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum