no my question is not purely theoretical.
I downloaded it from
version 7.2.7
for windows 10, 64 bit
but now my MAIN question is - why can’t I save back my spreadsheets to .xlsx???
Task Manager>Processes
CPU - Memory - Disk - Network GPU
my open Libre spreadsheets are listed there, using 160 MB of Memory. I have now closed them all so can’t take a screenshot.
Task Manager doesn’t show applications fully saved to a computer hard drive.
Usually, these “errors” come from insufficient user rights on the target directory. Double-check in the save dialog where your files are tentatively saved. If this was your first trial after installation (or the file was opened in “non-standard” ways – define this term in Windows context, M$ has sometimes strange contorted ways to lock you in its own eco-system), it may happen that the current working directory points on “system” or “library” ones where a common user has no write rights.
what do you mean by that? I do have all the user rights in all directories. Please be more specific.
again, I have no clue what this means. I don’t use libraries, MS doesn’t “lock me in” anywhere. I have all write rights everywhere on my computer.
I need to save those files back to my old format after which I will delete Libre Office as clearly it is an online application - and I did download it from the OFFICIAL site - didn’t I?
and Now - I can’t even open the earlier version of my excel document in the older version!! It opens a BLACK document!!!
what the heck is going on?? how am I supposed to recover it??? HELP!!!
this program is a trap.
I meant * BLANK*
I don’t think so. Some system directories remain excluded from “usual” user rights and require administrator rights (this is to avoid errors lethal to the computer). I can’t be more specific unless you tell us into which directory the save dialog tries to store your file. If you can’t tell, provide a screen shot of the dialog.
Perhaps not explicitly, but all apps need libraries. Since libraries are critical, they are usually protected by restricted rights so that nothing can be stored inside so that they are not damaged accidentally.
Not at all, LO is a local app. You may have a contrary impression but I would question your skill with computers. Installing an app is not a trivial task, notably under Windows. Experience (and many questions here) has shown that restarting a Windows PC usually cures many post-install problems. By “restarting”, I mean a true cold start, not the common suspend state disguised under a deceiving name in the start menu.
Do yo mean they are presently saved as .ods? If everything else fails, open them directly in Excel as it claims to be able to do it. But, as always, compatibility is not guaranteed 100%. So check the result.
Older version of Excel or Calc? Or is it the older version of the document (as an .ods or .xslx file)?
These symptoms feel like a corruption of the OS-dictionary associating the file extension to the managing association. If your files have no confidential nature, attach a problematic one so that we can see if we have the same problems here.
You might need to allow an exception in Windows Defender which is probably blocking LibreOffice from writing to the folder, see Defender Controlled folder access exception for LibreOffice - The Document Foundation Wiki
The relevant part of the Microsoft Knowledge Base article referred to in link above is Customize controlled folder access | Microsoft Docs
1 Like
Task manager shows every running task. Of course it shows applications fully saved to a computer hard drive.
You seem to do things erratically, with some strange assumptions. I cannot clearly understand what you did (including the “I have now closed them all so can’t take a screenshot” - did you use task manager to “close” the process, which is terminating it ungracefully?).
Note that I use Windows ~exclusively, and I have no problems with that - after I fixed the Windows Defender not allowing to save (for which I even created a FAQ). So I assure that it works.
I actually have pretty good computer skills.
I had 3 files saved as .ods
Luckily, all the work I did was on just one tab in two of them. And - I was able to open them in my .xlsx format, copy the new content from .ode and paste it my .xlsx. So that’s done - I can now delete those .ods files.
So the remaining issue is with the third file which happens to be the most important so I MUST be able to open it in .xlsx
The question is:
How come I can open 2 of them in .xlsx but not the 3rd one?
All the .ods files were saved exactly where I wanted to save them - on my D Drive (datadrive) in their respective folders. My files ARE personal and confidential so no, there is no way in the world I could attach them anywhere.
My Windows Defender is disabled. I use another firewall program.
LIbreOffice is not blocked to write in anywhere. I can still edit those files. I didn’t close anything in Task Manager.
My ONLY urgent issue now is to be able to open my 3rd excel document in .xlsx
I can’t open even the much earlier versions of this document saved on my drive under different names… Why??
Now re-reading the phrase, I suppose that you meant that you worked on spreadsheets in ODS format, and now that you try to export to XLSX, it gives an empty XLSX. But I hope that you still have your ODS intact, right?
Bugs happen. It may well be that you somehow hit some bug, preventing your file form export. You write:
You behave as someone had promised you something, and is now cheating. No, there were no promises that there are no errors at all. Saving to external formats shows a dialog with a warning. Of course, a clean spreadsheet is a bug - but still not something dishonest, only something that needs to be filed as a bug to be fixed.
which is most unfortunate, since unless you provide a sample to reproduce, there’s no way in the world anything could be fixed… maybe you could sanitize the ODS?
In the meantime, you could try to save as XLS.
Some anti virus programs, such as AVG or Avast, allow a program to write a file once to the folder but then block all further edit attempts to existing files unless the program is in the Allowed list in the Anti-ransomware settings. How to use the Blocked & Allowed apps settings | AVG
You might not use AVG but then you must check the settings for the anti-virus program you have.
Note that “firewalls” are unrelated: LibreOffice does not need to access Internet. The advices from @EarnestAl are about antivirus software, that may block local disk access. Indeed, cleaning your messages from emotional stuff and assumptions, it looks like antivirus is not an issue, but still I write this to help avoid a misconception that had started this thread.
I beg to differ here. From experience, AVG appears to change permissions on files (not folders) and act as gatekeeper so only Allowed programs can edit existing files.
A program not in the Allowed list can Save As to a folder but cannot write to the file again so a subsequent Save, even in the same session, brings an error along these lines:
Error saving the document (…) :
Object not accessible.
The object cannot be accessed due to insufficient user rights.
If the error is ignored nothing further will be written to the file. This seems to match the description by @quantum88 : a blank file written to disk, & “I can’t even open the earlier version of my excel document in the older version!! It opens a BLANK document”.
Because the permissions are written in the operating system, even if AVG is turned off the files still cannot be written to. This is also problematic on a shared network.
Your “Support” forum BLOCKED me last night from posting saying that as a new member I’m posting too much (!?) while I was in a middle of resolving an URGENT issue, and told me to come back after 22 hrs.
Seriously??.. This forum is as bad as your Libre program, which as far as I’m concerned is still in BETA full of issues and bugs.
I don’t know if and when you will get this message, but all I want to tell you (all contributors to this conversation) that EACH AND EVERY ONE OF YOU WAS WRONG.
I have now resolved the issue.
It had NOTHING to do with the user rights, or the firewall, or my “lack of computer skills”, or the corruption of any program on my computer, or my internet security program, or my antivirus, or pasting objects, or a shared network, or ANY of the things pointed to in this conversation by its contributors – some of whom consider themselves to be experts on Libre.
Your good intention to help (thanks!) doesn’t change the fact that you simply don’t know this program in terms of its compatibility with MS Excel - because THAT was the issue which no one has even mentioned.
You were all looking for the complex causes in my computer and my programs - while the issue was with Libre. Not even a one off glitch or a bug, but its SYSTEMIC BUILT IN conflict with Excel which makes is INCOMPATIBLE with it and should carry a warning for those who seek to transition back and forth between these programs.
The issue was very simple, not complex, and my Excel program was finally able to REPAIR the damage done by your beta Libre to my files.
I have wasted A LOT OF MY TIME – several hours - on sorting out this damage while in a middle of an urgent project, and I’m absolutely appalled by this forum arbitrarily BLOCKING me with no intelligence to recognise the urgency and importance of this conversation, which by my standards is beyond unacceptable.
My only fault was to download this dangerous beta program. I did have some warning signs, like issues posted 2 years ago on your improvement hub which to this date have not been fixed, which unfortunately I have ignored. NEVER AGAIN.
LIbreOffice IS in BETA. Perhaps in a perpetual BETA given that this version was released few years ago. Do not hide it, do not disguise it. Yes, it is free to use, maybe that’s part of the problem.
In just a few days of using two of the apps I already came across a number of issues which are frustrating but small and very easy to fix. Someone said on another topic that “Libre is an evolving program”. Evolving means improving from good to better. It does not mean released with many issues and bugs, not fully tested, and leaving it to the users to find and report them.
I will be sharing my experience with anyone I know who are even contemplating using this program transitioning from excel to warn them about the consequences.
goodbye
@mikekaganski @EarnestAl
please see my final reply above.
This forum allows me to list no more than 2 users (???) in a post.
@ajlittoz
please see my final reply above.
this is the most user unfriendly forum I have ever seen. Blocks the new users, limits the number of names in their posts. Unbelievable.
Lol.
goodbye, and try to build reasonable expectations.