Exclude cell from being saved
-
- Posts: 43
- Joined: Sun Nov 30, 2008 12:44 am
Exclude cell from being saved
Hello,
I have a spreadsheet in Calc that is shared between six users. Only problem is that there are two cells with drop down selections that it tries to save and the dialog box comes up with conflicts. Now for my question. Is there anyway I can exclude these two cells selected values from being saved? Appreciate some insight.
Thanks much,
Gibs
I have a spreadsheet in Calc that is shared between six users. Only problem is that there are two cells with drop down selections that it tries to save and the dialog box comes up with conflicts. Now for my question. Is there anyway I can exclude these two cells selected values from being saved? Appreciate some insight.
Thanks much,
Gibs
OOo 4.1.X on MS Windows 7 UltimateX64, Open Office Calc
Re: exclude cell from being saved
Are those dropdown selections form control elements or are you using the 'Data validity' function?Only problem is that there are two cells with drop down selections that it tries to save and the dialog box comes up with conflicts.
(Plese upload an example .ods file here.)
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
-
- Posts: 43
- Joined: Sun Nov 30, 2008 12:44 am
Re: exclude cell from being saved
Hi,
Thanks for the reply. The drop downs are form controls ran in vb. I've uploaded a sample of it.
Thanks,
Gibs
Thanks for the reply. The drop downs are form controls ran in vb. I've uploaded a sample of it.
Thanks,
Gibs
- Attachments
-
- Custom autofilter-1.ods
- (26.79 KiB) Downloaded 107 times
OOo 4.1.X on MS Windows 7 UltimateX64, Open Office Calc
Re: exclude cell from being saved
The code is not VB (= Visual Basic); it is StarBasic and some AOO/LO API functions. (API = Application Programming Interface)The drop downs are form controls ran in vb
(It will not run in M$ Excel)
I can not see any form control dropdown objects in your attached document...
The cells D1, D2 contain 'Data validity' function.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
-
- Posts: 43
- Joined: Sun Nov 30, 2008 12:44 am
Re: exclude cell from being saved
i didn't write it. Is there any way to do this?
OOo 4.1.X on MS Windows 7 UltimateX64, Open Office Calc
Re: exclude cell from being saved
I thinkt it: there is not way to save a document partially only...
But you can save a COPY of your document by a macro code and the API function 'StoreAs...()'...or 'StoreTo...()'.
The six users want to open, edit and save the shared document in same time (paralell)?
But you can save a COPY of your document by a macro code and the API function 'StoreAs...()'...or 'StoreTo...()'.
The six users want to open, edit and save the shared document in same time (paralell)?
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
-
- Posts: 43
- Joined: Sun Nov 30, 2008 12:44 am
Re: exclude cell from being saved
The six users work at the same time. It's just that it is a lot of work to maintain separate spreadsheets so I've combined all into one hoping that I could now just maintain one.
OOo 4.1.X on MS Windows 7 UltimateX64, Open Office Calc
Re: exclude cell from being saved
Sorry, I have not experience with shared documents.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: exclude cell from being saved
You could write a macro for the document close event to reset those cells to values of your choice. I presume anyway.
Windows 10, Openoffice 4.1.11, LibreOffice 7.4.0.3 (x64)
-
- Posts: 43
- Joined: Sun Nov 30, 2008 12:44 am
Re: exclude cell from being saved
Make a macro to set both drop downs back to the first choice in the box so no changes are made when saved after the filter is applied? That's a thought. Thanks
OOo 4.1.X on MS Windows 7 UltimateX64, Open Office Calc