Skip to Main Content
Jedox Ideas

Let us know how we can make Jedox even better!

Status Not Planned
Workspace Jedox Platform
Categories Other
Created by Guest
Created on Jul 2, 2019

Excel / Spreadsheets: paste relative or fixed formulas

Please consider an enhancement to Jedox Paste data function and Paste view. This would allow the user to select whether the Excel formula would be relative or fixed before pasting into a spreadsheet. This would help in building spreadsheet and web models. It is available in TM1.
  • ADMIN RESPONSE
    Nov 6, 2020

    Thanks for the idea. This feature has been evaluated by us and we will not implement at this time. While we could see some benefit, in many cases the relativity you need for specific references in the formula might only be partial (just the row and/or column relative.

    Similar to Microsoft Excel, references can be easily adjusted by using the F4 key.

  • Attach files
  • Guest
    Jul 2, 2019
    Hi, to consider this request, we need some additional information. Which parts of the formula would like to be fixed or relative exactly - I'm assuming you mean cell references? Could you share an example?