RachelL

Hello, I'm hoping someone from 360Works will have seen this issue before and can help. I can ask Microsoft for help as well but I figure you're the best place to start - and I don't have a ton of time to figure this out. I have a FileMaker solution with a script in which Scribe loads an excel workbook, and writes values. This excel workbook has a bunch of conditional formatting. The first three rows are static, but the rest is conditionally formatted, based on the value of the cell in a hidden column, changing depending on the row. The problem is that everything after row three is supposed to be size 11 font, and everything but column A is supposed to be centered. Everything in the template itself seems fine, but when I run the script and open the workbook, I find that most cells have changed to size 12 font and left justified (well, right justified after converting all the cells to numbers). It's odd though because scattered about, I see some that are centered and some that are size 11, with no apparent pattern. Have you seen something like this before? This is for a client who would like to run her FileMaker reports within the next week or two so I'm really hoping this can be resolved and I don't have to tell her to just correct all the formatting herself. So your help would be greatly appreciated! Thank you!

Thank you for your quick reply. No need to add the feature on my account. I'll need to get this done for my client within the next month or so. I'll be fine without a new Scribe feature - was just hoping it existed since it would cut the development time by a lot. Thank you though. Much appreciated!

Is is possible to insert a comment in excel? I don't see it anywhere in the documentation under the DocWriteValue function, but I just want to make sure. This is the problem I'm trying to solve: My client runs a script in FileMaker that uses Scribe to create an Excel document. Overall, the process has been working great, but she's requested something and I'm not sure the best way to accomplish it. She wants to add a large chunk of text (this is something that could take up the length of the screen and then some). If I were to do this in filemaker, I'd have to break the paragraph into however many lines are needed. I'm prepared to do that, but the easiest thing would be to simply store the text in a comment. Wrapping won't work because I'm still pasting it into a single cell. I'm assuming inserting text into a comment is simply not something Scribe does, but just want to rule it out before i do the work required in FileMaker (which would likely involve running a script to parse the paragraph into separate lines to be inserted as normal using DocWriteValue).