Exclude cell from being saved

[gibsongk55]

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

[Zizi64]

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.

Are those dropdown selections form control elements or are you using the 'Data validity' function?
(Plese upload an example .ods file here.)

[gibsongk55]

Hi,

Thanks for the reply. The drop downs are form controls ran in vb. I've uploaded a sample of it.

Thanks,

Gibs

[Zizi64]

The drop downs are form controls ran in vb

The code is not VB (= Visual Basic); it is StarBasic and some AOO/LO API functions. (API = Application Programming Interface)
(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.

[gibsongk55]

i didn't write it. Is there any way to do this?

[Zizi64]

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)?

[gibsongk55]

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.

[Zizi64]

Sorry, I have not experience with shared documents.

[JeJe]

You could write a macro for the document close event to reset those cells to values of your choice. I presume anyway.

[gibsongk55]

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