LDraw Torus Generator


RE: LDraw Torus Generator
#26
(2017-06-09, 15:12)Magnus Forsberg Wrote:
(2017-06-09, 14:46)Philippe Hurbain Wrote: Seems to work fine, the condlines look good. On my oooold Excel 2000 I had to comment out the cell tinting functions that seem to be unsupported, and I had to run the macro manually. But worked fine after that.
Edit: once the offending functions are removed, the macro autoruns fine!

It work fine here too, on Excel 2010. Only one issue. Is there a way to force excel to write a point instead of a comma?
If not, it's easy to replace them in LDDP or LDPE.

Try it now.  I added code to check your decimal separator when the workbook is opened.  If it's not a period, then it saves your current values, sets the decimal separator to a period, the thousands separator to a comma, and turns off the flag to use the system separator values.  It resets those values when you close the workbook.

This may affect other Excel spreadsheets that you have open concurrently.

Better way to do it:  since all the primitives are built up as strings, I Just replace all commas with periods before displaying them.  Let me know if you're still running into a problem.

Kevin
Reply
« Next Oldest | Next Newest »



Messages In This Thread
LDraw Torus Generator - by Kevin - 2017-06-06, 9:04
RE: LDraw Torus Generator - by Kevin - 2017-06-06, 18:40
RE: LDraw Torus Generator - by Kevin - 2017-06-07, 1:06
RE: LDraw Torus Generator - by Kevin - 2017-06-07, 7:36
RE: LDraw Torus Generator - by Kevin - 2017-06-08, 4:42
RE: LDraw Torus Generator - by Kevin - 2017-06-08, 9:26
RE: LDraw Torus Generator - by Kevin - 2017-06-08, 11:32
RE: LDraw Torus Generator - by Kevin - 2017-06-08, 16:04
RE: LDraw Torus Generator - by Kevin - 2017-06-09, 5:02
RE: LDraw Torus Generator - by Kevin - 2017-06-09, 8:57
RE: LDraw Torus Generator - by Travis Cobbs - 2017-06-10, 4:24
RE: LDraw Torus Generator - by Travis Cobbs - 2017-06-12, 4:16
RE: LDraw Torus Generator - by Kevin - 2017-06-09, 13:59
RE: LDraw Torus Generator - by Kevin - 2017-06-09, 14:59
RE: LDraw Torus Generator - by Kevin - 2017-06-09, 16:35
RE: LDraw Torus Generator - by Kevin - 2017-06-10, 3:11
RE: LDraw Torus Generator - by Kevin - 2017-06-10, 17:36
Google Docs port complete - by Kevin - 2017-06-11, 15:34
RE: LDraw Torus Generator - by Kevin - 2017-06-14, 16:44
RE: LDraw Torus Generator - by Kevin - 2017-06-15, 1:24
RE: LDraw Torus Generator - by Kevin - 2017-06-20, 13:54

Forum Jump:


Users browsing this thread: 5 Guest(s)