Pasting Excel formulas
b4too opened this issue · 0 comments
b4too commented
Hello,
I can't find a way to save these formulas as a memo in a note :
=CONCATENER("insert into parameters values ('outlet_id_";D1;E1;"','IF_TAX','outlet_id_";D1;E1;"','";F1;";";H1;"','outlet_id_";D1;E1;"','string');";)
=CONCATENER("insert into parameters values ('service_id_";D1;E1;"','IF_TAX','service_id_";D1;E1;"','";G1;";";H1;"','service_id_";D1;E1;"','string');";)
=SI(C5="";SI(C4="";SI(C3="";SI(C2="";C1;C2);C3);C4);C5)
I tried to add a string ( 'Formula' ) in front of '=' in case the '=' was interpreted but I can't get it to save it.
I can paste it but not save it.
Steps to reproduce the behavior:
- Go to a newly created note
- Paste the formulas
- Quit
- See that it won't be saved
Done on image linuxserver/nextcloud:latest on Docker 20.10.7 on linux, amd64 with latest update of Carnet