Forum Discussion
Non-active references to text formated cells
- Is calculation set to manual by any chance? Formula tab, Calculation options drop-down.
Hello,
The calculation of formulas is set to automatic. The data I am trying to reference is a report from extrnal app. it is generated as csv and pasted into excel as string values. I need to reference that data into main part of excel document. The cells are formatted as 'general' both in the source worksheet as in the worksheet with formulas.
Raport1,2, 3 are the worksheets with source data. Other worsheets take the data from there. E.g. see Ingredients Hazard Analysis. It is enough to click in the formula bar to activate the links. Otherwise those are dead.
That report is generated by regular worker who should not play with excel file to circumvent the software issues.
I have described that replace = with = is one of the ways to activate the links. Another one is to tick on/off 'Options>Advanced>Lotus Compatibility settings for //>transition formula evaluation.
However , one must do that operation for every worksheet with those links, and actual setting of that option does not matter. If it is 'on' it must be switched off, it it is off it must be switched on.
Maybe there are some other settings/or some combinations of those settings which I am not aware off. To be honest I do not understand what this 'lotus compatibility option' is , I came accross it working on some other issue which was resolved in the meantime,
- Got it. Can you provide an example of such a file and perhaps explain how the application you created creates the Excel file?
Hello,
Most of the xlsx file is formatted and with some content. There are three blank sheets Report 1, 2 and 3. The file is uploaded into Postgres through Django app. The Django app generates report data in a form of 3 csv files and is passing it together with the template to Java app. Java wrtites the content of CSVs to Report1, 2 and 3 worksheets and generates complete report file to the user. Attached the final file.