Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

Reply
Contributor
karaokemag
Posts: 26
Registered: ‎11-17-2011
My Device: PB 64 and BB9810

Spreadsheet to go backwards compatibility

Spreadsheet to go in 2.0 dosnt support formulas that 1.08 did. Any updates expected. 

 

Please use plain text.
Product Manager
mclewley
Posts: 214
Registered: ‎09-12-2008
My Device: BlackBerry 9900

Re: Spreadsheet to go backwards compatibility

Thanks for the question, OS 2.0 should support more than what's in 1.0.x.  If you have a specific example let me know. 

Michael Clewley
Senior Product Manager, BlackBerry Software
Research In Motion
Please use plain text.
Contributor
karaokemag
Posts: 26
Registered: ‎11-17-2011
My Device: PB 64 and BB9810

Re: Spreadsheet to go backwards compatibility

Linking fields in a different spreadsheet. In the same work book. Even “=+a1“ dosnt work. They display "value"

Please use plain text.
Product Manager
mclewley
Posts: 214
Registered: ‎09-12-2008
My Device: BlackBerry 9900

Re: Spreadsheet to go backwards compatibility

Having a discussion with the teams and this is what I got back

 

This works correctly for things like:

=Sheet1!A5
=Sheet1!A5 + Sheet3!A4
Etc.

Things like '=+A50' work too, provided the target in A50 is actually a number that can be added (if A50 has text, the VALUE error would show).

 

Do you have a sample of your worksheet?

Michael Clewley
Senior Product Manager, BlackBerry Software
Research In Motion
Please use plain text.
Contributor
karaokemag
Posts: 26
Registered: ‎11-17-2011
My Device: PB 64 and BB9810

Re: Spreadsheet to go backwards compatibility

Fields are text, excel formats the formula,

"=+'sheet2'!h7"

And "=+a2"

 

I can send a sample, files were saved as excel 2003-2007 compatible 

 

 

Please use plain text.
Product Manager
mclewley
Posts: 214
Registered: ‎09-12-2008
My Device: BlackBerry 9900

Re: Spreadsheet to go backwards compatibility

Team found the issue and are working a fix now, thanks for your feedback!

Michael Clewley
Senior Product Manager, BlackBerry Software
Research In Motion
Please use plain text.
Contributor
karaokemag
Posts: 26
Registered: ‎11-17-2011
My Device: PB 64 and BB9810

Re: Spreadsheet to go backwards compatibility

Thanks.
Please use plain text.