Problem importing off-sheet references in a .csv, using ssconvert

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Problem importing off-sheet references in a .csv, using ssconvert

Peter Brooks
I have this working, using gnumeric ssconvert:


ssconvert --merge-to=merged.xls test1.csv test2.csv test3.csv

It happily imports formulae, such as '=MIN(G2:G4)' correctly.


The problem I have is with off-sheet references. How do I, with the
above setup, get a cross-sheet reference to work. For example, in
'test3.csv':


     =('test1.csv'.G11+'test1.csv'.G8)

When I try this, if converts the off-sheet references to text. I have
tried doing this with libreoffice calc and os/x numbers - I even tried
the numbers reference format:


     test1.csv::Table 1::G8

It still doesn't work.

Any suggestions gratefully received!


--
Peter Brooks


Mobile: +27 82 717 6404
Direct:  +27 21 447 9752
Skype:  Fustbariclation
Twitter: Fustbariclation
Google+: Fustbariclation
Author Page: amazon.com/author/peter_brooks
_______________________________________________
gnumeric-list mailing list
[hidden email]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

RE: Problem importing off-sheet references in a .csv, using ssconvert

Prakhar Mehrotra
Please keep me out of this email chain

Regards,
Prakhar Mehrotra ,   MIS Infra
Unix Administrator
IT Engineering and Business Technologies Operations Group -
IT, Global Business Technologies Group


I +91-20401-54987 (Desk)  +91-7709952870 (Mob)
AMDOCS | EMBRACE CHALLENGE EXPERIENCE SUCCESS


-----Original Message-----
From: gnumeric-list [mailto:[hidden email]] On Behalf Of Peter Brooks
Sent: Monday, December 19, 2016 1:05 AM
To: [hidden email]
Subject: Problem importing off-sheet references in a .csv, using ssconvert

I have this working, using gnumeric ssconvert:


ssconvert --merge-to=merged.xls test1.csv test2.csv test3.csv

It happily imports formulae, such as '=MIN(G2:G4)' correctly.


The problem I have is with off-sheet references. How do I, with the above setup, get a cross-sheet reference to work. For example, in
'test3.csv':


     =('test1.csv'.G11+'test1.csv'.G8)

When I try this, if converts the off-sheet references to text. I have tried doing this with libreoffice calc and os/x numbers - I even tried the numbers reference format:


     test1.csv::Table 1::G8

It still doesn't work.

Any suggestions gratefully received!


--
Peter Brooks


Mobile: +27 82 717 6404
Direct:  +27 21 447 9752
Skype:  Fustbariclation
Twitter: Fustbariclation
Google+: Fustbariclation
Author Page: amazon.com/author/peter_brooks
_______________________________________________
gnumeric-list mailing list
[hidden email]
https://mail.gnome.org/mailman/listinfo/gnumeric-list

This message and the information contained herein is proprietary and confidential and subject to the Amdocs policy statement,
you may review at http://www.amdocs.com/email_disclaimer.asp
_______________________________________________
gnumeric-list mailing list
[hidden email]
https://mail.gnome.org/mailman/listinfo/gnumeric-list
Loading...