Dear visitor, welcome to Palo Community Forum.
If this is your first visit here, please read the Help. It explains in detail how this page works.
To use all features of this page, you should consider registering.
Please use the registration form, to register here or read more information about the registration process.
If you are already registered, please login here.
3.0 problem with Snapshot
Hi,
I've got a problem with Palo 3.0 and the snapshot.
The Snapshot with Palo 2.0 was a very good function. Palo-formulars changed to values Excel-formulars are still there.
Palo 3.0 every cell in the Excel sheet has a value. All formulars are gone.
Is it possible to change an option to get the same result as in version 2.0
regards
hhtina
No - it's
bad.
Did not know it worked in 2.x - thought it would make a good feature for 3.1...
I am using v2.5 and snapshot feature does not work. It takes out all formulas and paste as values regardless of whether it's PALO or Excel.
One could write a Palo-Formular-Replacer (TM pending
).
pseudo code:
|
Source code
|
1
2
3
4
5
6
7
|
for each cell in worksheet do {
if cell.formula contains "PALO." then {
valuesaver= cell.value
cell.formula = nothing
cell.value= valuesaver
}
}
|
Hi axi,
thanks for that very good hint.
If I do understand you right you would write a makro to change every Palo-Formular into a value.
I've already tried to make a snapshot with a guarded sheet (the locked cells contained Excel formulars.) That worked fine.
That makes me think of writing a makro to change the format of every cell with a Paloformular from locked to unlocked. If the sheet is guarded I can make a snapshot.
Best regards
hhtina
Hallo axi,
danke für den guten Hinweis.
Wenn ich Dich recht verstanden habe, dann würdest Du ein Makro schreiben, welches jede Palo Formel durch einen Wert ersetzt.
Ich habe bereits einen snapshot gemacht, bei dem das Tabellenblatt einen Blattschutz hatte (die gesperrten Zellen enthielten die ExcelFormeln). Das ging prima.
Nun überlege ich ob ich ein Makro schreiben sollte, welches alle Zellen die eine Paloformel enhalten von gesperrt auf entsperrt setzt. Bei eingeschaltetem Blattschutz könnte ich dann einen snapshot machen.
Viele Grüße
hhtina
Snapshot-feature that is most important for me:
Users without the Palo-Addin or access to the server can see the numbers...
