In which @Captain asks questions about Microsoft Office
-
@Lorne-Kates said in In which @Captain asks questions about Microsoft Office:
That F4 thing is neat. I'll contribute a tidbit.
CTRL+;
Enters the current date in the current cell.
And CTRL+: for the time.
-
OK, here's a new question about Office: What does SharePoint do?
-
@Captain said in In which @Captain asks questions about Microsoft Office:
OK, here's a new question about Office: What does Sharebuilder do?
Google fails me. Top results for "microsoft office sharebuilder" are about buying stocks.
-
@dcon Yeah, it's weird. It's some kind of collaboration tool but I can't get a clear answer what it does.
What I really want is to make workflows and forms with Office 365. Ideally, I'd like to be able to run PowerShell scripts too, but I suspect there won't be any hooks with Office 365.
-
@Captain said in In which @Captain asks questions about Microsoft Office:
OK, here's a new question about Office: What does Sharebuilder do?
Is that even a thing? It's not on Microsoft's website for Office, and it'd be really weird for them to take a name that's already a stock trading site... Googling it brings up nothing.
EDIT:
@Captain said in In which @Captain asks questions about Microsoft Office:
What I really want is to make workflows and forms with Office 365.
You mean... InfoPath?
-
@blakeyrat Maybe, but InfoPath is deprecated.
-
@Captain Ok, well, Sharebuilder is as far as I can tell a stock trading site run by Capital One, so I have no idea what you're talking about.
-
I meant Sharepoint.
-
@Captain said in In which @Captain asks questions about Microsoft Office:
I meant Sharepoint.
Maybe if you said what you mean, then you wouldn't have wasted so much of my time.
-
@Captain said in In which @Captain asks questions about Microsoft Office:
I meant Sharepoint.
It does things. It can be a small social media site, and handle documents somewhat. It's painful to develop for.
-
@blakeyrat said in In which @Captain asks questions about Microsoft Office:
Maybe if you said what you mean, then you wouldn't have wasted so much of my time.
I'm SO SO SORRY I wasted 12 of your valuable seconds.
-
@Captain said in In which @Captain asks questions about Microsoft Office:
I'm SO SO SORRY I wasted 12 of your valuable seconds.
It was a lot more than that.
The awesome thing is I know exactly what SharePoint does, but now I'm not going to tell you.
-
-
@blakeyrat If you're in one of your moods, just quit posting a while. Seriously. You've wasted more time complaining than my typo wasted.
-
@Captain It wasn't a typo, you made like 4 posts before you figured out you had typed the wrong fucking word and sent all of us on a wild goose chase.
Look, I answered your question: you said, "what does thing that doesn't exist do?" and I answered, "it doesn't exist." Damn I'm helpful. You should give me all the StackOverflow internetpointzzz for that action.
-
OK, I have a Word document, and it has Boolean input controls. Can I use the values from those controls to conditionally display table rows and paragraphs?
-
@blakeyrat 2/10, boring.
-
@Captain said in In which @Captain asks questions about Microsoft Office:
InfoPath is deprecated.
Don't go there, there is only regret.
But yes you can use powershell
-
@Captain
I don't get it. You can use fields to display and manipulate SharePoint meta data in word. Doing actions on that data will depend on word and not SharePoint. I guess you could use VBA to hide/display text based on the value of a field.
-
@blakeyrat said in In which @Captain asks questions about Microsoft Office:
You should give me all the StackOverflow internetpointzzz for that action.
Equally spread out across all of your accounts.
-
@Luhmann Basically, I have to build a form and a business process to go along with it. Most of the process amounts to filling in check boxes (i.e., doing stuff and then making sure the document "knows" about it) and filling in some text fields and printing a letter.
I'm implementing this in Word, by making a form with text and boolean controls. For example, in step 1, HR fills in whether the new employee needs a computer. I'd like to know if it's possible to conditionally show table rows/form fields depending on whether the employee needs a desktop. (This isn't strictly speaking necessary, but it would be helpful).
The final step will be figuring out how to pass the data from the controls into the letter. (But I think that if I can do either this step or the previous one, I'd be able to figure out how to do the other)
-
@Captain This actually sounds like an excellent use-case for SharePoint with InfoPath forms...
Well, at least how I lastabused it...
-
@Captain
InfoPath can do that. Use it against a list. Don't mess around with the XML output files.
Or keep those Word files and see if Word can display a conditional blok. I do this in excel so I guess it is possible in word too.
It would depend on what you need to do after the filling.
-
@Luhmann
I'll elaborate a bit more:
What path you choose depends on what you want to do with the outcome. If you need a form because you need to print stuff and have a signature on it, then go with Word. You can use Word fields to capture meta-data (SharePoint properties) and display or change it in Word.
If you only need to capture some state, go with a SharePoint list. InfoPath is not a super dooper tool but it can get the job done if you need some optional fields, some checks and some 'fill the drop down depending on some other value' kind of stuff.
If you need digital approvals and steps, e.g. HRM selecting stuff and the 'form' then being send on to different teams consider using a SharePoint Workflow. You can create workflows either from Visual Studio or through SharePoint Designer. If you need something simple go with Designer.
-
I'll set the columns to Format
"T";;"F"
Now when you set the cell to 0, it'll display as "F", and when it's 1 it'll be displayed as "T"
Now add the formula to the third column and you're done:
=IF(OR(A1,B1), 1, 0)
-
@blakeyrat said in In which @Captain asks questions about Microsoft Office:
Maybe if you said what you mean, then you wouldn't have wasted so much of my time.
At least now we're focusing on what's really important.
-
@cheong said in In which @Captain asks questions about Microsoft Office:
I'll set the columns to Format
I like your solution ... it's a bit Evil ... like cooking up some RegExes ... it works but anyone else trying to figure it out might suffer brain damage in the process.
-
@Captain said in In which @Captain asks questions about Microsoft Office:
OK, here's a new question about Office: What does SharePoint do?
It acts like a bad imitation of Google Drive. It lets you share Office files via a web site, but if people want to edit the files, they have to be using IE(*), and if two people edit the same document at the same time, one of them will clobber the other's changes, unlike Google's offering which has had real-time collaborative editing for many years.
(*) You can check out, open, and edit the documents using other browsers, but you will never manage to check in the changed version unless you used IE to kick things off, so it just becomes a huge waste of time.
-
@devjoe said in In which @Captain asks questions about Microsoft Office:
a bad imitation of Google Drive
That's quite impressive for something that's been around since before Google Drive. Is the horse a bad imitation of the car?
-
@Magus said in In which @Captain asks questions about Microsoft Office:
It's painful to develop for.
Don't worry. It's also painful to use. It manages to look like it ought to be really quite nice, while managing to actually be horribly nasty in many different ways.
-
@devjoe said in In which @Captain asks questions about Microsoft Office:
they have to be using IE(*), and if two people edit the same document at the same time
I'm not saying SharePoint is perfect but at least get your facts straight. I can perfectly use Chrome or FF and collaborate simultaneous. It's not 2010 anymore.
-
@dkf said in In which @Captain asks questions about Microsoft Office:
horribly nasty in many different ways.
are you trying to set rights?
*shudder*
-
@Luhmann
Except for DocId links ... FF doesn't like those and Chrome is a toss up.
-
@Luhmann said in In which @Captain asks questions about Microsoft Office:
@cheong said in In which @Captain asks questions about Microsoft Office:
I'll set the columns to Format
I like your solution ... it's a bit Evil ... like cooking up some RegExes ... it works but anyone else trying to figure it out might suffer brain damage in the process.
That'd be necessary evil if the table is large. You'll save lots of evaluation time in calculation. (Instead of having everything in formula that will refreah on the instead the formula is set, the formatting part is only evaluated when the cells are visible or if the Excel file is to be saved.)
-
@blakeyrat said in In which @Captain asks questions about Microsoft Office:
@Captain It wasn't a typo, you made like 4 posts before you figured out you had typed the wrong fucking word and sent all of us on a wild goose chase.
Seriously? That's as much on you as it is on him.
When I saw the post, my brain autocorrected ShareTrade (or whatever it was) for "Sharepoint", because this is the Microsoft thread.
Obviously what he said was either completely wrong, or a typo. Most obvious being-- hmm--- Microsoft-- Share-- a TYPO.
How was your response not "Did you mean Sharepoint?"
I'd have accepted "You mean Sharepoint, you cunt-loafing assmuffin?"
But if you went on a hunt for the unlikely before confirming the likely, that's your own fault.
-
@Captain said in In which @Captain asks questions about Microsoft Office:
OK, here's a new question about Office: What does SharePoint do?
It provides job security for a bunch of highly paid consultants.
Aside from that, here's how it works:
We have Excel documents spread across this network share.
I usually have to save a second version because the first one is being worked on by someone else.
We should use SharePoint!{$50k and 6 months later}
We have Excel documents spread all across this very slow webpage on our Sharepoint portal
Half the time when I click on a document, nothing happens
Half the time when I click on a document, it doesn't open in Excel
More than once, I've done a ton of work, saved it, but SharePoint didn't upload it or something, so I lost everything, and I don't even now why.
Speaking of which, where's that Excel you said you were working on?
I couldn't figure out SharePoint, so I saved it to the old network share.{Sharepoint stops getting used, and sits quietly on a server, doing nothing}
-
@Luhmann said in In which @Captain asks questions about Microsoft Office:
are you trying to set rights?
No. Was just thinking about organising simple data like documents and spreadsheets without interpretation of the contents. Apparently, using any sort of hierarchical organisation is a bit of a no-no because you quickly hit a limit on the size of a URL (not sure if that's in IE or IIS), and a metadata-based organising system is only workable if the administrator configures it to be on and if the administrator has decided that the types of metadata you want to use are the types that he or she can be bothered to enable. So the sole actual organising principle that normal users can use is to just put everything in a big pile and hope that it is possible to rummage through and find the thing that you want. Our team (about 15 people) has generated thousands of documents of various kinds in one year (busy busy busy); browsing a single folder with thousands of files in it would suck, and making that folder be web-based will hardly make that suck go away.
Or maybe someone could invent a system that wasn't actually miserably awful to use at moderate scale.
-
@Lorne-Kates said in In which @Captain asks questions about Microsoft Office:
{Sharepoint stops getting used, and sits quietly on a server, doing nothing}
So that's a win!
-
@Luhmann said in In which @Captain asks questions about Microsoft Office:
@devjoe said in In which @Captain asks questions about Microsoft Office:
they have to be using IE(*), and if two people edit the same document at the same time
I'm not saying SharePoint is perfect but at least get your facts straight. I can perfectly use Chrome or FF and collaborate simultaneous. It's not 2010 anymore.
Yeah, these days SharePoint sucks equally on ALL browsers.