Search found 15 matches

by taxedserf
Sun Aug 19, 2018 7:20 am
Forum: Non-technical Questions
Topic: Calc has stopped me migrating from Windows to Linux Mint
Replies: 32
Views: 1408

Re: Calc has stopped me migrating from Windows to Linux Mint

Instead of SUMIF have you tried SUMPRODUCT, infinitely more flexible! And I think the syntax is more understandable and you can have as many tests/conditional expressions as you want. :) I've never used =SUMPRODUCT(). At first glance, Ockham's Razor looks appealing: =SUMIF() is all the functionalit...
by taxedserf
Sun Aug 19, 2018 7:05 am
Forum: Non-technical Questions
Topic: Calc has stopped me migrating from Windows to Linux Mint
Replies: 32
Views: 1408

Re: Calc has stopped me migrating from Windows to Linux Mint

- You can use MS Office online or "Office 365" using your browsers on any operating system. Yes, but at additional cost. I've already bought a licence for MS Office 2016. I'd like to avoid buying the same functionality more than once. - Google Sheets part of Google Docs may work for you too. Yes, G...
by taxedserf
Sun Aug 19, 2018 6:50 am
Forum: Non-technical Questions
Topic: Calc has stopped me migrating from Windows to Linux Mint
Replies: 32
Views: 1408

Re: Calc has stopped me migrating from Windows to Linux Mint

What happens when, instead of using .ODS in Calc, you save the files as .XLSX? That is outside the scope of my project , which is to migrate from Windows/Excel to Linux/Calc (or, now, Linux/TBC). The reverse migration is down to somebody else! However, I did discover a taste of the failures to come...
by taxedserf
Sun Aug 19, 2018 6:43 am
Forum: Non-technical Questions
Topic: Calc has stopped me migrating from Windows to Linux Mint
Replies: 32
Views: 1408

Re: Calc has stopped me migrating from Windows to Linux Mint

Instead of trying to find compatibility, why not just move to Calc (or other spreadsheet apps for Linux) and change the way you link your workbook files? Calc's failure was an inability to reliably operate =SUMIF() with a linked workbook. What would be the alternative workaround methodology with wh...
by taxedserf
Sun Aug 19, 2018 6:32 am
Forum: Non-technical Questions
Topic: Calc has stopped me migrating from Windows to Linux Mint
Replies: 32
Views: 1408

Re: Calc has stopped me migrating from Windows to Linux Mint

lsemmens wrote:
Wed Aug 15, 2018 10:30 pm
I can see the problems if you use a lot of automation in excel i.e. VBA.
Yes, VBA automation would be a major issue in my work environment.

In my home environment, VBA does not apply. Here, Calc's Achilles Heel was an inability to use =SUMIF(), =VLOOKUP() etc reliability with a linked workbook.
by taxedserf
Sun Aug 19, 2018 5:18 am
Forum: Non-technical Questions
Topic: Calc has stopped me migrating from Windows to Linux Mint
Replies: 32
Views: 1408

Re: Calc has stopped me migrating from Windows to Linux Mint

I'm running office 2013 under mint 18.3 via crossover and used to run office 2007 under wine. Also have office 2016 running in a vm. What's the problem? I earn my living with excel. How have you solved Microsoft licencing requirements? How did you recognise and resolve the security issues of using ...
by taxedserf
Sun Aug 19, 2018 5:17 am
Forum: Non-technical Questions
Topic: Calc has stopped me migrating from Windows to Linux Mint
Replies: 32
Views: 1408

Re: Calc has stopped me migrating from Windows to Linux Mint

Who claimed that Excel was a cross-platform/multi-platform application? No-body. Are the same erroneous claims being made for the rest of MS-Office? No. IMO, this is an unreasonable expectation, and you are setting yourself (and Calc) up for failure. So, by analogy, I go to buy a brand new chisel t...
by taxedserf
Sun Aug 19, 2018 4:56 am
Forum: Non-technical Questions
Topic: Calc has stopped me migrating from Windows to Linux Mint
Replies: 32
Views: 1408

Re: Calc has stopped me migrating from Windows to Linux Mint

