=value in reverse? (PUSH vs PULL by formula)

[StainlessB]

I have a multipage spreadsheet. I am trying to limit the main page to basic formatting and validity tables, as it is used with a python 3D scatter plot app that performs calculations and writes them to specific columns. it has been a challenge to get that code so the format doesn’t get overwritten when data is written (and saved ) to the file.

I know I can add a formula to pull data from other pages/cells, but is there a formula I can use to “send” cell values from the 2nd or 3rd page to the front page?

This is also to try and minimize potential error during manual data manipulation.

thank you in advance

[Villeroy]

=VALUE("43210") converts a text into a number (if possible).
=TEXT(43210;"@") converts a number into a text.

[StainlessB]

data is numerical. I want to know if there is a formula on one page that will populate cells on a another page.

[Lupp]

@StainlessB

… but is there a formula I can use to “send” cell values from the 2nd or 3rd page to the front page?

Short answer: No.
Explanation: Much too many and serious conflicts to be expected.

[Regina]

Spreadsheets formulas always work as PULL. To push a value to a cell, you need a macro.

[Lupp]

@Regina

To push a value to a cell, you need a macro.

The next question will be if the macro can be a function or called by a formula.
This isn’t definitely made impossible, but the conflicts I mentioned will not vanish. I would advise against the attempt. (Based on own experiments.)

[StainlessB]

thanks for the input. I’m already having issues with the pyhton script I’m using that forces data from the worksheet writing back results and removing all my formats (justification, validity, etc)

I think need to walk away for a few days

[Wanderer]

@StainlessB

script I’m using that forces data from the worksheet writing back results and removing all my formats

Open a separate question for this and show, how you write back.
Simple cop/paste may remove your formats, but there are possibilities to write contents of cells for every type.
(But my solution was to have separate data sheets where formatting is ot an issue.)

[Lupp]

@StainlessB

… and removing all my formats (justification, validity, etc)

If you want to keep formats the methods moveRange() and copyRange() of XCellRangeMovement aren’t appropriate.
If you know the data types in every case you can use assignments to either cell.Value or to cell.String for every single cell.
To be independent of the data types and -if ranges of more than one cell occur- for better efficiency you should use getDataArray() and setDataArray(). Single cells also support the service “com.sun.star.sheet.SheetCellRange”.

[StainlessB]

Thank you Wanderer and Lupp.

Things to think about. IThis is very much a work in progress