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. New to the forum? Please visit the ‘Getting Started’ link below.
Reply
Contributor
karaokemag
Posts: 26
Registered: ‎11-17-2011
My Carrier: Virgin

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 Carrier: Rogers

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 Carrier: Virgin

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 Carrier: Rogers

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 Carrier: Virgin

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 Carrier: Rogers

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 Carrier: Virgin

Re: Spreadsheet to go backwards compatibility

Thanks.
Please use plain text.