Alas, what's the likelihood of Microsoft playing nice and sharing? With no evidence to the contrary, I would assume a zero likelihood. My expectation of LibreOffice - and all other competitors to Microsoft Office - is that they read, re-read, re-re-read Microsoft documentation to find out what the ...
by taxedserf
Sun Aug 19, 2018 4:51 am
Forum: Non-technical Questions
Topic: Calc has stopped me migrating from Windows to Linux Mint
Replies: 32
Views: 1408

Re: Calc has stopped me migrating from Windows to Linux Mint

Have you considered using Excel in a Windows Virtual Machine, within Linux? Yes. At this stage of the project's roadmap, I aim to eliminate Microsoft from my life. So I have deferred the use of virtual machines/translation layers to enable Microsoft apps to run within Linux. What are the Microsoft ...
by taxedserf
Sat Aug 18, 2018 3:25 pm
Forum: Non-technical Questions
Topic: Calc has stopped me migrating from Windows to Linux Mint
Replies: 32
Views: 1408

Re: Calc has stopped me migrating from Windows to Linux Mint

Thanks all for your responses and suggestions for further testing. This proves the merit of going to a community and/or the open-source world, and again underlines why Linux Mint is a great destination to which to travel. Many of your suggestions are all good to add to the (already long and now grow...
by taxedserf
Tue Aug 14, 2018 5:59 pm
Forum: Non-technical Questions
Topic: Calc has stopped me migrating from Windows to Linux Mint
Replies: 32
Views: 1408

Calc has stopped me migrating from Windows to Linux Mint

Well, in spite of some significant effort to try to have Linux Mint replace Windows, it seems that I have failed, because LibreOffice Calc cannot do the basic functionality of Microsoft Excel (specifically, linked workbooks). The full test data, complete with methodology and screenshots, was sent to...
by taxedserf
Sun May 13, 2018 5:49 am
Forum: Newbie Questions
Topic: [UNSOLVED ABANDONED] File sharing between Win10x64 and Linux Mint Xfce 18.3 Sylvia 64-bit
Replies: 9
Views: 499

Re: File sharing between Win10x64 and Linux Mint Xfce 18.3 Sylvia 64-bit

Many thanks for your support, especially altair4 who went to the point of re-engineering problems to need a fresh re-installation! I shall abandon this part of my project for now. I wonder whether this particular incident has something to do with Microsoft quietly smuggling protocol SMB1 out as a de...
by taxedserf
Sun May 06, 2018 5:14 am
Forum: Newbie Questions
Topic: [UNSOLVED ABANDONED] File sharing between Win10x64 and Linux Mint Xfce 18.3 Sylvia 64-bit
Replies: 9
Views: 499

Re: File sharing between Win10x64 and Linux Mint Xfce 18.3 Sylvia 64-bit

Debug as follows. On MINT: administrator@GANDALF ~ $ net usershare info --long info_fn: file /var/lib/samba/usershares/documents is not a well formed usershare file. info_fn: Error was Path is not a directory. info_fn: file /var/lib/samba/usershares/grive is not a well formed usershare file. info_fn...
by taxedserf
Sun Apr 29, 2018 6:40 am
Forum: Newbie Questions
Topic: [UNSOLVED ABANDONED] File sharing between Win10x64 and Linux Mint Xfce 18.3 Sylvia 64-bit
Replies: 9
Views: 499

Re: File sharing between Win10x64 and Linux Mint Xfce 18.3 Sylvia 64-bit

No solution, I'm afraid. Long debug process follows. In MINT: administrator@GANDALF ~ $ hostname GANDALF In WIN: Run "\\GANDALF.local" Error, "Windows cannot access \\GANDALF.local" Code 0x80070035 The network path was not found. In WIN's MS-DOS prompt: C:\Users\WIN>tracert GANDALF.local Unable to r...
by taxedserf
Sat Apr 28, 2018 7:22 am
Forum: Newbie Questions
Topic: [UNSOLVED ABANDONED] File sharing between Win10x64 and Linux Mint Xfce 18.3 Sylvia 64-bit
Replies: 9
Views: 499

[UNSOLVED ABANDONED] File sharing between Win10x64 and Linux Mint Xfce 18.3 Sylvia 64-bit

Help! I can't get Windows 10 and Linux Mint Xfce 18.3 to see eachother on the same network to share/sync files. Environment and desired functionality: Two laptops: one Win10x64 ("WIN"), one Linux Mint fce 18.3 Sylvia 64-bit ("MINT") WIN is the primary machine, MINT is currently an experimental deplo...

Go to advanced search